Course curriculum
-
1
1. Financial Modeling - INTRODUCTION
-
2
Financial Modeling - Core Excel Concepts
-
3
Financial Modeling - Create Your First Model
-
4
2. Financial Modeling - INTERMEDIATE
-
5
Financial Modeling - Core Excel Concepts
-
6
Financial Modeling Skills
-
7
Financial Model Business Case
-
8
Quiz Test
-
9
Certificate of Completion
-
Download Workbooks - 1. Financial Modeling Introduction Course Downloadable Financial Modeling Practice Templates Financial Modeling Cheat Sheet Quick Overview What is a Financial Model? Financial Model Design Scenario Analysis Documentation -
Cell References IF Formula AND Formula OR Formula Nested Formulas Conditional Formatting Data validation -
Inputs Revenue Expenses Profit and Loss Cashflow Adding Scenarios Charts Conditional Formatting Protect Workbook -
Download Workbooks - 2. Financial Modeling Intermediate Course Overview of the Intermediate Financial Modeling Course Financial Model Design Principles -
Aggregate Functions Lookup Functions Forecasting Functions Mixed References and Named Ranges External File Links -
Building Error Checks Goal Seek WACC (Weighted Average Cost of Capital) NPV (Net Present Value) & IRR (Internal Rate of Return) -
Introduction to the Financial Model Business Case Staff Costs and Inflation Staff Expenses Summary Forecasting Sales/Revenue Market Analysis Profit & Loss (P&L) and Additional Expenses NPV & IRR Calculations Payback Period Scenario Analysis -
[Quiz] - Financial Modeling -
Unlock your Certificate of Completion
Pricing options
Explain how different pricing options might be valuable to different segments of your audience.
-
Get started now
Free
Regular price