Advanced Excel

Excel Advanced Training Course London

1) New! Dynamic Array and new functions available MS 365.

Error #SPILL

2) Advanced functions:

  • INDEX & MATCH
  • SUMPRODUCT
  • INDIRECT
  • OFFSET
  • 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