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
Named range
Multiple formula
Array formulas
Auditing formulas
Data validation
Condition formatting
PivotTables and PivotCharts
Protection
For more information or if you have any questions, I would be happy to talk through more details of our services as well as providing a free quotation before starting any project.
B) Functions:
Other Training
Also, we provide Excel trainings for all levels.