Sign in Start learning
Home › Courses › Advanced Excel
Intermediate 8 hours of video 51 lessons Exercise files included Certificate of completion

Advanced Excel

Dynamic arrays, advanced lookups, financial and statistical functions, and models that are built to be audited.

Buy this course — €30 All 9 courses for €65

About this course

Advanced Excel is not about knowing more functions. It is about building spreadsheets that a stranger can open, understand and trust. This course covers the modern function set — dynamic arrays, LET, LAMBDA — alongside the modelling discipline that separates a working file from a professional one.

What you will be able to do

  • ✓Use dynamic arrays: FILTER, SORT, SORTBY, UNIQUE, SEQUENCE and spill behaviour
  • ✓Write readable formulas with LET, and reusable ones with LAMBDA
  • ✓Handle multi-criteria lookups without fragile nested constructions
  • ✓Apply SUMIFS, COUNTIFS, AVERAGEIFS and database functions to real reporting problems
  • ✓Build scenario analysis with data tables, Goal Seek and Solver
  • ✓Use the core financial functions: NPV, IRR, PMT, and amortisation schedules
  • ✓Audit a model you did not write: trace precedents, evaluate formulas, isolate errors
  • ✓Structure a workbook into input, calculation and output layers that anyone can follow

Course content

8 modules · 51 lessons · approximately 8 hours of video

Module 1 — The modern formula engine

Dynamic arrays and spill ranges. FILTER, UNIQUE, SORT, SORTBY, SEQUENCE and RANDARRAY. How spilling changes the way you design a sheet.

Module 2 — Readable and reusable logic

LET for naming intermediate steps. LAMBDA for building your own functions. When a helper column beats a clever formula.

Module 3 — Advanced lookup patterns

Two-way lookups, approximate matching, wildcard matching, and multi-criteria retrieval done cleanly.

Module 4 — Aggregation and conditional maths

SUMPRODUCT, SUMIFS, COUNTIFS, AGGREGATE and subtotal behaviour in filtered data.

Module 5 — Scenario and sensitivity analysis

One and two-variable data tables, Goal Seek, Scenario Manager and an introduction to Solver.

Module 6 — Financial modelling basics

Time value of money, NPV and IRR, loan schedules, and the assumptions block every financial model needs.

Module 7 — Auditing and error control

Trace precedents and dependents, Evaluate Formula, error-handling with IFERROR done responsibly, and a model review checklist.

Module 8 — Workbook architecture

Separating inputs, workings and outputs. Documentation, a cover sheet, and naming conventions that survive handover.

Requirements

  • A computer with Microsoft Excel installed. Microsoft 365 is recommended; where a feature is version-dependent, the lesson states this and shows the alternative approach.
  • No software is provided with this course. Learners must hold their own licence for any Microsoft product used.
  • Roughly 8 hours of study time, which you can spread over as long as you like — access does not expire.

Other courses

Beginner 6 h

Microsoft Excel Essentials

Build a solid, reliable foundation in Excel: structure, formulas, formatting and the habits that prevent broken spreadsheets.

View course →
Intermediate 6 h

Power Query

Stop cleaning the same file every month. Build repeatable transformations that refresh with one click.

View course →
Advanced 7 h

Power Pivot & Data Modelling

Relationships, star schemas and DAX measures — the data model behind every serious Excel report.

View course →