McAfee-Secured Website

Course name Finance Courses The Complete Financial Modeling and Valuation Course: The Complete Financial Modeling and Valuation Course

The Complete Financial Modeling and Valuation Course Video Course

The Complete Financial Modeling and Valuation Course Video Course is developed by Finance Courses Professionals to help you pass the The Complete Financial Modeling and Valuation Course exam.

You Will Learn:

Was 21.99 USD
Now 19.99 USD

Description

This course will improve your knowledge and skills required to pass The Complete Financial Modeling and Valuation Course exam.

Curriculum For This Course

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