Dynamic Formulas Unleashed
The new era of Excel is here – upgrade your skills and stay ahead
Are you dragging formulas or extending ranges for new data?
You’re working too hard!
Traditional Excel methods force you to:
- Use manual actions to update reports.
- Repeat the same tasks over and over.
- Copy & paste interim results to use in other calculations.
✓ Learn how to avoid this pain.
Formulas in Excel should be seamless – when inputs change, everything updates – that’s how it should be. But that is rarely the case. Instead, formulas break and need constant adjustments. This leaves you constantly firefighting issues.
It’s disheartening that even simple updates could trigger hours of re-work. You know Excel is capable of incredible things, yet you don’t quite know how to achieve it.
Instead of focusing on what you’re paid to do (analysis, gaining insights, adding value), you’re spending all your time just trying to get the numbers to calculate correctly.
It’s time to move beyond outdated Excel practices.
We know the struggle, we know the solution:
We understand the frustration of battling with broken formulas. We’ve been there ourselves, and we know how much valuable time it wastes.
That’s why we created the Dynamic Formulas Unleashed course.
We will guide you step by step through Excel’s most revolutionary feature: the dynamic array calculation engine. You will learn to create self-updating models, automate complex tasks, and eliminate manual updates.
Watch the video
The Dynamic Formulas Unleashed course is only available within the Excel Academy.
Your path to success is as simple as 1-2-3.
Join the Excel Academy
Enrol today to get instant access to the Dynamic Formulas Unleashed course.
Follow the course
Discover how Excel formulas really work, explore the new dynamic array formulas, and solve real-world use cases.
Apply the learning
Implement your new skills to remove manual updates, reduce errors, and save time every day.
The course goes through a clear, step-by-step approach that will lead you from basics to mastery. By the end of Dynamic Formulas Unleashed, you will be creating formulas that you previously thought impossible with ease.
Stop working harder than you need to. Let Excel do the heavy lifting.
The Dynamic Formulas Unleashed course is only available within the Excel Academy.
What’s included?
✓ 10 hours of on-demand video (130+ lessons)
✓ Real-world scenarios to work through
✓ Exercises and quizzes
✓ Certificate of completion
✓ English closed captions
✓ Ask questions and get expert answers
Syllabus:
Introduction
- Welcome & learning journey
- About the exercises
- Download the support files
Formulas & functions 101
- Formulas and functions 101 – Introduction
- Formulas vs Functions: What’s the difference
- Formula & function Syntax
- Function tools
- Data types
- Understanding numbers
- Understanding dates
- Operators
- Order of Calculation BODMAS/PEDMAS
- TRUE Times Tables
- Understanding error messages
- Volatile functions
- Formulas & functions 101 – Quiz
Arrays & ranges
- Ranges and arrays – Introduction
- Understanding ranges
- Range formulas
- Dynamic ranges – Example
- Spilling & spill ranges
- Combining range & spill operators
- Combining range functions & spill operators
- Exercises – Ranges
- Understanding arrays
- Ranges vs arrays
- Introduction to Tables
- Table structured references
- 3D references
- Scalar values & lifting
- Pairwise lifting
- Broadcasting
- Spilling & absolute cell references
- Exercises – Arrays, lifting & broadcasting.xlsx
- Array of arrays
- Function issues
- Formatting issues
- Ranges and arrays – Quiz
Generating numbers
- Generating numbers – Introduction
- SEQUENCE function
- Number patterns
- Other functions spill with SEQUENCE
- RANDARRAY function
- SEQUENCE & RANDARRAY – Examples
- Exercises – SEQUENCE, RANDARRAY & Patterns
- Generating numbers – Quiz
Lookup, filtering and sorting
- Lookup, filtering and sorting – Introduction
- UNIQUE function
- FILTER function
- SORT function
- Simple Pivot Report – Example
- SORTBY function
- Sorting a FILTER – Example
- Reverse order – Example
- Exercises – UNIQUE, FILTER, SORT & SORTBY
- FILTER function – beyond the basics
- XLOOKUP function
- XLOOKUP function – beyond the basics
- XMATCH function
- SORTBY Days of the week – Example
- Exercises – FILTER, XLOOKUP & XMATCH
- Lookup, filtering and sorting – Quiz
Splitting, combining & shaping arrays
- Splitting, combining & shaping arrays – Introduction
- TOCOL & TOROW
- WRAPCOLS & WRAPROWS
- HSTACK & VSTACK
- Combining arrays across sheets – Example
- Include total in an array – Example
- Exercises – Array reshaping
- CHOOSECOLS & CHOOSEROWS
- Dynamic column selection
- Basic unpivot – Example
- TAKE & DROP functions
- Dynamic unpivot – Example
- Dependent drop down lists – Example
- INDEX function
- Comparing row & column selection functions
- XLOOKUP – array of arrays – Example
- EXPAND
- Exercises – Array Selection
- Splitting, combining & shaping arrays – Quiz
Manipulating text
- Manipulating text – Introduction
- Basic text functions
- REPLACE & SUBSTITUTE functions
- TEXTAFTER & TEXTBEFORE functions
- Get workbook info – Exercise
- CONCAT & TEXTJOIN functions
- TEXTSPLIT function
- FILTER on comma separated list – Example
- TEXTSPLIT – Basic array of arrays – Example
- Exercises – Manipulating text
- Manipulating text – Quiz
Logic
- Logic – Introduction
- Boolean logic calculations
- Using IF
- AND/OR are aggregators
- Nested IF alternatives
- IFS & SWITCH – multiple conditions
- Dynamic logic report – Example
- Exercises – Logic
- Logic – Quiz
Variables & custom functions
- Variables & custom functions – Introduction
- LET function
- Revisiting examples with LET – Example
- Top N – Example
- LAMBDA function
- Optional arguments
- Moving custom functions between workbooks
- LAMBDA top N – example
- Advanced Formula Environment
- Exercises – LET & LAMBDA
- Variables & custom functions – Quiz
Looping functions
- Looping functions – Introduction
- What are looping functions?
- BYCOL & BYROW functions
- Eta reduction
- FILTER by any column – Example
- MAP function
- Using slicers with formulas – Example
- LAMBDA helper custom functions
- MAKEARRAY function
- Running total by row – Example
- Exercises – BYROW, BYCOL, MAP & MAKEARRAY
- GROUPBY function
- GROUPBY function – Beyond the basics
- PIVOTBY function
- SCAN & REDUCE functions
- Corkscrew calculation – Example
- DROP, REDUCE, LAMBDA [x]STACK Combination
- Exercises – GROUPBY, PIVOTBY, SCAN & REDUCE
- Recursive LAMBDAs
- Looping functions – Quiz
Wrap up
- Wrap-up
- Feedback
- Certificate
Along with our complete training program, as an Excel Academy member, you will also gain access to:
Quick Calc Library
Quick Calc is an extensive library of pre-built, easy-to-apply, LAMBDA functions that are designed to solve common scenarios that Excel users face every day.
Function Vault
Function Vault is the Excel Add-in for storing and quickly inserting LAMBDA custom functions for Excel and Power Query into any workbook.
We transform how people work with Excel
Our methods have been proven by thousands of students worldwide who have transformed their Excel skills. We don’t just teach theory, we teach practical, real-world solutions that save time and eliminate manual work.
“The examples and exercises are exceptionally well-designed, making the learning experience both engaging and enriching. The pace of the course was perfect, allowing for a deep understanding of the concepts without feeling rushed.” – Biju
“Really great course. I really liked a refresher of the basics and how it was connected to more advanced topics. I reckon you do an excellent job in explaining logic behind the processes so later I can apply it in different scenarios.” – Vitaliy
If you continue relying on outdated Excel methods, you will continue to get the same results – wasted time and stress.
Enrol in Dynamic Formulas Unleashed today to create:
✔ Spreadsheets that updated instantly with no manual adjustments or cell dragging.
✔ Formulas that expand automatically when you add new data.
✔ Reusable formulas which 10x the speed of building new spreadsheets.
Dynamic Formulas Unleashed won’t just improve your Excel skills, it will redefine them. Your spreadsheets will be smarter and faster, putting you miles ahead of your peers.
JOIN TODAY
The Dynamic Formulas Unleashed is only available within the Excel Academy.