Advance Excel

If you are at the level of knowledge already that a basic or intermediate Microsoft Excel course wont do you any good, then it is time to consider perfecting your skills with an advanced Excel training class. These advanced courses will round off your skill set with Microsoft's popular spreadsheet program, make you more efficient in the workplace and will open up many doors professionally and will be a great weapon in your arsenal for your own career progression.

After you have finished with the information in this article you will hopefully be able to determine for yourself if training yourself on Excel to an advanced standard would benefit you or your business.

Syllabus for Advance Excel

  1. Introduction 
  2. Using Excel lists
  3. Creating a List
  4. Sorting
  5. Marksheets / Salary Sheets
  6. Filtering Data
  7. Advanced Filters
  8. Totals and Subtotals 
  9. Managing Windows
  10. Freezing Panes
  11. Linking Data
  12. Analysis by goal seek
  13. Analysis by pivot tables
  14. Pivot Charts
  15. Text to Columns
  16. Consolidate
  17. Using Macros
  18. Validations
  19. Scenario Manager
  20. Time Management Table
  21. Creating Lists Using Validations
  22. V LookUp
  23. H LookUp
  24. Importing Data
  25. Formulas