Learn Financial Modeling Online

This course will teach you everything you need to know about building a financial model. The is the same course taught by the top Wall Street training firm to bring you all industry best practices.

Learn Financial Modeling Online

Learn financial modeling online from professional Wall Street trainers. 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

1 – Learn how to speed up your Excel modelling skills by using keystroke navigation

2 – Significantly improve how you can edit your worksheet by learning how to use editing shortcuts on Excel 2003 & 2007

3 – Develop the skill every model builder needs in editing and modelling your spreadsheet in mere minutes

Better formulas

1 – Build flexibility into financial forecasts

2 – Break down complex calculations

3 – Minimize errors in Excel models

4 – Understand Excel function syntax

Catering for uncertainty

1 – Learn how to perform sensitivity analysis

2 – Understand how data tables and goal seek can facilitate your model building process

3 – Learn how to measure impact of future uncertainty on cash flows and profit with scenario planning

4 – Learn how to use scenario and solver tools to see how certain inputs can impact your model

Auditing a model

1 – Learn how to quickly and easily find errors and audit a spreadsheet

2 – Understand how the auditing toolbar can help make your spreadsheet error-free

3 – Learn how to use test data to uncover errorsIncluded 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.

Learn from the best
Build your resume
Accelerate your career