Financial Modelling with Dynamic Arrays

Best practice financial modelling in Excel has always encouraged consistency of formulas with calculations performed in blocks. Excel’s dynamic array functions mean that it’s impossible to have inconsistent formulas and are perfect for building financial models, however, the techniques needed to build a model using dynamic arrays are significantly different from the traditional way of building formulas with absolute and relative cell references.

Building a fully dynamic model requires additional thought and layout planning compared to conventional methods, but the extra planning is worth the effort!

This class will be delivered in-person in central London (zone 1). Exact venue details will be sent to everyone closer to the event date.‍

Who should attend this course?

This course is for beginners to Power Query. If you know a little Power Query or if you’ve never used it, this masterclass is for you.

Customer Service Reps
Sales Assistants
Marketers
Data Analysts
Every day Excel users who regularly work with data that’s not immediately useful and clean
Business and Management Students

Who should attend this course?

If you create Data Models in Excel or Power BI, then this Masterclass is for you.

Data professionals
Business Intelligence or Analytics professionals
Every day Excel or Power BI users who want to learn how to build advanced DAX + Power BI skills

Who should attend this course?

If you create Data Models in Excel or Power BI, then this Masterclass is for you.

Data professionals
Business Intelligence or Analytics professionals
Every day Excel or Power BI users who want to learn how to build advanced DAX + Power BI skills

Who should attend this course?

This Masterclass is for people who already know and have worked with Power Query’s user interface (either in Excel or Power BI) and want to explore advanced problem solving using the M Language.

Business Intelligence or Data Analytics professionals
Every day Excel or Power BI users who want to learn an in-demand business skill and build advanced Power Query skills
Professionals willing to experience Power Query in new ways

Who should attend this course?

This is course is for intermediate and advanced Excel users.

Small business owners who want to better visualize their data
Business Intelligence professionals
Every day Excel users who want to learn how to build awesome dashboards in Excel, using the latest new features
Business and Management Students

Who should attend this course?

This Masterclass is designed for users who use Excel on a regular basis and are comfortable with using its tools and functions. It is assumed that attendees will have some financial background.

Financial modellers and analysts
Business professionals who are eager to improve their Excel and Financial Modeling skills
Finance & Accounting students

What’s included?

One-day in-person training with Microsoft MVP Danielle Stein Fairhurst

Claim up to 6 hours of CPD (Continuing Professional Development) hours / points

Downloadable Excel Sheets

Coffee, tea and biscuits throughout the day

Certificate of attendance

Office hours support for 1 year

What’s included?

One-day in-person training with Microsoft MVP Danielle Stein Fairhurst

Claim up to 6 hours of CPD (Continuing Professional Development) hours / points

Downloadable Excel Sheets

Coffee, tea and biscuits throughout the day

Certificate of attendance

Office hours support for 1 year

What’s included?

One-day in-person training with Microsoft MVP Danielle Stein Fairhurst

Claim up to 6 hours of CPD (Continuing Professional Development) hours / points

Downloadable Excel Sheets

Coffee, tea and biscuits throughout the day

Certificate of attendance

Office hours support for 1 year

What’s included?

One-day in-person training with Microsoft MVP Danielle Stein Fairhurst

Claim up to 6 hours of CPD (Continuing Professional Development) hours / points

Downloadable Excel Sheets

Coffee, tea and biscuits throughout the day

Certificate of attendance

Office hours support for 1 year

What’s included?

One-day in-person training with Microsoft MVP Danielle Stein Fairhurst

Claim up to 6 hours of CPD (Continuing Professional Development) hours / points

Downloadable Excel Sheets

Coffee, tea and biscuits throughout the day

Certificate of attendance

Office hours support for 1 year

What’s included?

One-day in-person training with Microsoft MVP Danielle Stein Fairhurst

Claim up to 6 hours of CPD (Continuing Professional Development) hours / points

Downloadable Excel Sheets

Coffee, tea and biscuits throughout the day

Certificate of attendance

Office hours support for 1 year

What’s included?

One-day in-person training with Microsoft MVP Danielle Stein Fairhurst

Claim up to 6 hours of CPD (Continuing Professional Development) hours / points

Downloadable Excel Sheets

Coffee, tea and biscuits throughout the day

Certificate of attendance

Office hours support for 1 year

What’s included?

One-day in-person training with Microsoft MVP Danielle Stein Fairhurst

Claim up to 6 hours of CPD (Continuing Professional Development) hours / points

Downloadable Excel Sheets

Coffee, tea and biscuits throughout the day

Certificate of attendance

Office hours support for 1 year

What’s included?

One-day in-person training with Microsoft MVP Danielle Stein Fairhurst

Claim up to 6 hours of CPD (Continuing Professional Development) hours / points

Downloadable Excel Sheets

Coffee, tea and biscuits throughout the day

Certificate of attendance

Office hours support for 1 year

What’s included?

One-day in-person training with Microsoft MVP Danielle Stein Fairhurst

Claim up to 6 hours of CPD (Continuing Professional Development) hours / points

Downloadable Excel Sheets

Coffee, tea and biscuits throughout the day

Certificate of attendance

Office hours support for 1 year

What’s included?

One-day in-person training with Microsoft MVP Danielle Stein Fairhurst

Claim up to 6 hours of CPD (Continuing Professional Development) hours / points

Downloadable Excel Sheets

Coffee, tea and biscuits throughout the day

Certificate of attendance

Office hours support for 1 year

What’s included?

One-day in-person training with Microsoft MVP Danielle Stein Fairhurst

Claim up to 6 hours of CPD (Continuing Professional Development) hours / points

Downloadable Excel Sheets

Coffee, tea and biscuits throughout the day

Certificate of attendance

Office hours support for 1 year

Full course details:

Click on the topics below to see exactly what you get as part of this package:

Full course details:

Click on the topics below to see exactly what you will learn as part of this course:

Click on the topics below to see exactly what you get as part of this package:

Full course details:

Click on the topics below to see exactly what you will learn as part of this course:

Click on the topics below to see exactly what you get as part of this package:

Full course details:

Click on the topics below to see exactly what you get as part of this package:

Full course details:

Click on the topics below to see exactly what you get as part of this package:

Full course details:

Click on the topics below to see exactly what you get as part of this package:

Full course details:

Click on the topics below to see exactly what you get as part of this package:

Full course details:

Click on the topics below to see exactly what you get as part of this package:

Full course details:

Click on the topics below to see exactly what you get as part of this package:

Training requirements

Software used

The course is demonstrated using the latest version of Excel for Microsoft 365 but participants can use whichever version of Excel they are most comfortable with. The course materials include additional instructions for prior versions of Excel, and Excel for Mac users are also catered for.

Each delegate must bring their own laptop with their preferred version of Excel installed.

About the trainer

Danielle Stein Fairhurst

Danielle Stein Fairhurst is the Principal of Plum Solutions, a Sydney-based consultancy specialising in financial modelling and analysis. She is a LinkedIn Learning Instructor and in 2021 she first received the Microsoft Most Valuable Professional (MVP) award. In 2022 she was awarded the “Lifetime Achievement Award” at the Financial Modelling Summit.

She is a Chartered Financial Modeler (FMI), holds a Master of Business Administration (MBA) from Macquarie Graduate School of Management (MGSM) and has taught management accounting subjects at the University of Sydney.

What they say about us

London, UK

June 2023

This course was all I hoped it would be and more. Fabulous experience all in all, thanks Danielle.

Full session details:

Click on the topics below to see exactly what you get as part of this package: