Course Curriculum
Introduction | |||
Learn Financial Modelling in Excel | 00:03:00 | ||
Financial Modelling In Excel For Beginners | |||
Beginner – What is a Financial Model | 00:04:00 | ||
Beginner – Financial Model Design | 00:08:00 | ||
Beginner – Scenario Analysis | 00:03:00 | ||
Beginner – Documentation | 00:05:00 | ||
Beginner – Excel – Cell References | 00:09:00 | ||
Beginner – Excel – IF Formula | 00:02:00 | ||
Beginner – Excel – AND Formula | 00:03:00 | ||
Beginner – Excel – OR Formula | 00:03:00 | ||
Beginner – Excel – Nested Formulas | 00:03:00 | ||
Beginner – Model – Conditional Formatting | 00:05:00 | ||
Beginner – Excel – Data validation | 00:05:00 | ||
Beginner – Model – Inputs | 00:09:00 | ||
Beginner – Model – Revenue | 00:07:00 | ||
Beginner – Model – Expenses | 00:07:00 | ||
Beginner – Model – Profit and Loss | 00:07:00 | ||
Beginner – Model – Cash Flow | 00:10:00 | ||
Beginner – Model – Adding Scenarios | 00:15:00 | ||
Beginner – Model – Charts | 00:05:00 | ||
Beginner – Model – Conditional Formatting | 00:05:00 | ||
Beginner – Model – Protect Workbook | 00:06:00 | ||
Financial Modelling In Excel - Intermediate | |||
Intermediate – Modules in the Course | 00:03:00 | ||
Intermediate – Design Principles | 00:07:00 | ||
Intermediate – Excel – Aggregate Functions | 00:05:00 | ||
Intermediate – Excel – Lookup Functions | 00:14:00 | ||
Intermediate – Excel – Forecasting | 00:06:00 | ||
Intermediate – Excel – Mixed References and Named Ranges | 00:09:00 | ||
Intermediate – Excel – External Links | 00:14:00 | ||
Intermediate – Skills – Error Checks | 00:09:00 | ||
Intermediate – Skills – Goal Seek | 00:08:00 | ||
Intermediate – Skills – WACC | 00:08:00 | ||
Intermediate – Skills – NPV and IRR | 00:09:00 | ||
Intermediate – Model – Introduction | 00:03:00 | ||
Intermediate – Model – Staff Expenses | 00:17:00 | ||
Intermediate – Model – Staff Expenses Summary | 00:07:00 | ||
Intermediate – Model – Revenue | 00:19:00 | ||
Intermediate – Model – Market Analysis | 00:02:00 | ||
Intermediate – Model – Profit and Loss | 00:07:00 | ||
Intermediate – Model – NPV IRR | 00:07:00 | ||
Intermediate – Model – Payback Period | 00:04:00 | ||
Intermediate – Model – Scenario Analysis | 00:07:00 | ||
Support Materials | |||
Financial Modelling in Excel: Beginner to Intermediate | 00:00:00 |

Financial Modelling in Excel: Beginner to Intermediate
Course Reviews
No Reviews found for this course.