The Complete Financial Modeling and Valuation Course
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.
What’s included
- 133 : Lectures
- 6h 33m 18s : Duration
$14.99/24.99
Beginner to Pro in Excel: Financial Modeling and Valuation - Welcome!
| Lectures |
|---|
| 1. What does the course cover?- 2m 26s |
Introduction to Excel
| Lectures |
|---|
| 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 |
|---|
| 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 |
|---|
| 1. Keyboard Shortcuts Save LOTS of time in Excel- 4m 32s |
Excel's key functions and functionalities made easy
| Lectures |
|---|
| 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 |
|---|
| 1. Exercise - Excel's "Sumifs" function - explained & solved- 8m |
Financial functions in Excel
| Lectures |
|---|
| 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 |
|---|
| 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 |
|---|
| 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 |
|---|
| 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 |
|---|
| 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 |
|---|
| 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 |
