Module 1: Foundations of Advanced Excel
- · Efficiency and Risk
- · Templates
- · Increasing Efficiency and Reducing Risk
- · Data Validation
- · Advanced Techniques
Module 2: Advanced Functions and Formulas
- · Functions with Superpowers
- · Array Formulas
- · Tables
- · Advanced Range Names
Module 3: Data Analysis and Visualization
- · What If Analysis
- · Problem Solving
- · Excel Interactivity
- · Form Controls
- · Conditional Formatting
- · Charts that Inspire
- · Sparklines
- · Graphics Tricks and Techniques
Module 4: Advanced Data Management and Reporting
- · Turning Data into Decisions
- · Working with External Data
- · Advanced Uses of PivotTables
- · PowerPivot
- · Reporting with PowerPivot
Module 5: Course Plenary and Revision
- · Course Plenary
- · Revise what you have learned
Note: The syllabus can be customized based on the requirements of the learners or the location.