top of page

What’s Included in Our Advanced Microsoft Excel Course?

  • 7 days ago
  • 2 min read

Our Advanced Excel Course is designed for professionals who already use Excel confidently and want to move into high-level data analysis, automation, and reporting.


This course focuses on working smarter with large datasets, building powerful reports, and using Excel as a true analytical tool.


If you already understand formulas, PivotTables, and basic lookups, this course will take your skills to a professional level.



Who Is This Course For?


This course is ideal if:


  • You already use IF statements and lookups confidently

  • You regularly work with large datasets

  • You use PivotTables for reporting

  • You want to automate tasks and reduce manual work

  • You work in finance, operations, reporting, or data-focused roles


You may not need this course if you are still learning basic formulas or have never used PivotTables.



What You Will Learn


Below is a full overview of the syllabus so you can assess your current level.


1️⃣ Advanced Logical & Nested Formulas

  • Complex IF structures

  • Combining multiple logical tests

  • Using AND / OR within advanced formulas

  • Error handling with IFERROR


You will learn how to build decision-making models within Excel.


2️⃣ INDEX and MATCH

  • Replacing VLOOKUP with more powerful lookups

  • Two-way lookups

  • Dynamic data retrieval

  • Understanding how lookup engines really work


This is a key skill in analytical and finance roles.


3️⃣ Advanced Lookup Techniques

  • XLOOKUP in full detail

  • Handling missing data

  • Searching vertically and horizontally

  • Creating dynamic return arrays


4️⃣ Dynamic Array Functions

  • FILTER

  • SORT

  • UNIQUE

  • SEQUENCE


You will learn how to create responsive, automatically updating reports.


5️⃣ Advanced PivotTables

  • Calculated fields

  • Custom groupings

  • Advanced filtering

  • Pivot performance optimisation


6️⃣ Slicers and Timelines

  • Creating interactive reports

  • Building user-friendly dashboards

  • Improving data navigation


7️⃣ Power Query (Data Import & Transformation)

  • Importing data from external sources

  • Cleaning and reshaping data

  • Removing duplicates

  • Automating data preparation


This is where Excel becomes a data transformation tool.


8️⃣ Data Cleaning Techniques

  • Handling inconsistent data

  • Removing errors

  • Text-to-columns

  • Flash Fill

  • Managing large datasets efficiently


9️⃣ What-If Analysis & Forecasting

  • Goal Seek

  • Scenario Manager

  • Data Tables

  • Sensitivity analysis


🔟 Dashboard Design & KPI Reporting

  • Structuring a dashboard

  • Designing professional layouts

  • Linking charts dynamically

  • Creating performance summaries


1️⃣1️⃣ Introduction to Macros

  • Recording a Macro

  • Understanding VBA basics

  • Automating repetitive tasks

  • Macro security awareness


Workbook Optimisation & Best Practice

  • Reducing file size

  • Structuring large workbooks

  • Naming conventions

  • Building maintainable models


What You Will Be Able To Do After This Course


By the end of this course, you will be able to:


✔ Analyse large datasets confidently

✔ Build dynamic, automated reports

✔ Replace manual processes with formulas and tools

✔ Create professional dashboards

✔ Clean and transform data efficiently

✔ Automate repetitive tasks


💡 Do You Need This Course?


You likely need this course if:


  • You spend hours manually cleaning data

  • You rely heavily on VLOOKUP

  • You don’t use Power Query

  • You don’t automate repetitive reporting tasks

  • You want to progress into finance, reporting, or data-focused roles


If you already confidently use dynamic arrays, advanced modelling, Power Query, dashboards, and macros, you are likely operating at expert level.

Comments

bottom of page