Booking options
Free
Course Images
Model Construction Skills
Highlights
On-Demand course
1 hour 30 minutes
All levels
Description
Welcome to this introductory course on model construction skills. On completing the course, you will have a good awareness of the basic construction techniques required to build a financial model that is flexible, appropriate, structured and transparent.
In all of our teaching we will be following the FAST Standard - a freely available and detailed guide to designing and constructing financial models. For more details on the FAST Standard, go to: www.fast-standard.org
course Content
1 sections•22 lessons
Contents22 lessons
- 10. Before you begin
- 21. F1F9 productivity macros
- 32. Spaces in formulas
- 43. Calculation blocks
- 54. Copying calculation blocks
- 65. Row anchoring
- 76. Navigating using links
- 87. Daisy chains
- 98. Copying links
- 109. Placeholders
- 1110. Placeholder macro
- 1211. Timing flags
- 1312. Cross worksheet links
- 1413. Paste links forward
- 1514. Advanced productivity
- 1615. Introduction to modelling balances
- 1716. Counterflows
- 1817. Temp sheet
- 1918. Quick charts
- 2019. Model construction skills - assessment
- 2120. Ten things to remember
- 220. Now you've finished
Reviews
Material Covered
Facilitator
Organiser
Resources Provided
Location/Delivery
Communication