Model Online / On-Site
Duration
Modules 6 modules

Course Objective & Scope

Excel remains the most widespread analysis tool in organisations, yet many users lose time with nested formulas and manual copy-paste. The programme teaches table structure, XLOOKUP and INDEX/MATCH, the SUMIFS family, dynamic array functions such as FILTER, UNIQUE, SORT and LET, and PivotTables and PivotCharts hands-on.

Goal Seek, Data Tables and Scenario Manager are used for scenario analysis, followed by an introduction to Power Pivot for multi-table analysis. Participants build an end-to-end analysis workbook on a sales or cost dataset adapted from the organisation.

Who Should Attend?

  • Specialists in finance, sales, HR and operations
  • Executive assistants and coordinators preparing regular Excel reports
  • Employees moving into analytical roles
  • Prerequisite: basic Excel formula knowledge

Key Takeaways

  • Structure and clean data with Excel tables
  • Build flexible formulas with XLOOKUP and dynamic arrays
  • Create multi-dimensional summaries and slicers with PivotTables
  • Run scenario and sensitivity analysis with What-If tools
  • Relate multiple tables with Power Pivot

Curriculum

Structuring and Cleaning Data
  • Excel tables, data validation and duplicates
  • Fixing data with text and date functions
Lookup and Conditional Calculation Functions
  • XLOOKUP, INDEX/MATCH
  • SUMIFS, COUNTIFS, AVERAGEIFS
Dynamic Array Functions
  • FILTER, UNIQUE, SORT and SEQUENCE
  • Readable formulas with LET
PivotTables and PivotCharts
  • Grouping, calculated fields and percentage views
  • Slicers and timelines
What-If and Scenario Analysis
  • Goal Seek, Data Tables and Scenario Manager
  • Sensitivity tables
Introduction to Power Pivot and Case Study
  • Data model and relationships
  • End-to-end analysis workbook

Other Courses in This Category

  • Python in Excel: Automating Analysis with pandas

    Python in Excel (=PY), pandas for cleaning and transforming data, openpyxl report automation and matplotlib charts, helping Excel users scale repetitive analysis with Python.

    Business Intelligence & Analytics Corporate
    Live Course
    6 modules
    View
  • SQL and Power BI for Business Analysts

    Querying databases with SELECT, JOIN, GROUP BY, CTEs and window functions, then modelling and reporting in Power BI, so business analysts produce their own analyses without depending on IT.

    Business Intelligence & Analytics Corporate
    Live Course
    6 modules
    View
  • Tableau for Data Analysis and Dashboards

    Data connections, dimensions and measures, calculated fields, LOD expressions, parameters and interactive dashboard design in Tableau Desktop, plus publishing to Tableau Cloud for visual analysis.

    Business Intelligence & Analytics Corporate
    Live Course
    6 modules
    View
  • AI-Assisted Data Analysis and Reporting

    Copilot in Power BI and Excel, data analysis with ChatGPT/Claude, natural-language querying, automated summaries and insight generation with output verification, so analysts turn AI output into trustworthy reports.

    Business Intelligence & Analytics Corporate
    Live Course
    6 modules
    View
  • Microsoft Power BI Fundamentals Basic Power BI

    Foundational Microsoft Power BI training covering data connections, Power Query transformations, Star Schema data modeling, basic DAX measures, and interactive dashboards.

    Business Intelligence & Analytics Corporate
    Live Course
    9 modules
    View
  • Microsoft Power BI Essentials Power BI Essentials

    Comprehensive Power BI training for business intelligence teams covering Power Query ETL, relational Star Schema modeling, DAX calculations, Power BI Service, and executive dashboards.

    Business Intelligence & Analytics Corporate, Individual
    Live Course
    9 modules
    View

Get in touch