Core Modeling Skills – with FAST Standard
4.73 (45 Ratings)
Enrolled:491
$40
$67
-
LevelBeginner
-
Duration5 hours 45 minutes
-
Last UpdatedSeptember 16, 2024
-
Enrollment validityEnrollment validity: 365 days
-
CertificateCertificate of completion
Hi, Welcome back!
About Course
The Core Modeling Skills course is an essential building block for any individual looking to develop strong financial modeling capabilities that align with global standards. This course focuses on providing learners with a comprehensive understanding of the fundamental concepts and best practices for building financial models using FAST Standard. It covers a range of topics, including Excel shortcuts, data manipulation, analysis, modeling techniques, scenario analysis, etc.
What will I learn?
- Develop a strong foundation in financial modeling concepts and techniques
- Build Financial Modeling using globally accepted standard - FAST Standard
- Gain proficiency in using Excel shortcuts to expedite modeling tasks
- Learn how to manipulate and prepare data for financial analysis
- Understand essential principles for effective financial analysis within models
- Master various modeling techniques used in creating accurate financial models
- Explore scenario analysis to evaluate the impact of different variables on models
- Learn best practices for structuring and organizing financial models efficiently
- Acquire skills to incorporate sensitivity analysis to assess model responsiveness
- Understand the importance of accuracy, transparency, and logical flow in models
- Develop the ability to create dynamic and adaptable financial models
- Learn techniques to effectively present and communicate model results
- Access resources that bridge theoretical modeling concepts with practical examples
- Develop a critical eye for identifying and rectifying errors in financial models
Course Curriculum
Introduction
-
02:19
-
01:10
-
Course Prerequisite
00:34
Keyboard Over the Mouse
-
Importance of the ALT Key
04:22 -
Importance of Keyboard Shortcut
01:56 -
Editing Directly from Formula Bar
02:20 -
Move Selection After ENTER
01:59 -
Maximizing the Worksheet Interface
01:22 -
Basic Worksheet Navigation
02:59 -
Selecting, Adding, & Deleting Content
01:48 -
Inserting Rows & Columns
03:38 -
Adding a Formatted Worksheet
02:14
Assessment I
-
Quiz
Setting Up Macros
-
Formatting & Productivity Macros
07:33 -
Setting Up Macros
04:42 -
Unblocking Macros
00:00
Model Structure
-
Introduction to FAST Standard
01:43 -
What Makes a Model Hard to Read
01:04 -
Understanding Model Structure
01:44 -
Model Structure – Workbook Level
02:41 -
Model Structure – Worksheet Level
04:12 -
Model Structure – Calculation Block Level
05:06 -
Model Structure – Calculation Block Component
02:33 -
Copying Calculation Block
03:22
Building Up the Model & Charts
-
Cell References
06:09 -
Constant
02:35 -
Row Anchored Link
04:05 -
Benefits of Calculation Block
03:35 -
Links to Links
04:13 -
Copying Row Anchored Links
02:23 -
How to Use Placeholders
04:09 -
Local, Import & Export Link
08:52 -
Creating Links
03:20 -
Timing Flags
14:28 -
How to Model Balances
07:44 -
Sign Convention & Switch
03:52 -
Counterflows
02:46 -
Embedded Constants
01:43 -
F11 Quick Charts
02:59
Model Guide & Audit
-
Verifying Originality of a Financial Model
02:01 -
Trace Precedents & Dependents
03:47 -
Template Sheet
04:46
Building Model from Scratch & Time Flags
-
Model Structure and Time Ruler
15:22 -
Time Flags
00:00 -
Timeline Label
00:00 -
Replicating the Timeline to Other Sheet
04:49
Assessment II
-
Quiz
Student Ratings & Reviews
4.7
Total 45 Ratings
5
41 Ratings
4
10 Ratings
3
4 Ratings
2
0 Rating
1
0 Rating
This is well thought of. The best I have experienced.
good
It is very interactive
This course explains the FAST model and Time Flags for building financial models from scratch.
on point
Yes it was.
Good
It was very informative and concise
Great content, and perfect delivery!
The delivery is concise and clearly articulated
it was good
Impactful
I really enjoyed how explanatory this course was.
it's a lot, i need to do a lot of revision for this as it is extensive.
This course is incredibly informative and well structured, providing clear explanations and practical examples that made even complex topics easy to understand.
From module 1-4, I understood it, but form module 5, it was shaky for me. The course is a good one, but the formulas in the macro key set up aren’t responding on excel , so it made it frustrating, but the teaching is really good and well explained.
"I found this course to be exceptionally well-designed and impactful. The lecturer’s clarity, depth of knowledge, and engaging teaching style made complex concepts easy to grasp and apply. The course materials were thoughtfully organized, and the interactive elements kept me engaged throughout. I now feel more confident and well-prepared in this subject, and I’m truly grateful for the high quality of instruction. Thank you for such a transformative learning experience!"
It was really helpful and quite detailed.
It was a good introduction into the wide scope of financial modelling. I got better understanding and mastery of excel and macros shortcuts.
It was very informative although the last module was very confusing