Basic Excel – Module 6

Module 6 – 3 hours

1. Subtract
2. Percentage
3. ISNUMBER and the SEARCH function in Excel
4. PMT function in Excel
5. DATEDIF function and the TODAY function
6. Wrap text in Excel
7. Use the INDIRECT function in Excel
8. PRODUCT function
9. SUBTOTAL function in Excel
10. Goal Seek
11. CAGR function in Excel
12. IF function and the ISBLANK function.
13. AVERAGE function in Excel
14. Use the MID, LEFT, RIGHT, FIND, LEN, SUBSTITUTE, REPT, TRIM and the MAX function in Excel to
    extract substrings.