Financial Modelling with Modern Excel
4.8 (21)
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!
Financial Modelling with Modern Excel
4.8 (21)
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!
.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
26 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
30
Week 1, Session 1: Bootcamp Welcome and Modelling Best Practices
Jul
31
Week 1, Session 2: "Traditional" Three Statement Modelling
Henderson Walkthough
Week 2
Aug
6
Week 2, Session 1: The Fundamentals of Dynamic Arrays
Aug
7
Week 2, Session 2: The Fundamentals of LAMBDA
Diarmuid's files
Week 3
Aug
13
Week 3, Session 1: An Introduction to 5G Modelling
Aug
14
Week 3, Session 2: Three Statement Modelling with Dynamic Arrays
Aug
16
Closing Virtual Coffee Hour
Craig's files
4.8 (21 ratings)
What students are saying
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.
Be the first to know about upcoming cohorts
Financial Modelling with Modern Excel
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
Be the first to know about upcoming cohorts