- Knowledge on using sorting and filtering functions effectively
- What-if analysis and goal seek
- Pivot tables and consolidation
- Analysis tool pack and other MS Excel add-ons
- Introduction to Excel data model and databases
- Producing charts and graphs
- Power-up MS Excel with advanced formulas