Skip to content
Grow365
Digital SkillsIntermediate to AdvancedStudents and working professionals

Advanced Microsoft Excel

Take Excel from a grid to an analysis engine: lookup and dynamic-array formulas, pivot tables, Power Query transformations, dashboards and automation — practised on project and business datasets.

5 weeks · 25 hours
Live online · Classroom
Next batch 4 Aug 2026

What you'll be able to do

  • Use XLOOKUP, IF-family, text and dynamic-array formulas fluently
  • Summarise large datasets with pivot tables and slicers
  • Clean and combine data automatically with Power Query
  • Build interactive one-page dashboards
  • Automate repetitive steps and protect workbooks

Who should enrol

  • Engineers and analysts working with data daily
  • Planners and QSs building trackers
  • Anyone beyond Excel basics

Prerequisites

  • Comfortable with basic Excel formulas

Course modules

  1. 01

    Formula Mastery

    • XLOOKUP and INDEX/MATCH
    • Logical and text functions
    • Dynamic arrays
  2. 02

    Pivot Tables

    • Pivot design
    • Grouping and calculations
    • Slicers and timelines
  3. 03

    Power Query

    • Importing and cleaning data
    • Merging queries
    • Refreshable workflows
  4. 04

    Dashboards

    • Layout principles
    • Interactive charts
    • Conditional formatting
  5. 05

    Automation & Control

    • Named ranges and tables
    • Macros overview
    • Protection and validation

Software & standards

  • Excel (Microsoft 365)
  • Power Query
  • Pivot Tables

Practical projects

  • Build a refreshable project-progress dashboard from raw site data

Upcoming batches

4 Aug 2026Live onlineEvening · 19:00 – 21:00Registration open
Enrol in this batch

Your instructor

DS

Lead Instructor — Digital Skills

Microsoft-certified Trainer

9+ years industry experience

Profile to be published. Digital skills courses are led by a Microsoft-certified trainer who upskills engineering and project teams in Excel, Power BI and Office.

Specialisation
Excel, Power BI and Office productivity for technical teams
Certifications
Microsoft Certified Trainer (MCT) · Data Analyst Associate (PL-300)
Projects & sectors
Corporate training · Engineering teams · Finance functions

Teaches

Frequently asked questions

A recorded-macro introduction is included; deep VBA programming is out of scope by design — Power Query covers most automation needs.

Ask us anything

Tell us what you want to learn and an advisor will get back to you within one working day.

By submitting, you agree to our privacy policy. We never share your details.

Related courses

Digital SkillsIntermediate

Power BI

Build interactive business dashboards from raw data with Power BI.

Starts 18 Aug 2026View course
Chat with an advisor