Financial Modelling with Modern Excel

New
·

3 Weeks

·

Cohort-based Course

Join us on an exciting journey to revolutionise your financial models, with Excel's cutting-edge features like Dynamic Arrays and LAMBDAs!

This course is popular

9 people enrolled last week.

Course overview

Excel has changed. Modelling practices are evolving. You must keep up!

Join three pros of the Excel and Modelling industry for this extensive course on financial modelling with Modern Excel.


Giles Male, co-founder of Full Stack Modeller, Diarmuid Early, Microsoft MVP and co-founder of The Golden Company, and Craig Hatmaker, creator of the 5G modelling methodology, have come together to offer this intense, 3-week bootcamp.


Giles will kick things off in week one by covering the fundamentals of three statement modelling. This will include a full walkthrough, and supporting training material. This is perfectly pitched for anyone interested in passing the Financial Modeling Institute's AFM certification.


Diarmuid will pick up in week two by guiding you through the fundamentals of Dynamic Arrays and LAMBDA.


Craig will close this bootcamp in week three by walking you through the conversion of a traditional three statement model (provided) to a 100% dynamic array model with support from 5G functions (also provided).


This is your chance to learn directly from some of the most knowledgable modellers and trainers out there, as part of a cohort that will support you every step of the way.


This bootcamp will be delivered through the Full Stack Modeller training platform, giving you 6 weeks' access to all Full Stack Modeller training content in addition to all of the bootcamp-specific content provided.

Who is this course for

01

Financial modellers interested in taking the FMI's AFM certification

02

Finance professionals seeking to stay up to date with Excel's most recent features

03

Finance professionals interested in 5G modelling

What you’ll get out of this course

A refresher of fundamental three statement modelling principles, taught in line with the FMI's AFM certification

Giles will kick off this bootcamp by walking through a complete three statement model build. This will include a practice case study for you to take away and work through in your own time.

Expert guidance through the application of Dynamic Arrays, LET and LAMBDA functions

Diarmuid will bring you up to speed with these incredibly powerful additions to the Excel functions library.


He'll walk you through their underlying characteristics, and show you how they can be applied to real-world modelling problems.

An introduction to the incredible 5G modelling methodology

Craig will bring you up to speed with 5G's underlying methodology. This will include free access to BXL's Financial Starter Pack (a $50 USD value), packed with 5G libraries, documentation, and examples.

A full three statement model build with Dynamic Arrays and LAMBDAs

Craig will close this bootcamp off by walking you through the conversion of a traditional three statement model (provided) to a 100% dynamic array model with support from 5G functions (also provided).

This course includes

7 interactive live sessions

Lifetime access to course materials

In-depth lessons

Direct access to instructor

Projects to apply learnings

Guided feedback & reflection

Private community of peers

Course certificate upon completion

Maven Satisfaction Guarantee

This course is backed by Maven’s guarantee. You can receive a full refund within 14 days after the course ends, provided you meet the completion criteria in our refund policy.

Course syllabus

Expand all modules
  • Week 1

    Jul 29—Aug 4

    Week dates are set to instructor's time zone

    Events

    • Jul

      30

      Week 1, Session 1: Bootcamp Welcome and Modelling Best Practices

      Tue, Jul 30, 4:00 PM - 6:00 PM UTC

    • Jul

      31

      Week 1, Session 2: "Traditional" Three Statement Modelling

      Wed, Jul 31, 4:00 PM - 6:00 PM UTC

  • Week 2

    Aug 5—Aug 11

    Week dates are set to instructor's time zone

    Events

    • Aug

      6

      Week 2, Session 1: The Fundamentals of Dynamic Arrays

      Tue, Aug 6, 4:00 PM - 6:00 PM UTC

    • Aug

      7

      Week 2, Session 2: The Fundamentals of LAMBDA

      Wed, Aug 7, 4:00 PM - 6:00 PM UTC

  • Week 3

    Aug 12—Aug 16

    Week dates are set to instructor's time zone

    Events

    • Aug

      13

      Week 3, Session 1: An Introduction to 5G Modelling

      Tue, Aug 13, 4:00 PM - 6:00 PM UTC

    • Aug

      14

      Week 3, Session 2: Three Statement Modelling with Dynamic Arrays

      Wed, Aug 14, 4:00 PM - 6:00 PM UTC

    • Aug

      16

      Closing Virtual Coffee Hour

      Fri, Aug 16, 4:00 PM - 5:00 PM UTC

Meet your instructor

Giles Male

Giles Male

Co-Founder at Full Stack Modeller

Giles is a seasoned financial modeller and trainer, having helped Excel users and modellers of all levels of experience across a 15 year career.


He's CIMA qualified, and holds the FMI's AFM and CFM certifications.

Diarmuid Early

Diarmuid Early

Top Excel Battle Competitor & Microsoft MVP

Diarmuid is one of the most talented and highly respected modellers in the world.


He is co-founder of The Golden Company, a recent addition to the Microsoft MVP ranks, and one of the highest ranked competitive Excel eSports players every year.

Craig Hatmaker

Craig Hatmaker

Creator of the 5G Modelling Methodology

Craig is, apparently, retired... although his retirement has so far led to the creation of the incredible 5G modelling methodology.


5G leans on Dynamic Arrays and LAMBDAs, and the Advanced Formula Environment, to bring a whole new range of solution possibilities to the table.

A pattern of wavy dots
Join an upcoming cohort

Financial Modelling with Modern Excel

Cohort 1

$295 USD

Dates

July 28—Aug 15, 2024

Payment Deadline

July 27, 2024
|

Bulk purchases

Course schedule

4-6 hours per week
  • Tuesdays & Wednesdays + Optional Closing Session on final Friday

    5pm - 7pm London Time

    Core sessions across the three bootcamp weeks will take place from 5pm to 7pm on Tuesday and Wednesday each week.


    The bootcamp will conclude with an optional Coffee Hour session for open Q&A and discussion.

  • Weekly projects

    2 hours per week

    Additional, optional homework will be provided each week. This should take no longer than 2 hours to complete (each week).

  • Full Stack Modeller Platform Access

    Signing up to this bootcamp gives you 6 weeks' access to the Full Stack Modeller training platform and community.

Learning is better with cohorts

Learning is better with cohorts

Active hands-on learning

This course builds on live workshops and hands-on projects

Interactive and project-based

You’ll be interacting with other learners through breakout rooms and project teams

Learn with a cohort of peers

Join a community of like-minded people who want to learn and grow alongside you

Frequently Asked Questions

What happens if I can’t make a live session?
I work full-time, what is the expected time commitment?
What’s the refund policy?
How does the money-back guarantee work?
I have more questions. What should I do?
A pattern of wavy dots
Join an upcoming cohort

Financial Modelling with Modern Excel

Cohort 1

$295 USD

Dates

July 28—Aug 15, 2024

Payment Deadline

July 27, 2024
|

Bulk purchases

$295 USD

3 Weeks