Modern Financial Modelling in Excel: From Dynamic Arrays to LAMBDA to AI

Masterclass Overview

Modern Excel has transformed what is possible in financial modelling. Dynamic Arrays, LET, LAMBDA and AI tools such as Copilot introduce powerful new ways to build, review and understand models, while still drawing on the best practice principles that have underpinned financial modelling for decades.

This workshop explores how modern Excel is transforming financial modelling. It covers Dynamic Arrays, LET, and LAMBDA-based approaches, and examines how these can be combined with AI tools to enhance productivity while maintaining control, transparency, and model integrity.

This practical masterclass takes participants on a guided journey from traditional financial modelling techniques through to the latest Modern Excel capabilities. Using a consistent set of financial modelling schedules throughout the day, attendees compare traditional and modern approaches and develop a clear understanding of when each technique is most appropriate.

Learning Objectives

• Understand the shift from traditional to modern Excel modelling techniques
• Use dynamic arrays to build flexible, scalable models
• Apply LET to improve readability and efficiency
• Use LAMBDA to create reusable, modular logic
• Integrate AI tools responsibly into modelling workflows

Target Audience

Intermediate to advanced Excel users and financial modellers who want to expand their toolkit and understand the latest developments in Modern Excel and looking to modernise their approach and take advantage of the latest Excel capabilities and AI tools.

Participants will benefit most if they:

• Have some prior financial modelling experience
• Are comfortable with Excel formulas and workbook navigation
• Understand common modelling concepts such as assumptions, forecasts and schedules
• Want to explore Dynamic Arrays, LET, LAMBDA and AI in a practical modelling context.

Masterclass Content

1. The Evolution of Excel Modelling
2. Dynamic Array-Based Design
3. Structured Formula Design
4. Using LET for Structured Formula Development
5. LAMBDA and Modular Modelling Approaches
6. The Role of AI in Modern Modelling

 What You'll Learn

• How traditional and modern modelling approaches fit together and where each delivers the greatest value.
• Build flexible, scalable and auditable model structures using Modern Excel capabilities.
• Use LET and LAMBDA to create readable, maintainable and reusable modelling components.
• Explore the practical limitations of fully Dynamic Array-based three-statement models and evaluate alternative approaches.
• Conclude the day with a practical look at AI in Excel, including demonstrations of Microsoft Copilot and approaches for reviewing and verifying AI-generated outputs

Requirements

• Windows 10 or 11 PC
• Microsoft Excel (version Microsoft 365) or 2024
• Microsoft Copilot license is recommended but not mandatory.