The Complete Financial Modeling and Valuation Course
What’s included
$14.99 / $24.99
Get ready for your exam by enrolling in our comprehensive training course. This course includes a full set of instructional videos designed to equip you with in-depth knowledge essential for passing the certification exam with flying colors.
Pay once, own it forever
Video Courses
Beginner to Pro in Excel: Financial Modeling and Valuation - Welcome!
| Lectures | Duration |
|---|---|
| 1. What does the course cover? | 2m 26s |
1. What does the course cover?
2m 26s
Introduction to Excel
| Lectures | Duration |
|---|---|
| 1. Introduction to Excel - Welcome Lecture | 37s |
| 2. Overview of Excel | 3m 39s |
| 3. Basic Manipulations with Rows & Columns | 1m 48s |
| 4. The Excel Ribbon | 2m 42s |
| 5. Data Entry in Excel | 3m 3s |
| 6. Introduction to Formatting | 5m 38s |
| 7. Introduction to Excel Formulas | 2m 58s |
| 8. Introduction to Excel Functions | 3m 47s |
| 9. Cut, Copy & Paste | 2m 8s |
| 10. Paste Special | 1m 28s |
1. Introduction to Excel - Welcome Lecture
37s
2. Overview of Excel
3m 39s
3. Basic Manipulations with Rows & Columns
1m 48s
4. The Excel Ribbon
2m 42s
5. Data Entry in Excel
3m 3s
6. Introduction to Formatting
5m 38s
7. Introduction to Excel Formulas
2m 58s
8. Introduction to Excel Functions
3m 47s
9. Cut, Copy & Paste
2m 8s
10. Paste Special
1m 28s
Useful tips and tools for your work in Excel
| Lectures | Duration |
|---|---|
| 1. Excel Best Practices - Welcome Lecture | 41s |
| 2. Initial formatting of an Excel sheet in order to render it professional | 1m 53s |
| 3. Fast scrolling through Excel sheets | 1m 29s |
| 4. Introduction to fixing of cell references | 2m 8s |
| 5. Using the Alt plus Enter combination | 38s |
| 6. Learn how to organize your data with Text to Columns | 1m 53s |
| 7. Learn how to Use the Wrap Text Button | 44s |
| 8. Create easily printable documents in Excel by using Set Print Area | 1m 11s |
| 9. Find and select special types of cells with Select Special (F5) | 1m 31s |
| 10. Learn how to assign dynamic names within a Financial Model | 1m 21s |
| 11. Define a named range in Excel | 1m 34s |
| 12. Assign custom formats to specific cells within a Financial Model (ex | 1m 33s |
| 13. Macros are a great timesaver! Here's why! | 2m 51s |
| 14. Create a drop-down list by using Data Validation | 1m 44s |
| 15. Using Custom-sort in order to sort multiple columns within a table | 1m 23s |
| 16. Create a great Index page at the beginning of your models - Hyperlinks | 1m 12s |
| 17. Fix the top row of your table with Freeze Panes | 1m 11s |
| 18. Filter by color - an excellent tool | 1m 44s |
| 19. Working with conditional formatting | 5m 40s |
1. Excel Best Practices - Welcome Lecture
41s
2. Initial formatting of an Excel sheet in order to render it professional
1m 53s
3. Fast scrolling through Excel sheets
1m 29s
4. Introduction to fixing of cell references
2m 8s
5. Using the Alt plus Enter combination
38s
6. Learn how to organize your data with Text to Columns
1m 53s
7. Learn how to Use the Wrap Text Button
44s
8. Create easily printable documents in Excel by using Set Print Area
1m 11s
9. Find and select special types of cells with Select Special (F5)
1m 31s
10. Learn how to assign dynamic names within a Financial Model
1m 21s
11. Define a named range in Excel
1m 34s
12. Assign custom formats to specific cells within a Financial Model (ex
1m 33s
13. Macros are a great timesaver! Here's why!
2m 51s
14. Create a drop-down list by using Data Validation
1m 44s
15. Using Custom-sort in order to sort multiple columns within a table
1m 23s
16. Create a great Index page at the beginning of your models - Hyperlinks
1m 12s
17. Fix the top row of your table with Freeze Panes
1m 11s
18. Filter by color - an excellent tool
1m 44s
19. Working with conditional formatting
5m 40s
Keyboard shortcuts in Excel
| Lectures | Duration |
|---|---|
| 1. Keyboard Shortcuts Save LOTS of time in Excel | 4m 32s |
1. Keyboard Shortcuts Save LOTS of time in Excel
4m 32s
Excel's key functions and functionalities made easy
| Lectures | Duration |
|---|---|
| 1. Excel's Key Functions - Welcome Lecture | 45s |
| 2. Key Excel Functions: Sum, Sumif and Sumifs | 4m 20s |
| 3. Key Excel Functions: Count, Counta, Countif, Countifs | 4m |
| 4. Key Excel Functions: Average and Averageif | 1m 53s |
| 5. Elaborate text efficiently: Left, Right, Mid, Upper, Lower,Proper, Concatenate | 4m 24s |
| 6. Find the minimum or maximum value in a range of cells in Excel | 51s |
| 7. Include Round in your Financial Models | 1m 1s |
| 8. Learn how to transfer data efficiently in Excel: Vlookup and Hlookup | 7m 31s |
| 9. Index, Match and their combination - the perfect substitute of Vlookup | 7m 18s |
| 10. A great Excel technique: Index, Match, Match | 4m 59s |
| 11. Using Excel's Iferror function to trap spreadsheet errors | 1m 42s |
| 12. Learn how to render your models flexible with Choose | 2m 18s |
| 13. Use Goal Seek in order to find the result that you are looking for | 2m 13s |
| 14. Include sensitivity analysis in your models through Data Tables | 4m 6s |
| 15. Excel's dynamic and interactive tables: Pivot tables | 2m 12s |
1. Excel's Key Functions - Welcome Lecture
45s
2. Key Excel Functions: Sum, Sumif and Sumifs
4m 20s
3. Key Excel Functions: Count, Counta, Countif, Countifs
4m
4. Key Excel Functions: Average and Averageif
1m 53s
5. Elaborate text efficiently: Left, Right, Mid, Upper, Lower,Proper, Concatenate
4m 24s
6. Find the minimum or maximum value in a range of cells in Excel
51s
7. Include Round in your Financial Models
1m 1s
8. Learn how to transfer data efficiently in Excel: Vlookup and Hlookup
7m 31s
9. Index, Match and their combination - the perfect substitute of Vlookup
7m 18s
10. A great Excel technique: Index, Match, Match
4m 59s
11. Using Excel's Iferror function to trap spreadsheet errors
1m 42s
12. Learn how to render your models flexible with Choose
2m 18s
13. Use Goal Seek in order to find the result that you are looking for
2m 13s
14. Include sensitivity analysis in your models through Data Tables
4m 6s
15. Excel's dynamic and interactive tables: Pivot tables
2m 12s
Global Econ. +Excel Part 4/4: Fiscal Policy, WTO, Monopolies, Bitcoin & More
| Lectures | Duration |
|---|---|
| 1. Exercise - Excel's "Sumifs" function - explained & solved | 8m |
1. Exercise - Excel's "Sumifs" function - explained & solved
8m
Financial functions in Excel
| Lectures | Duration |
|---|---|
| 1. Future and present values in Excel | 7m 2s |
| 2. Calculating the rate of return of an investment with the IRR function | 3m 30s |
| 3. Calculating a complete loan schedule in Excel | 6m 16s |
| 4. Date functions in Excel | 5m 38s |
1. Future and present values in Excel
7m 2s
2. Calculating the rate of return of an investment with the IRR function
3m 30s
3. Calculating a complete loan schedule in Excel
6m 16s
4. Date functions in Excel
5m 38s
Microsoft Excel's Pivot Tables in Depth
| Lectures | Duration |
|---|---|
| 1. Introduction to Pivot Tables & Their Application | 1m 30s |
| 2. Creating Pivot Tables is easy! | 3m 42s |
| 3. Give Your Excel Pivot Tables a Makeover | 2m 9s |
| 4. Modifying and Pivoting Fields In Order to Obtain the Pivot Table that You Need | 4m 28s |
| 5. Learn More About GetPivotData - A Very Important Excel Function | 3m 40s |
| 6. An Introduction to Slicers - The Moden Day Pivot Table Filters | 4m 20s |
1. Introduction to Pivot Tables & Their Application
1m 30s
2. Creating Pivot Tables is easy!
3m 42s
3. Give Your Excel Pivot Tables a Makeover
2m 9s
4. Modifying and Pivoting Fields In Order to Obtain the Pivot Table that You Need
4m 28s
5. Learn More About GetPivotData - A Very Important Excel Function
3m 40s
6. An Introduction to Slicers - The Moden Day Pivot Table Filters
4m 20s
Case Study - Building a Complete P&L from scratch in Excel
| Lectures | Duration |
|---|---|
| 1. Case Study - Build a P&L From Scratch - Welcome Lecture | 1m 2s |
| 2. Introduction to the Case Study | 37s |
| 3. Understand your data source before you start working on It | 2m 22s |
| 4. Order the source worksheets | 1m 57s |
| 5. Create a code: the best way to organize your data and work efficiently with It | 1m 48s |
| 6. Learn how to create a Database | 1m 50s |
| 7. Use Vlookup in order to fill the Database sheet | 5m 17s |
| 8. Use Sumif in order to complete the Database sheet | 4m 7s |
| 9. Use Index & Match as a substitute of Vlookup | 3m 59s |
| 10. Mapping of the rows in the Database sheet | 2m 7s |
| 11. Building the structure of the P&L sheet | 1m 59s |
| 12. Formatting sets You apart from the competition in Excel - A Practical Example | 3m 15s |
| 13. Populate the P&L sheet with Sumif | 2m 39s |
| 14. Learn how to find mistakes with Countif | 2m 17s |
| 15. Calculating year-on-year percentage variations the proper way | 2m 59s |
| 16. Create professional and good-looking charts - Introduction | 20s |
| 17. Build a Column Stacked Chart with a secondary line axis in Excel | 5m 52s |
| 18. Learn how to build effective Doughnut Charts in Excel | 4m 6s |
| 19. Learn how to build an Area Chart in Excel | 4m 1s |
| 20. Learn how to create Bridge Charts | 10m 41s |
1. Case Study - Build a P&L From Scratch - Welcome Lecture
1m 2s
2. Introduction to the Case Study
37s
3. Understand your data source before you start working on It
2m 22s
4. Order the source worksheets
1m 57s
5. Create a code: the best way to organize your data and work efficiently with It
1m 48s
6. Learn how to create a Database
1m 50s
7. Use Vlookup in order to fill the Database sheet
5m 17s
8. Use Sumif in order to complete the Database sheet
4m 7s
9. Use Index & Match as a substitute of Vlookup
3m 59s
10. Mapping of the rows in the Database sheet
2m 7s
11. Building the structure of the P&L sheet
1m 59s
12. Formatting sets You apart from the competition in Excel - A Practical Example
3m 15s
13. Populate the P&L sheet with Sumif
2m 39s
14. Learn how to find mistakes with Countif
2m 17s
15. Calculating year-on-year percentage variations the proper way
2m 59s
16. Create professional and good-looking charts - Introduction
20s
17. Build a Column Stacked Chart with a secondary line axis in Excel
5m 52s
18. Learn how to build effective Doughnut Charts in Excel
4m 6s
19. Learn how to build an Area Chart in Excel
4m 1s
20. Learn how to create Bridge Charts
10m 41s
Case Study - Building an FMCG Model from Scratch
| Lectures | Duration |
|---|---|
| 1. Introduction to the Case Study | 1m 55s |
| 2. Preliminary mapping of the data extraction | 2m 5s |
| 3. Working with an SAP data extraction | 3m 17s |
| 4. Creating an output structure of the FMCG model | 2m 24s |
| 5. Improving the layout and appearance of the FMCG report | 4m 13s |
| 6. Inserting formulas and automating calculations | 2m 25s |
| 7. Creating a Master Pivot Table: The main data source for the FMCG report | 1m 50s |
| 8. GetPivotData is great! Extracting data from the Master Pivot Table | 5m 40s |
| 9. Combining Slicers and GetPivotData: The key to our success | 3m 14s |
| 10. Getting fancy with Excel slicers - Good-looking Excel slicers | 3m 7s |
| 11. This is how the report can be used in practice by high-level executives | 3m 54s |
1. Introduction to the Case Study
1m 55s
2. Preliminary mapping of the data extraction
2m 5s
3. Working with an SAP data extraction
3m 17s
4. Creating an output structure of the FMCG model
2m 24s
5. Improving the layout and appearance of the FMCG report
4m 13s
6. Inserting formulas and automating calculations
2m 25s
7. Creating a Master Pivot Table: The main data source for the FMCG report
1m 50s
8. GetPivotData is great! Extracting data from the Master Pivot Table
5m 40s
9. Combining Slicers and GetPivotData: The key to our success
3m 14s
10. Getting fancy with Excel slicers - Good-looking Excel slicers
3m 7s
11. This is how the report can be used in practice by high-level executives
3m 54s
Financial Modeling Fundamentals
| Lectures | Duration |
|---|---|
| 1. Financial Modeling Basics - Welcome Lecture | 42s |
| 2. What is a Financial model? | 2m 2s |
| 3. Why use Financial models? | 2m 35s |
| 4. Financial modeling: Worst Practices - Things you should avoid | 5m 49s |
| 5. Financial modeling: Best practices | 4m 58s |
| 6. Financial modeling: The types of models that are built in practice | 4m 42s |
| 7. Financial modeling: The right level of detail in a model | 2m 35s |
| 8. Financial modeling: Forecasting guidelines | 2m 51s |
| 9. Building a complete model - Important considerations | 2m 15s |
| 10. Modeling the Income statement | 5m 58s |
| 11. Modeling the Balance sheet - Part 1 | 2m 35s |
| 12. Modeling the Balance sheet - Part 2 | 5m 8s |
1. Financial Modeling Basics - Welcome Lecture
42s
2. What is a Financial model?
2m 2s
3. Why use Financial models?
2m 35s
4. Financial modeling: Worst Practices - Things you should avoid
5m 49s
5. Financial modeling: Best practices
4m 58s
6. Financial modeling: The types of models that are built in practice
4m 42s
7. Financial modeling: The right level of detail in a model
2m 35s
8. Financial modeling: Forecasting guidelines
2m 51s
9. Building a complete model - Important considerations
2m 15s
10. Modeling the Income statement
5m 58s
11. Modeling the Balance sheet - Part 1
2m 35s
12. Modeling the Balance sheet - Part 2
5m 8s
Learn how to build a Discounted Cash Flow model in Excel
| Lectures | Duration |
|---|---|
| 1. Valuation Case Study - Welcome Lecture | 33s |
| 2. Introduction to the DCF exercise | 1m 7s |
| 3. The various stages of a complete DCF Valuation | 6m 30s |
| 4. Description of the structure of the DCF model | 2m 53s |
| 5. A glimpse at the company we are valuing - Cheeseco | 1m 9s |
| 6. Modeling the top line | 3m 39s |
| 7. Introducing scenarios to the model with Choose | 2m 12s |
| 8. Modeling other items: Other revenues and Cogs | 3m 46s |
| 9. Modeling other items: Operating expenses and D&A | 2m 33s |
| 10. Modeling other items: Interest expenses, Extraordinary items and Taxes | 2m 28s |
| 11. Forecasting Balance Sheet items | 43s |
| 12. An introduction to the "Days" methodology | 1m 35s |
| 13. Calculation of DSO, DPO and DOI for the historical period | 1m 30s |
| 14. Forecasting DSO, DPO and DOI | 2m 23s |
| 15. Forecasting Property, Plant & Equipment, Other assets and Other liabilities | 2m 27s |
| 16. Creating an output P&L sheet | 2m 36s |
| 17. Populating the output P&L sheet | 2m 14s |
| 18. Populating the output BS sheet | 1m 49s |
| 19. Completing the output BS sheet for the historical period | 3m 41s |
| 20. Creating a structure for the calculation of Unlevered Free Cash Flows | 3m 5s |
| 21. Bridging Unlevered Free Cash Flow to Net Cash Flow | 1m 55s |
| 22. Calculating Unlevered Free Cash Flow | 6m 1s |
| 23. Calculating Net Cash Flow | 3m 56s |
| 24. Obtaining the rest of the Cash Flows through Find and Replace | 3m 52s |
| 25. Introducing Weighted Average Cost of Capital and Perpetuity Growth | 1m 56s |
| 26. Discounting Unlevered Free Cash Flows in order to obtain their Present Value | 2m 50s |
| 27. Calculating Continuing Value and Enterprise Value of the business | 2m 17s |
| 28. Calculating Equity Value | 1m 21s |
| 29. Sensitivity analysis for WACC and perpetuity growth | 4m 17s |
| 30. A possible application of Goal Seek | 1m 40s |
| 31. Using charts in order to summarize the results of the DCF Model | 4m 38s |
| 32. You Made It! | 2m 16s |
| 33. Congratulations!! | 1m 2s |
1. Valuation Case Study - Welcome Lecture
33s
2. Introduction to the DCF exercise
1m 7s
3. The various stages of a complete DCF Valuation
6m 30s
4. Description of the structure of the DCF model
2m 53s
5. A glimpse at the company we are valuing - Cheeseco
1m 9s
6. Modeling the top line
3m 39s
7. Introducing scenarios to the model with Choose
2m 12s
8. Modeling other items: Other revenues and Cogs
3m 46s
9. Modeling other items: Operating expenses and D&A
2m 33s
10. Modeling other items: Interest expenses, Extraordinary items and Taxes
2m 28s
11. Forecasting Balance Sheet items
43s
12. An introduction to the "Days" methodology
1m 35s
13. Calculation of DSO, DPO and DOI for the historical period
1m 30s
14. Forecasting DSO, DPO and DOI
2m 23s
15. Forecasting Property, Plant & Equipment, Other assets and Other liabilities
2m 27s
16. Creating an output P&L sheet
2m 36s
17. Populating the output P&L sheet
2m 14s
18. Populating the output BS sheet
1m 49s
19. Completing the output BS sheet for the historical period
3m 41s
20. Creating a structure for the calculation of Unlevered Free Cash Flows
3m 5s
21. Bridging Unlevered Free Cash Flow to Net Cash Flow
1m 55s
22. Calculating Unlevered Free Cash Flow
6m 1s
23. Calculating Net Cash Flow
3m 56s
24. Obtaining the rest of the Cash Flows through Find and Replace
3m 52s
25. Introducing Weighted Average Cost of Capital and Perpetuity Growth
1m 56s
26. Discounting Unlevered Free Cash Flows in order to obtain their Present Value
2m 50s
27. Calculating Continuing Value and Enterprise Value of the business
2m 17s
28. Calculating Equity Value
1m 21s
29. Sensitivity analysis for WACC and perpetuity growth
4m 17s
30. A possible application of Goal Seek
1m 40s
31. Using charts in order to summarize the results of the DCF Model
4m 38s
32. You Made It!
2m 16s
33. Congratulations!!
1m 2s