Encyclopedia of FAST modelling

What is this course?

We’ve designed Encyclopedia of FAST Modelling for those who want get into the detail of how best to use Excel in designing and constructing financial models using the FAST Standard.

Every time we launch a new online course we think there is going to be something to add to the encyclopedia. Equally, if there is a topic that you want to see covered – and it is something that we work with frequently in F1F9 – then we will develop a video tutorial and add it to the encyclopedia.

There is a lot to look at already – and the bank of resources will be ever expanding.

What you will learn

Inside the encyclopedia, you will find:

  • quick reminders of key things to remember from our “31 days to better financial modelling” free online course
  •  practical video tutorials exploring how to solve common problems encountered in modelling assignments
  • practical video tutorials focused on modeller productivity and the needs of a model reviewer
  • practical video tutorials focused on the evaluation and use of more complex Excel function
  • access to a discussion forum managed by our 20+ team of professional modellers

Who should attend?

This course is for people who are not yet ready to sign up for a full-blown financial modelling course but who want to get a detailed picture of what they might expect when it comes to modelling philosophy and approach.

Book your course

Change currency
Date
Format
Location
Duration
Instructor
Price
N/a
Online
N/a
18 hours
Andrew Berkley
£95

Full list of modules

  • Adding and deleting worksheets
  • Amending the goal seek macro
  • Basic worksheet navigation
  • Setting the structure of a blank worksheet
  • Borders
  • Calculation blocks
  • Calculation construction
  • Calculation construction - constants
  • Calculation construction constants in 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
  • Data picks
  • Data validation
  • Date functions
  • Day Counts
  • Dashboard worksheets
  • Deleting rows and content
  • Edit directly in cell
  • Editing a formula
  • Editing code
  • Embedded constants
  • Escalation - how to create them
  • F1F9 macros
  • Find and Replace
  • Flags
  • Forex rates
  • Formatting numbers
  • Goal Seek
  • Group mode
  • Headers, sub headers and sub sub headers
  • Hiding columns
  • Import / export
  • Inserting rows and columns
  • Inspecting a macro
  • Intra-sectional links
  • IRR and XIRR
  • ISNA
  • Keyboard shortcuts & mouse
  • Look Back function
  • Macro security and developer tab
  • Managing data sets with Excel defined names
  • MIN and MAX
  • Name ranges in macros
  • NPV and XNPV
  • Offsheet references and Excel defined names
  • Placeholders
  • Precedents and dependents
  • Pyramid structure
  • Ratios
  • Reducing worksheet clutter
  • Reviewing a FAST Model
  • Row anchored links
  • Row totals
  • Running a goal seek macro
  • Running a macro using buttons
  • 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 function
  • SUMPRODUCT
  • SUMIFS
  • Two views of same workbook
  • Template worksheet
  • Template model - Project Finance
  • Time ruler
  • Using the Alt key
  • Using the function keys
  • Visual Basic Editor
  • Worksheet column design
  • Writing a good label
Find out more:
Encyclopedia of FAST modelling