"The structure, the practice exams, the instructor — all top tier. Passed first try."
Course Outline
What the programme covers, module by module.
Module 1: Advanced Excel Fundamentals
- Workbook management
- Advanced worksheet features
- Named ranges
- Workbook navigation
- Productivity shortcuts
- Best practices
Module 2: Advanced Formulas & Functions
- IF and nested IF
- IFS function
- XLOOKUP
- INDEX & MATCH
- SUMIFS
- COUNTIFS
Module 3: Logical & Lookup Functions
- VLOOKUP
- HLOOKUP
- XLOOKUP
- CHOOSE
- SWITCH
- Error handling functions
Module 4: Data Validation
- Input validation
- Drop-down lists
- Custom validation
- Error alerts
- Data restrictions
- Form controls
Module 5: Conditional Formatting
- Rule-based formatting
- Formula-based formatting
- Data bars
- Color scales
- Icon sets
- Dynamic highlighting
Module 6: Advanced Data Management
- Excel Tables
- Sorting
- Advanced filtering
- Remove duplicates
- Flash Fill
- Text to Columns
Module 7: PivotTables
- PivotTable creation
- Field settings
- Calculated fields
- Grouping data
- Filtering
- Interactive summaries
Module 8: Pivot Charts
- Pivot Chart creation
- Interactive charts
- Slicers
- Timelines
- Dashboard visuals
- Report customization
Module 9: Charts & Data Visualization
- Combo charts
- Waterfall charts
- Scatter charts
- Trendlines
- Sparklines
- Professional chart formatting
Module 10: Dashboard Development
- KPI dashboards
- Interactive dashboards
- Dynamic charts
- Dashboard layouts
- Slicers
- Executive reporting
Module 11: Power Query
- Importing data
- Cleaning data
- Data transformation
- Merging datasets
- Query refresh
- Automation basics
Module 12: Power Pivot Fundamentals
- Data models
- Relationships
- Measures
- Calculated columns
- Data analysis
- Reporting
Module 13: What-If Analysis
- Goal Seek
- Scenario Manager
- Data Tables
- Forecasting
- Sensitivity analysis
- Business simulations
Module 14: Macros
- Macro recording
- Editing macros
- Automating tasks
- Macro-enabled workbooks
- Productivity improvement
- Macro security
Module 15: Financial & Business Reporting
- Report creation
- KPI tracking
- Business summaries
- Executive reports
- Report formatting
- Presentation-ready outputs
Module 16: Collaboration Features
- Workbook sharing
- Comments
- Notes
- Version history
- Protection
- Team collaboration
Module 17: Workbook Protection & Security
- Worksheet protection
- Workbook protection
- Password security
- File permissions
- Data integrity
- Secure sharing
Module 18: Excel Productivity Techniques
- Keyboard shortcuts
- Quick Analysis
- Templates
- Named ranges
- Formula auditing
- Efficient workflows
Module 19: Business Data Analysis
- Trend analysis
- Variance analysis
- Performance tracking
- Business metrics
- Decision support
- Insight generation
Module 20: Report Automation
- Dynamic reports
- Refreshable reports
- Automated calculations
- Dashboard updates
- Data consolidation
- Reporting workflows
Module 21: Real-World Excel Applications
- Sales reporting
- Budget tracking
- Inventory management
- HR reporting
- MIS reporting
- Business case studies
Module 22: Professional Excel Best Practices
- Spreadsheet standards
- Error checking
- Documentation
- Performance optimization
- Workbook organization
- Industry best practices
Who it's for & what's included
Pick a delivery method to see exactly who it suits and everything you receive.
Classroom
Best for learners who want face-to-face tuition and to network with peers in person.
Everything you get
- ✓ Live instructor on-site
- ✓ Printed workbook & materials
- ✓ Group exercises & case studies
Online Instructor-Led
Best for learners who want a live instructor and a fixed schedule, without the travel.
Everything you get
- ✓ Live instructor via video call
- ✓ Digital workbook & resources
- ✓ Session recordings
Self-Paced
Best for self-motivated learners who need maximum flexibility around work and life.
Everything you get
- ✓ On-demand video lessons
- ✓ Interactive quizzes
- ✓ 24/7 access on any device
Course Overview
The Microsoft Excel Advanced program equips learners with advanced spreadsheet techniques for handling complex data, automating repetitive tasks, and creating professional reports. Participants learn advanced formulas, PivotTables, data validation, conditional formatting, dashboards, Power Query, macros, and business reporting techniques to improve productivity and support informed decision-making across various business functions.