Coming Soon workshop
Mastering Modern Excel with Dynamic Arrays & LAMBDA
Excel
Data Analysis
Notify me when registration is open
You're comfortable writing the Excel formulas you know and love, but the dynamic array side of Excel has been harder to warm up to. Spilled ranges and newer functions like LAMBDA can look niche and far too complicated to pick up, and it's hard to see how they'd add value to work you already do capably.
In this session, you'll learn why spilling is the goal behind modern Excel and how dynamic arrays can turn multi-step, error-prone models into a single, simple formula. You'll also write custom functions with LAMBDA and use its helper functions so your formulas spill across any scenario.
What you'll learn
Understand why spilling is the goal behind modern Excel
Seeing what dynamic arrays are designed to do changes how you approach the formulas you already write.
Work with spill behavior across function inputs and outputs
Knowing how arrays flow into and out of a function is the foundation for everything else in modern Excel.
Simplify multi-step, error-prone models into a single formula
Fewer helper columns and intermediate steps means fewer places for a model to break.
Write custom functions with LAMBDA and its helper functions
You'll package logic you use often into a reusable function and apply it across any scenario with a single formula.
Who should join this workshop?
Proficient Excel users who want to apply modern formulas to their own work and simplify their workflows
Analysts who maintain multi-step, error-prone models and want to replace them with a single formula
Experienced formula writers who haven't spent much time with dynamic arrays and want to see where they fit in their work
Prerequisites
A Microsoft Excel 365 subscription is required to follow along
Proficiency with Excel formulas (recommend completing the Formulas & Functions section of our Excel Foundations course)
Enrique Ruiz
Sr. Learning Experience Designer
Enrique is a certified Microsoft Excel Expert and top-rated instructor with a background in business intelligence, data analysis and visualization. He has been producing advanced Excel and test prep courses since 2016, along with adaptations tailored to Spanish-speaking learners.
