Microsoft Excel 2019

Course objective

Expand your knowledge of Microsoft Excel; one of the most highly rated, and globally recognised productivity tools. Learn functions, formulas, data interpretation, integration, charts and templating for business, budgeting, sales and more. The course thoroughly covers everything you need to know to sit your MO-200 exam objectives with confidence to gain your globally recognised certification. This course is suitable for self-motivated learners who would like to gain the flexibility of self-paced study.

What is included

  • Interactive eBook
  • Practice quizzes
  • Pre and post study assessments
  • Virtual labs
  • Flashcards

Course outline

  1. Introduction
  2. Fundamentals
  3. Creating worksheets
  4. Formatting
  5. Manipulating data
  6. Charts
  7. Output
  8. Settings and templates
  9. Introduction
  10. Managing workbooks
  11. Named ranges
  12. Tables
  13. Summarizing data
  14. PivotTables
  15. Presentation features
  16. Advanced charts
  17. Collaboration
  18. Introduction
  19. Logical and Lookup Functions
  20. Advanced formulas
  21. Special functions
  22. Importing and exporting
  23. Analysis
  24. Macros and forms
  25. Appendix: Exam objective MO-201