Excel Advanced

Associated Courses

R900.00 R450.00


The Excel Advanced Course includes the following modules:

  1. Create and use Tables
  2. Analyze Data with PivotTables
  3. Use Countif and Sumif Functions
  4. Use Advanced Text Functions
  5. Understand the Vlookup Function
  6. Do Magic with the IF Function
  7. Use the PMT Function
  8. Use Flash Fill
  9. Use Advanced Sorting
  10. Use Advanced Filters
  11. Apply Conditional Formatting
  12. Use Advanced Chart Options
  13. Use the Quick Analysis Tool
  14. Use What-if Tools
  15. Import and Export Data
  16. Auditing Worksheets
  17. Record and Run Macros
  18. Sharing Workbooks
  19. Compare and Merge Workbooks
  20. Customize the Ribbon