This course is an incredible eye-opener for any student who wants to stop fighting with broken formulas and start building models that work like modern software. I really liked how Danielle Stein Fairhurst explains "spill" behavior, making it much less intimidating than learning it on your own. It’s the perfect roadmap for moving past the manual "copy and paste" era to build faster, cleaner, and more professional financial statements that update automatically.
Excel: Financial Modeling with Dynamic Arrays
With Danielle Stein Fairhurst
Liked by 1,247 users
Duration: 2h 40m
Skill level: Intermediate
Released: 7/9/2025
Course details
Transform traditional spreadsheet modeling by harnessing Excel's powerful dynamic array capabilities. In this course, instructor Danielle Stein Fairhurst outlines financial modeling practices that go beyond legacy techniques that rely on copied formulas and manual updates. Learn how to create more efficient, scalable, and maintainable financial models using Excel's latest array functions and spill behavior. Through hands-on exercises, you'll discover techniques for building dynamic financial statements, valuation models, and sensitivity analyses that automatically update and adapt to your data as it changes. The course covers modern solutions for common modeling challenges, from handling varying data ranges to creating flexible scenario analyses, all while maintaining best practices for financial modeling structure and documentation.
Skills you’ll gain
Earn a sharable certificate
Share what you’ve learned, and be a standout professional in your desired industry with a certificate showcasing your knowledge gained from the course.
-
Showcase on your LinkedIn profile under “Licenses and Certificate” section
-
Download or print out as PDF to share with others
-
Share as image online to demonstrate your skill
Meet the instructor
Learner reviews
Contents
What’s included
- Practice while you learn 2 exercise files
- Test your knowledge 6 quizzes
- Learn on the go Access on tablet and phone
- Stay up to date Continuing Education Units
Similar courses
Download courses
Use your iOS or Android LinkedIn Learning app, and watch courses on your mobile device without an internet connection.