Booking options
Free
Course Images
Encyclopedia of FAST Modelling
By F1F9 Academy
(53)- 30 Day Money Back Guarantee
- Completion Certificate
- 24/7 Technical Support
Highlights
On-Demand course
1 hour 30 minutes
All levels
Description
course Content
8 sections•93 lessons
from Adding and deleting worksheet to Borders (6 modules) 6 lessons
- 1Adding and deleting worksheets
- 2Amending the goal seek macro
- 3Analysis toolpak
- 4Basic worksheet navigation
- 5Blank worksheet
- 6Borders
from Calculation Blocks to Counterflows (18 modules)18 lessons
- 1Calculation blocks
- 2Calculation construction
- 3Calculation construction - constants
- 4Calculation construction - constants in a data series
- 5Calculation construction - trivial calculations
- 6Calculation modes
- 7Cascading calculations
- 82D calculation blocks
- 9Checks and alerts
- 10Circuit breakers
- 11Conceptual modelling
- 12Constants
- 13Copying across / rule of thumb
- 14Copy paste techniques
- 15Copy vs Link
- 16Copying and pasting temp sheet
- 17Corkscrews
- 18Counterflows
from Data Picks to Escalation Sheet (11 modules)11 lessons
- 1Data picks
- 2Data validation
- 3Date functions
- 4Day counts
- 5Dashboard worksheet
- 6Deleting rows and content
- 7Edit directly in cell
- 8Editing a formula
- 9Editing VBA code
- 10Embedded constants
- 11Escalation sheet
from F1F9 macros to Hiding Columns (9 modules)9 lessons
- 1F1F9 additional keyboard shortcuts
- 2Find and replace
- 3Flags
- 4Forex rates
- 5Formatting numbers
- 6Goal seek
- 7Group mode
- 8Headers, sub headers and sub sub headers
- 9Hiding columns
from Import / Export to Move selection after enter (12 modules)12 lessons
- 1Import / export
- 2Inserting rows and columns
- 3Inspecting a macro
- 4Intra sectional links
- 5IRR XIRR
- 6ISNA
- 7Keyboard shortcuts and the mouse
- 8Look back
- 9Macro security and developer tab
- 10Managing data sets with Excel defined names
- 11MIN MAX
- 12Move selection after enter
from Name Ranges in Macros to Running a macro using button (14 modules)14 lessons
- 1Name ranges in macros
- 2NPV XNPV
- 3Offsheet references and Excel defined names
- 4Placeholders
- 5Precedents and dependents
- 6Pyramid structure
- 7Quick charts
- 8Ratios
- 9Reducing worksheet clutter
- 10Reviewing a FAST model
- 11Row anchored links
- 12Row totals
- 13Running a goal seek macro
- 14Running a macro using buttons
from Scenario Selection to SUMIFS (10 modules)10 lessons
- 1Scenario selection (nested IF and CHOOSE)
- 2Scenario selection (OFFSET)
- 3Scenario selection (INDEX)
- 4Selecting, adding and deleting content
- 5Sign conventions
- 6Sign switch
- 7Spaces in formulae
- 8SUM
- 9SUMPRODUCT
- 10SUMIFS
from Two Views of the same Workbook to Writing a Good Label (11 modules)13 lessons
- 1Two views of same workbook
- 2Template worksheet
- 3Template model
- 4Time ruler - part 1
- 5Time ruler - part 2
- 6Using the Alt key
- 7Using the function keys
- 8Visual basic editor
- 9Windows explorer settings
- 10Worksheet column design
- 11Writing a good label
- 12Encyclopedia - How did you get on?
- 13Encyclopedia of FAST course feedback
Reviews
Material Covered
Facilitator
Organiser
Resources Provided
Location/Delivery
Communication
Verified
A highly practical and well-structured course that reinforces disciplined financial modeling practices. Even as an experienced modeler, I found strong value in the concrete application of the calculation block concept and the clarity of the explanations. The short video format and supporting materials make it easy to complete and apply in practice. Highly recommend, especially for teams building structured modeling habits.
F1F9 Academy
Responded
Thank you, Fernando - your words are much appreciated.
Verified
A highly practical and well-structured course that reinforces disciplined financial modeling practices. Even as an experienced modeler, I found strong value in the concrete application of the calculation block concept and the clarity of the explanations. The short video format and supporting materials make it easy to complete and apply in practice. Highly recommend, especially for teams building structured modeling habits.
F1F9 Academy
Responded
Thank you, Fernando - your words are much appreciated.
