Module | Download PDF |
Advance Excel | |
Lesson – 1 – Function Reference-Lookups | Download |
Lesson – 2 – Data Shorting | Download |
Lesson – 3 – Conditionally Formatting | Download |
Lesson – 4 – Data Validation | Download |
Lesson – 5 – Consolidation | Download |
Lesson – 6 – Text Function | Download |
Lesson – 7 – Date and Time Function | Download |
Lesson – 8 – Financial Function | Download |
Lesson – 9 – Logical Function | Download |
Lesson – 10 – Math and Trig | Download |
Lesson – 11 – Statistical Function | Download |
Lesson – 12 – Pivot Table Report | Download |
Lesson – 13 – Pivot Chart Report | Download |
Lesson – 14 – Compairing PTR and TCR | Download |
Lesson – 15 – MIS Report | Download |
Lesson – 16 – How to create Macros | Download |
Lesson – 17 – What If Analysis-Data Table | Download |
Lesson – 18 – What If Analysis-Scenario | Download |
Lesson – 19 – What If Analysis-Goal Seek | Download |