This course was created with the
course builder. Create your online course today.
Start now
Create your course
with
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
Workbook principles
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock