Master Modern Excel
for FP&A
Excel Tables. Dynamic Arrays. Power Query. Three core skills that separate efficient FP&A analysts from everyone still doing things the hard way. Learn all three from a Microsoft MVP.
Most FP&A Pros Are Using Excel Like It's 2010
Dynamic Arrays completely overhauled Excel's calculation engine. Power Query eliminated manual data prep. Excel Tables transformed data management. Yet most finance professionals haven't adopted any of them.
Old-School Excel
- VLOOKUP everywhere, breaking when columns shift
- Copy-pasting data from source systems every month
- Copying and dragging formulas vs using Dynamic Arrays
- Hardcoded ranges that break as data grows
- Hours spent on manual data cleanup
Modern Excel
- XLOOKUP that works in any direction, never breaks
- Power Query auto-refreshes data with one click
- Dynamic arrays that spill results automatically
- Structured Tables that grow with your data
- Repeatable workflows you build once and reuse
Your Instructor
Paul is a widely recognized FP&A expert, Microsoft MVP for Excel, and the instructor behind the Modern Excel content in the Wharton Online FP&A Certificate program. He's trained thousands of finance professionals, hosts three top-rated finance podcasts, and has nearly 100,000 LinkedIn followers. His teaching style is practical, hands-on, and focused on skills you can apply immediately.
Three Courses. Three Pillars of Modern Excel.
Each course is designed to be hands-on and immediately practical. Follow along with included practice files and start applying what you learn the same day.
Excel Tables
The foundation of everything in Modern Excel. Learn to organize, analyze, and manage data using structured tables that grow with your business.
- Creating and naming tables properly
- Structured references in formulas
- Dynamic ranges that auto-expand
- Table formatting and best practices
- Connecting tables to PivotTables
Dynamic Arrays
The biggest change to Excel formulas in years. Master the functions that replaced Ctrl+Shift+Enter and changed how Excel calculates forever.
- XLOOKUP — replace VLOOKUP for good
- FILTER — dynamic filtering in formulas
- UNIQUE to return unique lists dynamically
- SEQUENCE for date ranges and series
- Spill ranges and the # operator
Power Query
Automate your data preparation. Stop manually copying and pasting your data into Excel.
- Connecting to multiple data sources
- Transforming and cleaning data
- Merging and appending tables
- Automated refresh workflows
- Real-world use cases
Who This Course Is For
FP&A Analysts
You live in Excel daily. You want to stop doing things the slow way and start using the tools that let you work smarter, build dynamic reports, and automate the tedious stuff.
Finance Managers & Controllers
You need your team to be more efficient. Power Query alone can eliminate hours of monthly data prep. This course pays for itself in the first month-end close.
Anyone Preparing for FP&A
Breaking into FP&A from accounting or other roles? Modern Excel skills are table stakes. This course gives you the technical foundation hiring managers expect.
What Students Say
"I found the FP&A Guy's course on Excel Tables to be incredibly helpful. The course covered how to create dynamic and organized data structures using Excel Tables, which has significantly improved my efficiency and accuracy. This course is a great starting point for anyone looking to master the modern Excel suite."
"Paul's approach is fantastic and his ability to educate you on key principles and new formulas to help structure your data in the most efficient way is incredible. I would highly recommend any FP&A team to invest time and training on such an important skill set."
"Truly an incredible session that helped us sharpen our skills to be more effective at our jobs. Your hands-on and example heavy approach really helped the team absorb the material quickly and implement in their day to day work faster."
One Bundle. Three Essential Courses.
Modern Excel Bundle
Excel Tables + Dynamic Arrays + Power Query
- Excel Tables course (5.0★)
- Dynamic Arrays course — 14 lessons (5.0★)
- Power Query course — 26 lessons (5.0★)
- Downloadable practice files
- Lifetime access to all content and updates
- Certificate of completion
- Same Power Query content as Wharton Online
100% Money-Back Guarantee
We're confident this course will transform how you work in Excel. If you're not completely satisfied, let us know and we'll issue a full refund. No hoops, no hassle.
Frequently Asked Questions
Do I need Excel 365 for this course?
Dynamic Arrays and many modern features require Microsoft 365 (Excel 365). Power Query is available in Excel 2016 and later. Excel Tables work in all modern versions. For the best experience, Excel 365 is recommended.
What skill level is this designed for?
Intermediate Excel users who are comfortable with basic formulas but haven't yet adopted Modern Excel features. If you're still using VLOOKUP and manually copy-pasting data, this course is built for you. Advanced users will also pick up new techniques, especially in Power Query.
How long will it take to complete?
The three courses combined include roughly 40+ lessons. Most students complete the bundle in 1-2 weeks at a comfortable pace. Since it's self-paced with lifetime access, you can take as long as you need.
Is this the same content as the Wharton Online program?
The Power Query course uses the same content Paul created for the Wharton Online & Wall Street Prep FP&A Certificate program. The Excel Tables and Dynamic Arrays courses are additional content not included in the Wharton program, giving you even more comprehensive Modern Excel training.
Can my employer pay for this?
Many students use their company's training budget. At $59.99, this is well within most approval thresholds. We can provide an invoice if needed for reimbursement purposes.
Why buy the bundle instead of individual courses?
The three courses purchased separately cost $119.97. The bundle saves you 50% and gives you the complete Modern Excel toolkit. Tables, Dynamic Arrays, and Power Query build on each other—learning all three together is the fastest path to transforming how you work.