Advanced Microsoft Excel

About Course

Advance your spreadsheet expertise with the Advanced Microsoft Excel programme and master high-demand business skills in Advanced Excel, Data Analysis, Business Intelligence, Dashboard Development, Financial Modeling, Data Automation, Power Query, Power Pivot, and Excel Reporting using industry best practices. This comprehensive training is designed for professionals, analysts, accountants, project managers, business executives, and aspiring data analysts seeking to automate complex tasks, analyze large datasets, create interactive dashboards, and improve business decision-making. Through real-world projects and practical case studies, learners will develop advanced Excel solutions that enhance productivity, streamline business operations, and support data-driven decision-making across industries.

Apply advanced logical, lookup, and dynamic array functions
Manage complex data validation and conditional formatting
Build advanced PivotTables, slicers, and interactive reports
Import, clean, and transform data with Power Query
Build data models and DAX calculations with Power Pivot
Design KPI and executive dashboards
Automate reports using Macros and VBA
Apply financial modeling, budgeting, and scenario analysis
Build a fully automated executive dashboard capstone project

Course Content

Module 1: Advanced Excel Functions & Formulas
• Advanced Logical Functions • Lookup & Reference Functions • Dynamic Array Functions • Text & Date Functions

Module 2: Data Management & Analysis
• Data Validation • Conditional Formatting • Advanced Sorting & Filtering • Named Ranges

Module 3: PivotTables & Pivot Charts
• Advanced PivotTables • Pivot Charts • Slicers & Timelines • Interactive Reporting

Module 4: Power Query
• Data Import • Data Cleaning • Data Transformation • Data Consolidation

Module 5: Power Pivot & Data Modeling
• Data Models • Relationships • DAX Fundamentals • Business Calculations

Module 6: Dashboard Design & Data Visualization
• KPI Dashboards • Interactive Dashboards • Charts & Graphs • Executive Reporting

Module 7: Excel Automation
• Macros • VBA Fundamentals • Automated Reports • Workflow Automation

Module 8: Financial Modeling & Business Analysis
• Financial Modeling • Budgeting & Forecasting • Scenario Analysis • What-If Analysis

Module 9: Capstone Project
Develop a fully automated executive dashboard that integrates Power Query, Power Pivot, advanced formulas, VBA automation, and interactive reporting to solve a real-world business challenge.

Student Ratings & Reviews

No Review Yet

About Course

What Will You Learn?

Course Content

Module 1: Advanced Excel Functions & Formulas • Advanced Logical Functions • Lookup & Reference Functions • Dynamic Array Functions • Text & Date Functions

Module 2: Data Management & Analysis • Data Validation • Conditional Formatting • Advanced Sorting & Filtering • Named Ranges

Module 3: PivotTables & Pivot Charts • Advanced PivotTables • Pivot Charts • Slicers & Timelines • Interactive Reporting

Module 4: Power Query • Data Import • Data Cleaning • Data Transformation • Data Consolidation

Module 5: Power Pivot & Data Modeling • Data Models • Relationships • DAX Fundamentals • Business Calculations

Module 6: Dashboard Design & Data Visualization • KPI Dashboards • Interactive Dashboards • Charts & Graphs • Executive Reporting

Module 7: Excel Automation • Macros • VBA Fundamentals • Automated Reports • Workflow Automation

Module 8: Financial Modeling & Business Analysis • Financial Modeling • Budgeting & Forecasting • Scenario Analysis • What-If Analysis

Module 9: Capstone Project Develop a fully automated executive dashboard that integrates Power Query, Power Pivot, advanced formulas, VBA automation, and interactive reporting to solve a real-world business challenge.