Autoplay
Autocomplete
Previous Lesson
Complete and Continue
The Fundamentals of FAST Standard Modelling
Course Introduction
Welcome! (1:00)
Take our skills assessment
The importance of Standards (10:28)
Standards webinar (60:21)
Shortcuts & Navigation
The importance of shortcuts
My top 12 shortcuts (9:33)
Shortcuts exercise 1
Shortcuts exercise 2
The FAST Standard
FAST Introduction (4:17)
Workbook principles (6:26)
Worksheet principles (4:54)
Line item principles (10:12)
The calculation block (9:30)
Calculation block exercise 1
Calculation block exercise 1 solution video (10:24)
Row and column anchoring (3:11)
Links & daisy chains (5:16)
Placeholders (6:00)
The corkscrew (11:42)
Calculation block exercise 2
Calculation block exercise 2 solution video (28:35)
2D Calculation Blocks (4:27)
Flags (3:23)
Factors (6:45)
Closing thoughts on FAST (3:46)
Case Study 1: Luxury Estates
NPV & IRR Functions
Case study introduction (2:28)
Planning stage (6:17)
Build stage 1 (21:36)
Build stage 2 (23:22)
Review stage (2:51)
Solution file
Flags Challenge
Flags challenge introduction & files
Flags challenge solution video and supporting files (89:40)
Case Study 2: Lo Price & Local
Case Study Intro (2:14)
Solution Video: Part 1 (9:17)
Solution Video: Part 2 (18:53)
Solution Video: Part 3 (3:21)
Solution Video: Part 4 (15:17)
Solution File
Case Study 3 - BIOMAS
FAST Level 1 Practice Case Study (3:07)
FAST Level 1 Practice Case Study Solution File
The FAST Level 1 Certification
FAST Level 1 Exam Introduction (5:45)
The key FAST modelling principles (9:34)
Multiple choice questions (1:52)
Final thoughts on the exam (1:25)
Book time with me
Three Statement Modelling With FAST
Module introduction (2:57)
Three statement modelling masterclass - Part 1 (48:18)
Three statement modelling masterclass - Part 2 (56:00)
Three statement modelling masterclass - Part 3 (51:27)
Bonus Content
XLOOKUP Workbook
Named Ranges
Multidimensional table based modelling (67:03)
Course Completion
Thank you (0:46)
Feedback
Certificate & CPD
Factors
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock