Master Dynamic Arrays with Excel Expert Jon Peltier

If your Excel reports break when data expands, require updates across dozens of cells every time something changes, or rely on formula logic so scattered it is nearly impossible to audit, you are not working with a bad process. You are working with an old one.

Dynamic Arrays are one of the most significant upgrades Excel has introduced in years, and most users have not yet touched them. This session with Excel MVP Jon Peltier changes that, with hands-on instruction, side-by-side comparisons, and real-world financial applications you can put to use immediately.

What You Will Learn:

• What Dynamic Arrays are, how spill ranges work, and how they differ fundamentally from the traditional formulas you already know
• How core Dynamic Array functions including SEQUENCE, SORT, FILTER, UNIQUE, VSTACK, and HSTACK can replace complex multi-cell formula setups with a single, auditable formula
• How to combine Dynamic Array functions to unlock advanced capabilities like unpivoting data, building dynamic headers, and filtering across multiple conditions in one formula
• How LAMBDA functions let you build custom, reusable functions without VBA, encapsulating logic that can be shared across workbooks and handed off without explanation
• How Dynamic Array formulas can generate corkscrew data structures and loan amortization schedules that update instantly when assumptions change, without rebuilding the model
• What the side-by-side difference between old-style formulas and Dynamic Arrays looks like in practice, so you can confidently choose the right technique for the task at hand

Why This Matters Now

Manual formula maintenance is one of the biggest hidden costs in Excel-based reporting. When data changes size, formulas break. When logic is scattered across dozens of cells, auditing becomes a project of its own. When financial structures like corkscrews and amortization schedules are built cell by cell, they are difficult to maintain and nearly impossible to hand off cleanly.

Dynamic Arrays solve all of that with a single formula that resizes automatically, stays auditable, and scales with your data. Once you see how they work, going back feels unnecessary.

*Attendees will receive a ready-to-use Excel workbook to practice each technique and apply it immediately in their own reports. 

Your Presenter 

Jon Peltier, Microsoft Excel MVP │ Founder, Peltier Technical Services, is one of the world’s foremost authorities on Excel. A full-time Excel developer since 2004, Jon holds a Doctor of Science degree from MIT and brings a background spanning manufacturing, statistics, total quality, and Six Sigma. He has received Microsoft’s Most Valuable Professional award every year since 2001 and is known for making complex Excel functionality approachable, practical, and immediately useful.

Who Should Attend 

• Finance, accounting, and operations professionals who build reports and models in Excel and want to work faster and more reliably
• Financial analysts who rely on complex formula structures and are ready to simplify them without sacrificing flexibility
• Excel users with a solid working knowledge of formulas who have not yet explored Dynamic Arrays and want to understand what they are missing
• Anyone whose Excel reports are brittle, hard to audit, or break when data changes size
• Excel learners who want hands-on, applicable skills they can put to use the same day

ACCESS YOUR FREE ON-DEMAND WEBINAR

Can’t attend live? Sign up anyway and we’ll send you the recording so you can watch on your own schedule.

You will also be subscribed to our email newsletter that delivers practical advice, resources, and products to help you navigate everyday HR challenges. You may also be contacted by this webinar sponsor.

You can withdraw your consent at any time by clicking “Unsubscribe” in our emails or contacting us at support@hrmorning.com. For more information on how we handle your data, please read our Privacy Policy.