Establishing a single source of truth with Data Models in Excel

Speaker:

Carolina Lago

Find on Linkedin

About the session

Discover how to use Excel's data modeling capabilities to create a single source of truth for financial data. You'll learn how to integrate various data sources, build robust data models, and utilise advanced Excel functions to ensure consistency and accuracy in financial reporting.

With Carolina Lago

Related sessions

View All

4 Feb

11:30 am

–

11:30 am

Finance & Accounting

"Deal or no deal" — Best practice modelling tips

Discover new functions like TRIMRANGE with dynamic arrays, sequential logic with LAMBDA, conditional formatting, and data validation.

Liam Bastick

4 Feb

2:10 pm

–

2:10 pm

Finance & Accounting

The Swiss Army knife for finance professionals

Discover the versatility of Excel to solve disparate problems faced by finance professionals as they model company cashflows and valuations.

Ian Schnoor, CFA, CFM

Rob Langrick

4 Feb

12:10 pm

–

12:10 pm

Finance & Accounting

Creating high-impact financial presentations in Excel and PowerPoint

Create information-rich, visually compelling PowerPoint presentations driven by Excel data.

Danielle Stein Fairhurst

Explore our Team Training Offer

Our CPD-accredited training programs are designed to enhance productivity and streamline operations. Fully customizable to align with each organization’s unique needs.

Explore Corporate Training