★★★★★
"The structure, the practice exams, the instructor — all top tier. Passed first try."
AS
Aarti SharmaSenior Project Manager · TCS
— The journey
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
— 01.2 · Is it right for you?
Who it's for & what's included
Pick a delivery method to see exactly who it suits and everything you receive.
Who it's for
Classroom
Best for learners who want face-to-face tuition and to network with peers in person.
What's included
Everything you get
- ✓ Live instructor on-site
- ✓ Printed workbook & materials
- ✓ Group exercises & case studies
Who it's for
Online Instructor-Led
Best for learners who want a live instructor and a fixed schedule, without the travel.
What's included
Everything you get
- ✓ Live instructor via video call
- ✓ Digital workbook & resources
- ✓ Session recordings
Who it's for
Self-Paced
Best for self-motivated learners who need maximum flexibility around work and life.
What's included
Everything you get
- ✓ On-demand video lessons
- ✓ Interactive quizzes
- ✓ 24/7 access on any device