Fundamentals of Financial Modeling Online Course

The Evaluation of Mining Real Estate

Fundamentals of Financial Modeling

Login to your SavvyInvestor account

This four part series provides tips and tricks for Excel model builders, gives advice on how to audit your financial models, demonstrates how to use better formulas, and shows you how to monitor and handle uncertainty using scenarios planning.

Excel TIps and Tricks

In this first module we learn how to speed up your Excel modeling skills by using keystroke navigation. We also learn to significantly improve worksheet editing by learning to use editing shortcuts in Excel 2003 or 2007, and develop the skill every model builder needs to edit and model a spreadsheet in mere minutes. This course incorporates sophisticated search and navigation tools that allow you to go at your own pace while pop quizzes get you to test what you have just learnt. Included in this module is a PDF – Excel Shortcuts Reference Guide for both PC and MAC - that can be used while taking the course and downloaded to your computer for future reference.

Better Formulas

In this second module we build flexibility into financial forecasts, break down complex calculations, minimize errors in Excel models and understand Excel function syntax. Each concept is reinforced with practical and applied exercises and case studies. This module also includes a PDF – Excel Shortcuts Reference Guide for both PC and MAC - that can be used while taking the course and downloaded to your computer for future reference.

Catering for Uncertainty

In this third module we learn how to perform sensitivity analysis, understand how data tables and goal seek to facilitate your model building process, learn how to measure the impact of future uncertainty on cash flows and profit with scenario planning, and learn how to use scenario and solver tools to see how certain inputs can impact your model. This module also includes a PDF – Excel Shortcuts Reference Guide for both PC and MAC - that can be used while taking the course and downloaded to your computer for future reference.

Auditing a Model

In this final module we learn how to quickly and easily find errors and audit a spreadsheet. We also cover how the auditing toolbar can help make your spreadsheet error-free and learn to use test data to uncover errors. This course incorporates sophisticated search and navigation tools that allow you to go at your own pace while pop quizzes get you to test what you have just learnt. Included in this module is a PDF – Excel Shortcuts Reference Guide for both PC and MAC - that can be used while taking the course and downloaded to your computer for future reference.

Accounting Fundamentals

Reading Financial Statements

Financial Analysis

Financial Math

Fundamentals of Financial Modeling

Building a Financial Model

Financial Modeling Using VBA

Business Valuation Fundamentals

Behavioural Finance

Capital Markets Fundamentals