Your browser is not supported. Please download Mozilla Firefox or Google Chrome browser.

Course Information arrow

Syndication Option

Resell Course
Resold modules appear on your website. You earn syndication share from each purchase.
Contact Coggno to learn more on how to embed your own Portable Webshop in your website.

FAST Financial Modelling: Level 1 Certification

FAST Financial Modelling: Level 1 Certification

Author: Financial Mechanics

Category: Online Accounting/Finance Training > Other

Faster, Better, Cheaper: Do you want to be more proficient and efficient in Excel?  FAST Modeling Certification is an online course that covers all the design and construction skills you’ll need as a foundation for financial modeling.  Our training follows the methods endorsed by FAST-Standard...

Keywords: FAST, financial models, Excel, microsoft excel, Business Modelling, Forecasting, Business Forecasting, spreadsheets, Forecasting Business Performance, Evaluating Projects, Securing Funding, Acquisitions, Project Finance

Read More
Buy this course

Per License

Enter no. of units to buy
Total Payment Required$95.50 Add to Cart
Table of Contents:

Lesson 1: Initial Setup br>
- Overview of The FAST Standard (video) br>
- Excel 2003 Setup (video) br>
- Excel 2007 / 2010 Setup (video) br>
- Excel's Calculation Options (video) br>
- Lesson 1: Exam br>

Lesson 2: Modeling Skills and Drills
- Worksheet Layout (video & notes)
- Constructing Calculations (video, notes, handouts, download)
- Links and Calculation Blocks (video & notes)
- Re-using Calculation Blocks (video & notes)
- Lesson 2: Exam

Lesson 3: Advanced Setup & Techniques
- Inputs & Model Build Process (notes)
- FAST Format Macros (video, notes, handouts, download)
- Customizing the Default Chart (video & notes)
- Paste Link (video & notes)
- Modeling with Placeholders (video & notes)
- Lesson 3: Exam

Lesson 4: FAST Implementation
- Timing Flags (video & notes)
- Sign Convention - Design Overview (video)
- Sign Convention - FAST Implementation (video & example)
- Modeling Balances (video & notes)
- 'Tmp' Sheet (notes & example)
- Lesson 4: Exam

Included Modules:
  • Lesson 1: Initial Set-up

    Lesson 1: Initial Set-up

  • The FAST Standard

    The FAST Standard

  • Excel 2003 Setup

    Excel 2003 Setup

  • Excel 2007 Setup

    Excel 2007 Setup

  • Calculation Options

    Calculation Options

  • Lesson 1: Exam

    Lesson 1: Exam

  • Lesson 2: Modelling Skills & Drills

    Lesson 2: Modelling Skills & Drills

  • Worksheet Layout

    Worksheet Layout Key rules: Each column should have a specific purpose (the reciprocal to first rule) Each purpose should have a specific column If you like, it’s the same as your grandmother’s old saying “a place for everything and everything in its place.” Column E is a wide column that’s for row... more

  • Constructing Calculations

    Constructing Calculations All of what you do when you’re modelling will be writing formulae and copying them across so worth spending time getting good at it. Writing a formula Generally speaking, when we are writing a timed series based formula we will be starting in column J and then copying it across and all the ... more

  • Links and Calculations Blocks

    Links and Calculations Blocks So, what’s the alternative to long formulas? Well, we saw that in business communication we’re taught to break things out into bullet points and to keep our communication short and simple; and that’s what we’re going to do in our models also. The temptation is just to write the formula and poi... more

  • Re-using Calculation Blocks

    Re-using Calculation Blocks Another benefit of the calculation block structure is that it’s easy to copy calculations and then just replace ingredients. For example, if you’ve spent some time modelling Tranche A of debt and Tranche B has the same structure, you can just copy the calculation blocks for Tranche A and replace ... more

  • Lesson 2: Exam

    Lesson 2: Exam

  • Lesson 3: Advanced Setup & Techniques

    Lesson 3: Advanced Setup & Techniques

  • Inputs & Model Build Process

    Inputs & Model Build Process

  • FAST Format Macros

    FAST Format Macros We have two objectives in formatting our models: Make the formats we use consistent between modellers and between models. Make the process of applying formatting easy, so that we can do it as we go along and don’t have to come back to it later. Before we go any further, download the FA... more

  • Customizing the Default Chart

    Customizing the Default Chart This video walks through through customising the default chart in Excel. What we don’t cover is “what makes a good chart” – this is a whole discipline in itself, but a fascinating one. We’ve included a few links below to get you started in creating more effective and impactful charts. (Hint – ... more

  • Paste Link

    Paste Link Up to now, when we’ve been creating links, we’ve been where we want the link to be. We’ve typed = into column E and then gone to point at the item we want to link to. But what if you’re starting from the thing you want to link to rather than the place you want to put the link? What we’d hav... more

  • Lesson 3: Exam

    Lesson 3: Exam

  • Lesson 4: FAST Implementation

    Lesson 4: FAST Implementation

  • Modeling with Placeholders

    Modeling with Placeholders Placeholders allow us to mark temporary code in our model and move on. In this video you’ll learn: Why it’s important to have a standardised way of marking placeholders What the 3 stages of creating a placeholder are What keystrokes are used to create placeholders The reality of fin... more

  • Timing Flags

    Timing Flags For every line item that we model, we have to be able to answer two fundamental questions: 1. How much? 2. When? Simple right. Most of what we’ve been doing in the course so far has been focused on answering the “how much” type questions. Now is the time to focus on “when?”. Whenever... more

  • Sign Convention Design Overview

    Sign Convention Design Overview For an example of the logic setup of a sign switch, review the ‘Tmp’ worksheet in the Input Sample Model you downloaded during the last lesson.

  • Sign Convention FAST Implementation

    Sign Convention FAST Implementation

  • Modeling Balances

    Modeling Balances There are two basic types of line items in our model: flows – an amount of “value” passing in and out of the business within a period balances – the amount of value present at a particular time All balances have the same 3 essential properties: upward flow – the flow that makes the... more

  • Tmp Sheet

    Tmp Sheet

  • Lesson 4: Exam

    Lesson 4: Exam

  • Icon-pdf
  • Excel 2003 Shortcut Keys

  • 54.84 KB
  • Icon-pdf
  • Excel 2007 / 2010 Shortcut Keys

  • 55.32 KB
  • Icon-pdf
  • Drills Sheet

  • 62 KB
  • Icon-pdf
  • FAST Format Macros Shortcut Keys

  • 24.08 KB
  • Icon-pdf
  • FAST Format Macros

  • 202.5 KB
  • Icon-pdf
  • Input Sample Model

  • 235.5 KB