Combine Non-Identical Worksheets Dynamically – Power Query Function
Dynamic Report with Power Query and VLookup – Approximate Match
Pivot Tables Course For Beginners
12 Secrets for Creating Pivot Tables – Advanced Excel
Lambda and Let Functions Together for a Single Cell Report
Naming Cells and Ranges – Start File
The Scrolling List- Start File
Filter Non Adjacent Columns in a List or Table – Start File
Dynamic Calendar For Any Month or Year
Secrets of Lists and Tables
Introducing The Lambda Function
Master Class – Dependent Drop List Start File.
Download The Expiry Date File
Impress Your Audience with Scenario Manager – Start File
