MS EXCEL INTERMEDIATE

OVERVIEW

This course will teach you from basic formulas to the most advanced ones, functions, validations and charts. This way you can be a powerful MS Excel user. This course is designed for specialists aiming at becoming MS Excel advanced users.

Audience

This course is recommended for students, graduated students, business analytics and anyone aiming to become an expert in using MS Excel.

COURSE OUTLINE

  1. Basic formulas
  2. Text Formulas
  3. Small and big formulas
  4. VLookup formulas
  5. Index formulas
  6. Match formulas
  7. Relative and Absolute cell references in formulas
  8. Paste special + formula editing tips and tricks
  9. Format cells
  10. Using Excel tables
  11. Conditional formatting
  12. Pivot tables
  13. Basics of graphics
  14. Filter and advanced ordering
  15. Validation

PREREQUISITES

Basic or very basic MS Excel knowledge.

PURCHASE