Dynamic Excel for Finance: The 5 Functions Replacing Hours of Manual Work
Spending made smarter
Easy-to-use cards, funds, approval flows, vendor payments -plus an average savings of 7.5%.1
Finance teams that use Microsoft Excel every day often spend hours copying formulas, extending ranges, and fixing reports when new data comes in.
In this session, Microsoft Excel MVP Carl Seidman demonstrated five dynamic array functions that allowed finance teams to write one formula and have it do the work of hundreds. He shared techniques for a close, forecast, or report, including:
- How dynamic arrays replaced hundreds of copied-down formulas.
- How five dynamic functions filtered, sorted, de-duplicated, and summarized data without manual steps.
- How reports updated automatically when new data was added.
About the speaker
Carl Seidman
Creator, The FP&A Mastery Signature Program
Related webinars
1 hour
8 Excel Formulas Every FP&A Team Needs
Watch finance expert Josh Aharonoff, Founder & CEO of Mighty Digits, share his 8 essential Excel formulas that will eliminate tedious manual work.
1 hour
Claude in Excel & PowerPoint: A Live-Build Session for Finance & Accounting
Nicolas Boucher, the #1 AI trainer for finance teams, shows you how to use Claude in Excel and PowerPoint.
1 hour
Driver-Based Forecasting: Building Dynamic FP&A Models in Excel
Carl Seidman, CPA, Microsoft Excel MVP, shows you exactly how to build a P&L model where a small set of key inputs automatically recalculates your entire forecast, so you can update scenarios in minutes.