Course Objective - BFI School

Course Objective - BFI School

Core Modeling Skills - with FAST Standard Course Objective

Core Modeling Skills - with FAST Standard

0% Completed

Introduction

Video - 00:2:19 mins

Course Objective

Video - 00:1:10 mins

Course Prerequisite

Video - 00:00:34 mins

Keyboard Over the Mouse

Importance of the ALT Key

Video - 00:4:22 mins

Importance of Keyboard Shortcut

Video - 00:1:56 mins

Editing Directly from Formula Bar

Video - 00:2:20 mins

Move Selection After ENTER

Video - 00:1:59 mins

Maximizing the Worksheet Interface

Video - 00:1:22 mins

Basic Worksheet Navigation

Video - 00:2:59 mins

Selecting, Adding, & Deleting Content

Video - 00:1:48 mins

Inserting Rows & Columns

Video - 00:3:38 mins

Adding a Formatted Worksheet

Video - 00:2:14 mins

Assessment I

Setting Up Macros

Unblocking Macros

Video - 00:00:00 mins

Formatting & Productivity Macros

Video - 00:7:33 mins

Setting Up Macros

Video - 00:4:42 mins

Model Structure

Introduction to FAST Standard

Video - 00:1:43 mins

What Makes a Model Hard to Read

Video - 00:1:04 mins

Understanding Model Structure

Video - 00:1:44 mins

Model Structure - Workbook Level

Video - 2:41 mins

Model Structure - Worksheet Level

Video - 00:4:12 mins

Model Structure - Calculation Block Level

Video - 00:5:06 mins

Model Structure - Calculation Block Component

Video - 00:2:33 mins

Copying Calculation Block

Video - 00:3:22 mins

Building Up the Model & Charts

Cell References

Video - 00:6:09 mins

Video - 00:2:35 mins

Row Anchored Link

Video - 00:4:05 mins

Benefits of Calculation Block

Video - 00:3:35 mins

Video - 00:4:13 mins

Copying Row Anchored Links

Video - 00:2:23 mins

How to Use Placeholders

Video - 00:4:09 mins

Local, Import & Export Link

Video - 8:52 mins

Video - 00:3:20 mins

Video - 00:14:28 mins

How to Model Balances

Video - 00:7:44 mins

Sign Convention & Switch

Video - 00:3:52 mins

Video - 00:2:46 mins

Embedded Constants

Video - 00:1:43 mins

F11 Quick Charts

Video - 00:2:59 mins

Model Guide & Audit

Verifying Originality of a Financial Model

Video - 00:2:01 mins

Trace Precedents & Dependents

Video - 00:3:47 mins

Video - 00:4:46 mins

Building Model from Scratch & Time Flags

Model Structure and Time Ruler

Video - 00:15:22 mins

Video - 00:00:00 mins

Video - 00:00:00 mins

Replicating the Timeline to Other Sheet

Video - 00:4:49 mins

Assessment II

Announcements Reviews Live Classes Gradebook Certificate Course Info