Financial Modelling with Modern Excel
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
29 people enrolled last week.
Financial Modelling with Modern Excel
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
29 people enrolled last week.
.png&w=1536&q=75)
.png&w=1536&q=75)
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.
Financial Modelling with Modern Excel
Course syllabus
Week 1
Jul 29—Aug 4
Week dates are set to instructor's time zoneEvents
- Jul
30
Week 1, Session 1: Bootcamp Welcome and Modelling Best Practices
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
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 zoneEvents
- Aug
6
Week 2, Session 1: The Fundamentals of Dynamic Arrays
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
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 zoneEvents
- Aug
13
Week 3, Session 1: An Introduction to 5G Modelling
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
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
Closing Virtual Coffee Hour
Fri, Aug 16, 4:00 PM - 5:00 PM UTC
Meet your instructor
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 is one of just seven individuals in the world to hold all three of the Financial Modeling Institute's certifications (AFM, CFM, MFM).
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
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 for financial modellers.
Join an upcoming cohort
Financial Modelling with Modern Excel
Cohort 1
$295
Dates
Payment Deadline
Don't miss out! Enrollment closes in 20 hours
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
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?
Join an upcoming cohort
Financial Modelling with Modern Excel
Cohort 1
$295
Dates
Payment Deadline
Don't miss out! Enrollment closes in 20 hours