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

coggno-logo2
Course Information arrow

Price Discounts

  • Qty

    Price

  • 1

    $95.50

  • 0

    $95.50

  • 0

    $95.50

  • 0

    $95.50

  • 0

    $95.50

  • 0

    $95.50

Syndication Option

Resell Course
Resold modules appear on your website. You earn syndication share from each purchase.


Create Custom Widget
Select a display format that best suits your website, then add courses and customize your widget. We'll provide the HTML for you to use on your site.

13777
Preview-button-95px

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
$95.50

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:
  • 24989

    Lesson 1: Initial Set-up

  • 24713

    The FAST Standard

  • 24715

    Excel 2003 Setup

  • 24716

    Excel 2007 Setup

  • 24717

    Calculation Options

  • 24859

    Lesson 1: Exam

  • 24990

    Lesson 2: Modelling Skills & Drills

  • 24848

    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

  • 24768

    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

  • 24769

    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

  • 24847

    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

  • 24994

    Lesson 2: Exam

  • 24992

    Lesson 3: Advanced Setup & Techniques

  • 24849

    Inputs & Model Build Process

  • 24771

    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

  • 24772

    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

  • 24774

    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

  • 24995

    Lesson 3: Exam

  • 24993

    Lesson 4: FAST Implementation

  • 24775

    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

  • 24776

    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

  • 24777

    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.

  • 24779

    Sign Convention FAST Implementation

  • 24780

    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

  • 24850

    Tmp Sheet

  • 24996

    Lesson 4: Exam

Attachments
  • 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