Advanced Excel

Excel Advanced Training Course London

1) NEW! What’s new in Excel for Microsoft 365

A) Dynamic Array
B) Functions:

C) Errors.

  • #SPILL!
  • #CALC!

 

2) Advanced functions:

  • INDEX & MATCH
  • SUMPRODUCT
  • INDIRECT
  • OFFSET
  • SWITCH
  • CHOOSE

3) Array formulas
4) Depends drop down list
5) Dynamic range
6) Dynamic charts
7) PivotTables and Pivot Charts
8) Advanced Condition Formatting
8) Advanced Data Validation
10) Macros
11) Develop Ribbon