Basic Excel – Module 2

Module 2 – 3 hours

1. Various Count Functions
2. Various Sum Functions
3. IF and AND functions
4. OR and NOT functions
5. Cell References
6. Date & Time Function
7. Text functions
8. VLOOKUP and HLOOKUP functions
9. MATCH, INDEX and CHOOSE functions.
10. Excel’s most popular financial functions.
11. Useful statistical functions in Excel.
12. The ROUND, ROUNDUP and ROUNDDOWN function.
13. Some common formula errors in Excel.
14. Single cell array formulas perform multiple calculations in one cell.