Fast Track Data Analysis in Excel Training Program
0Comments

About Edate

Question: We use edate function for finding the date after  certain months .do we have similar functions for years and days?   Answer: As far as we know, edate is the only...
Fast Track Data Analysis in Excel Training Program
0Comments

Why HR need to use Excel?

1. To monitor the renewal of passports/work permits 2. Calculate anniversaries of employeesbr 3. Track trainin programs attended by employeesbr 4. Analyse benefits paid out 5....
Fast Track Data Analysis in Excel Training Program
0Comments

Display Product Image

This solution is created with a combination of functions and formula. The frame for the changing image is created using the Camera function in Excel. Adding the Offset and...
Fast Track Data Analysis in Excel Training Program
0Comments

Autofill Frustration

Question: when I drag a date to the line below it, the date advances by one day. I don’t want this. I would like the same date to drag down each time Answer: If you turn...
Fast Track Data Analysis in Excel Training Program
0Comments

Financial Quarters

If your company has financial year that does not coincide with the calendar year, you will have problem presenting your numbers in Financial Quarters, especially when you have...