Certification training

The Complete Financial Modeling and Valuation Course

Prepare for your exam with a structured video course built for focused study, topic review, and repeatable progress before exam day.

133Lectures
6h 33m 18sDuration
Vendor
The Complete Financial Modeling and Valuation Course course cover Best seller
certification training 133 lessons arranged in a guided course path
Course overview

Study with a clear path.

Move through focused sections, review lecture timing, and return directly to the objectives that need more work.

Sequenced lessons

Follow the course in order or jump directly to the section you need to revisit.

Video-first prep

Use concise lecture blocks for technical review before moving into exam practice.

Fast access

Your purchased course becomes available in the member area after confirmed payment.

Curriculum

Course sections.

12 sections, 133 lessons, and lecture-level duration details.

01 What does the course cover? 2m 26s

01 Introduction to Excel - Welcome Lecture 37s
02 Overview of Excel 3m 39s
03 Basic Manipulations with Rows & Columns 1m 48s
04 The Excel Ribbon 2m 42s
05 Data Entry in Excel 3m 3s
06 Introduction to Formatting 5m 38s
07 Introduction to Excel Formulas 2m 58s
08 Introduction to Excel Functions 3m 47s
09 Cut, Copy & Paste 2m 8s
10 Paste Special 1m 28s

01 Excel Best Practices - Welcome Lecture 41s
02 Initial formatting of an Excel sheet in order to render it professional 1m 53s
03 Fast scrolling through Excel sheets 1m 29s
04 Introduction to fixing of cell references 2m 8s
05 Using the Alt plus Enter combination 38s
06 Learn how to organize your data with Text to Columns 1m 53s
07 Learn how to Use the Wrap Text Button 44s
08 Create easily printable documents in Excel by using Set Print Area 1m 11s
09 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

01 Keyboard Shortcuts Save LOTS of time in Excel 4m 32s

01 Excel's Key Functions - Welcome Lecture 45s
02 Key Excel Functions: Sum, Sumif and Sumifs 4m 20s
03 Key Excel Functions: Count, Counta, Countif, Countifs 4m
04 Key Excel Functions: Average and Averageif 1m 53s
05 Elaborate text efficiently: Left, Right, Mid, Upper, Lower,Proper, Concatenate 4m 24s
06 Find the minimum or maximum value in a range of cells in Excel 51s
07 Include Round in your Financial Models 1m 1s
08 Learn how to transfer data efficiently in Excel: Vlookup and Hlookup 7m 31s
09 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

01 Exercise - Excel's "Sumifs" function - explained & solved 8m

01 Future and present values in Excel 7m 2s
02 Calculating the rate of return of an investment with the IRR function 3m 30s
03 Calculating a complete loan schedule in Excel 6m 16s
04 Date functions in Excel 5m 38s

01 Introduction to Pivot Tables & Their Application 1m 30s
02 Creating Pivot Tables is easy! 3m 42s
03 Give Your Excel Pivot Tables a Makeover 2m 9s
04 Modifying and Pivoting Fields In Order to Obtain the Pivot Table that You Need 4m 28s
05 Learn More About GetPivotData - A Very Important Excel Function 3m 40s
06 An Introduction to Slicers - The Moden Day Pivot Table Filters 4m 20s

01 Case Study - Build a P&L From Scratch - Welcome Lecture 1m 2s
02 Introduction to the Case Study 37s
03 Understand your data source before you start working on It 2m 22s
04 Order the source worksheets 1m 57s
05 Create a code: the best way to organize your data and work efficiently with It 1m 48s
06 Learn how to create a Database 1m 50s
07 Use Vlookup in order to fill the Database sheet 5m 17s
08 Use Sumif in order to complete the Database sheet 4m 7s
09 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

01 Introduction to the Case Study 1m 55s
02 Preliminary mapping of the data extraction 2m 5s
03 Working with an SAP data extraction 3m 17s
04 Creating an output structure of the FMCG model 2m 24s
05 Improving the layout and appearance of the FMCG report 4m 13s
06 Inserting formulas and automating calculations 2m 25s
07 Creating a Master Pivot Table: The main data source for the FMCG report 1m 50s
08 GetPivotData is great! Extracting data from the Master Pivot Table 5m 40s
09 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

01 Financial Modeling Basics - Welcome Lecture 42s
02 What is a Financial model? 2m 2s
03 Why use Financial models? 2m 35s
04 Financial modeling: Worst Practices - Things you should avoid 5m 49s
05 Financial modeling: Best practices 4m 58s
06 Financial modeling: The types of models that are built in practice 4m 42s
07 Financial modeling: The right level of detail in a model 2m 35s
08 Financial modeling: Forecasting guidelines 2m 51s
09 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

01 Valuation Case Study - Welcome Lecture 33s
02 Introduction to the DCF exercise 1m 7s
03 The various stages of a complete DCF Valuation 6m 30s
04 Description of the structure of the DCF model 2m 53s
05 A glimpse at the company we are valuing - Cheeseco 1m 9s
06 Modeling the top line 3m 39s
07 Introducing scenarios to the model with Choose 2m 12s
08 Modeling other items: Other revenues and Cogs 3m 46s
09 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
Continue preparing

Connect the lessons to exam-day practice.

Use the course for structured review, then move into current questions, timed simulator sessions, and a broader vendor catalog.

VTSimu exam simulatorRehearse pacing in focused desktop sessions.
Unlimited AccessBuild a practice library across vendors and formats.
More video coursesExplore every available certification training track.