Practice in browser

New Web Test Engine

Experience our brand new Web Test Engine, practice exams directly in your browser!

The Complete Financial Modeling and Valuation Course

The Complete Financial Modeling and Valuation Course

BEST SELLER 133 Lectures 6h 33m 18s

Prepare for your examination with our training course. The course contains a complete batch of videos that will provide you with profound and thorough knowledge related to certification exam. Pass the test with flying colors.

$13.99 $24.99

Curriculum For This Course

1 lectures 2m 26s
  • 1. What does the course cover?
    2m 26s

10 lectures 27m 48s
  • 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

19 lectures 32m 21s
  • 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 lectures 4m 32s
  • 1. Keyboard Shortcuts Save LOTS of time in Excel
    4m 32s

15 lectures 49m 33s
  • 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 lectures 8m
  • 1. Exercise - Excel's "Sumifs" function - explained & solved
    8m

4 lectures 22m 26s
  • 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

6 lectures 19m 49s
  • 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

20 lectures 1h 3m 15s
  • 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

11 lectures 34m 4s
  • 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

12 lectures 42m 10s
  • 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

33 lectures 1h 26m 54s
  • 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
Hot Exams
VTSimu
VTSimu Exam Simulator
How to open .dumpsarena files

Use Free VTSimu Exam Simulator to open .dumpsarena files

VTSimu Exam Simulator

Windows Mac Learn More
Satisfaction Guaranteed

98.4% DumpsArena users pass

Our team is dedicated to delivering top-quality exam practice questions. We proudly offer a hassle-free satisfaction guarantee.

Why choose DumpsArena?

23,812+

Satisfied Customers Since 2018

  • Always Up-to-Date
  • Accurate and Verified
  • Free Regular Updates
  • 24/7 Customer Support
  • Instant Access to Downloads
Secure Experience

Guaranteed safe checkout.

At DumpsArena, your shopping security is our priority. We utilize high-security SSL encryption, ensuring that every purchase is 100% secure.

SECURED CHECKOUT
Need Help?

Feel free to contact us anytime!

Contact Support