Booking options
Free
Course Images
Encyclopedia of FAST Modelling
By F1F9 Academy
(58)- 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
- Adding and deleting worksheets
- Amending the goal seek macro
- Analysis toolpak
- Basic worksheet navigation
- Blank worksheet
- Borders
from Calculation Blocks to Counterflows (18 modules)18 lessons
- Calculation blocks
- Calculation construction
- Calculation construction - constants
- Calculation construction - constants in a data series
- Calculation construction - trivial calculations
- Calculation modes
- Cascading calculations
- 2D calculation blocks
- Checks and alerts
- Circuit breakers
- Conceptual modelling
- Constants
- Copying across / rule of thumb
- Copy paste techniques
- Copy vs Link
- Copying and pasting temp sheet
- Corkscrews
- Counterflows
from Data Picks to Escalation Sheet (11 modules)11 lessons
- Data picks
- Data validation
- Date functions
- Day counts
- Dashboard worksheet
- Deleting rows and content
- Edit directly in cell
- Editing a formula
- Editing VBA code
- Embedded constants
- Escalation sheet
from F1F9 macros to Hiding Columns (9 modules)9 lessons
- F1F9 additional keyboard shortcuts
- Find and replace
- Flags
- Forex rates
- Formatting numbers
- Goal seek
- Group mode
- Headers, sub headers and sub sub headers
- Hiding columns
from Import / Export to Move selection after enter (12 modules)12 lessons
- Import / export
- Inserting rows and columns
- Inspecting a macro
- Intra sectional links
- IRR XIRR
- ISNA
- Keyboard shortcuts and the mouse
- Look back
- Macro security and developer tab
- Managing data sets with Excel defined names
- MIN MAX
- Move selection after enter
from Name Ranges in Macros to Running a macro using button (14 modules)14 lessons
- Name ranges in macros
- NPV XNPV
- Offsheet references and Excel defined names
- Placeholders
- Precedents and dependents
- Pyramid structure
- Quick charts
- Ratios
- Reducing worksheet clutter
- Reviewing a FAST model
- Row anchored links
- Row totals
- Running a goal seek macro
- Running a macro using buttons
from Scenario Selection to SUMIFS (10 modules)10 lessons
- Scenario selection (nested IF and CHOOSE)
- Scenario selection (OFFSET)
- Scenario selection (INDEX)
- Selecting, adding and deleting content
- Sign conventions
- Sign switch
- Spaces in formulae
- SUM
- SUMPRODUCT
- SUMIFS
from Two Views of the same Workbook to Writing a Good Label (11 modules)13 lessons
- Two views of same workbook
- Template worksheet
- Template model
- Time ruler - part 1
- Time ruler - part 2
- Using the Alt key
- Using the function keys
- Visual basic editor
- Windows explorer settings
- Worksheet column design
- Writing a good label
- Encyclopedia - How did you get on?
- Encyclopedia of FAST course feedback
Reviews
Material Covered
Facilitator
Organiser
Resources Provided
Location/Delivery
Communication
Verified
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
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.
