★★★★★
"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
- Excel interface review
- Workbook management
- Advanced worksheet features
- Named ranges
- Data organization
- Productivity shortcuts
Module 2: Advanced Formulas & Functions
- Logical functions
- Lookup functions
- Text functions
- Date and time functions
- Statistical functions
- Nested formulas
Module 3: Dynamic Array Functions
- Dynamic arrays
- FILTER
- SORT
- UNIQUE
- SEQUENCE
- Practical applications
Module 4: Lookup & Reference Techniques
- XLOOKUP
- INDEX and MATCH
- OFFSET
- INDIRECT
- Multi-criteria lookups
- Error handling
Module 5: Data Cleaning & Preparation
- Removing duplicates
- Text to columns
- Flash Fill
- Data validation
- Find and replace
- Data formatting
Module 6: Conditional Formatting
- Rule creation
- Formula-based formatting
- Data bars
- Color scales
- Icon sets
- Dashboard highlighting
Module 7: PivotTables
- Creating PivotTables
- Field management
- Grouping data
- Calculated fields
- Filtering
- PivotTable analysis
Module 8: Pivot Charts
- Chart creation
- Interactive reports
- Pivot chart formatting
- Trend visualization
- Dynamic charts
- Reporting techniques
Module 9: Data Visualization
- Column charts
- Line charts
- Bar charts
- Scatter plots
- Combo charts
- Best visualization practices
Module 10: Dashboard Design
- KPI dashboards
- Interactive dashboards
- Slicers
- Timelines
- Dashboard layout
- User-friendly reporting
Module 11: Power Query
- Importing data
- Data transformation
- Data merging
- Cleaning datasets
- Refreshing queries
- Query optimization
Module 12: Power Pivot Basics
- Data modeling
- Relationships
- Data model management
- Calculated columns
- Measures
- Analytical reporting
Module 13: Scenario & What-If Analysis
- Goal Seek
- Scenario Manager
- Data Tables
- Forecasting
- Sensitivity analysis
- Business simulations
Module 14: Financial & Business Analysis
- Budget analysis
- Sales analysis
- Profitability analysis
- Variance analysis
- Performance metrics
- Business reporting
Module 15: Automation with Macros
- Macro recording
- Editing macros
- Automation concepts
- Repetitive task automation
- Productivity improvement
- Macro security
Module 16: Data Validation & Controls
- Input validation
- Drop-down lists
- Error alerts
- Form controls
- Data integrity
- User-friendly worksheets
Module 17: Advanced Reporting
- Dynamic reports
- Executive summaries
- KPI tracking
- Report automation
- Business presentations
- Report formatting
Module 18: Business Analytics Techniques
- Trend analysis
- Variance analysis
- Performance tracking
- Forecast interpretation
- Decision support
- Business insights
Module 19: Data Security & Collaboration
- Workbook protection
- Worksheet protection
- Sharing workbooks
- Comments and notes
- Version management
- Collaboration features
Module 20: Excel Best Practices
- Spreadsheet standards
- Documentation
- Error prevention
- Performance optimization
- Model auditing
- Efficient workbook management
Module 21: Business Analytics Case Studies
- Sales analytics
- Financial reporting
- Inventory analysis
- HR analytics
- Operations dashboards
- Business decision scenarios
Module 22: Professional Analytics Workflow
- End-to-end data analysis
- Dashboard development
- Insight generation
- Report presentation
- Workflow optimization
- 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