
The Complete Financial Modeling and Valuation Course Certification Video Training Course
The complete solution to prepare for for your exam with The Complete Financial Modeling and Valuation Course certification video training course. The The Complete Financial Modeling and Valuation Course certification video training course contains a complete set of videos that will provide you with thorough knowledge to understand the key concepts. Top notch prep including Finance Courses The Complete Financial Modeling and Valuation Course exam dumps, study guide & practice test questions and answers.
The Complete Financial Modeling and Valuation Course Certification Video Training Course Exam Curriculum
Beginner to Pro in Excel: Financial Modeling and Valuation - Welcome!
-
1. What does the course cover?
Introduction to Excel
-
1. Introduction to Excel - Welcome Lecture
-
2. Overview of Excel
-
3. Basic Manipulations with Rows & Columns
-
4. The Excel Ribbon
-
5. Data Entry in Excel
-
6. Introduction to Formatting
-
7. Introduction to Excel Formulas
-
8. Introduction to Excel Functions
-
9. Cut, Copy & Paste
-
10. Paste Special
Useful tips and tools for your work in Excel
-
1. Excel Best Practices - Welcome Lecture
-
2. Initial formatting of an Excel sheet in order to render it professional
-
3. Fast scrolling through Excel sheets
-
4. Introduction to fixing of cell references
-
5. Using the Alt plus Enter combination
-
6. Learn how to organize your data with Text to Columns
-
7. Learn how to Use the Wrap Text Button
-
8. Create easily printable documents in Excel by using Set Print Area
-
9. Find and select special types of cells with Select Special (F5)
-
10. Learn how to assign dynamic names within a Financial Model
-
11. Define a named range in Excel
-
12. Assign custom formats to specific cells within a Financial Model (ex. Multiples)
-
13. Macros are a great timesaver! Here's why!
-
14. Create a drop-down list by using Data Validation
-
15. Using Custom-sort in order to sort multiple columns within a table
-
16. Create a great Index page at the beginning of your models - Hyperlinks
-
17. Fix the top row of your table with Freeze Panes
-
18. Filter by color - an excellent tool
-
19. Working with conditional formatting
Keyboard shortcuts in Excel
-
1. Keyboard Shortcuts Save LOTS of time in Excel
Excel's key functions and functionalities made easy
-
1. Excel's Key Functions - Welcome Lecture
-
2. Key Excel Functions: Sum, Sumif and Sumifs
-
3. Key Excel Functions: Count, Counta, Countif, Countifs
-
4. Key Excel Functions: Average and Averageif
-
5. Elaborate text efficiently: Left, Right, Mid, Upper, Lower,Proper, Concatenate
-
6. Find the minimum or maximum value in a range of cells in Excel
-
7. Include Round in your Financial Models
-
8. Learn how to transfer data efficiently in Excel: Vlookup and Hlookup
-
9. Index, Match and their combination - the perfect substitute of Vlookup
-
10. A great Excel technique: Index, Match, Match
-
11. Using Excel's Iferror function to trap spreadsheet errors
-
12. Learn how to render your models flexible with Choose
-
13. Use Goal Seek in order to find the result that you are looking for
-
14. Include sensitivity analysis in your models through Data Tables
-
15. Excel's dynamic and interactive tables: Pivot tables
Global Econ. +Excel Part 4/4: Fiscal Policy, WTO, Monopolies, Bitcoin & More
-
1. Exercise - Excel's "Sumifs" function - explained & solved
Financial functions in Excel
-
1. Future and present values in Excel
-
2. Calculating the rate of return of an investment with the IRR function
-
3. Calculating a complete loan schedule in Excel
-
4. Date functions in Excel
Microsoft Excel's Pivot Tables in Depth
-
1. Introduction to Pivot Tables & Their Application
-
2. Creating Pivot Tables is easy!
-
3. Give Your Excel Pivot Tables a Makeover
-
4. Modifying and Pivoting Fields In Order to Obtain the Pivot Table that You Need
-
5. Learn More About GetPivotData - A Very Important Excel Function
-
6. An Introduction to Slicers - The Moden Day Pivot Table Filters
Case Study - Building a Complete P&L from scratch in Excel
-
1. Case Study - Build a P&L From Scratch - Welcome Lecture
-
2. Introduction to the Case Study
-
3. Understand your data source before you start working on It
-
4. Order the source worksheets
-
5. Create a code: the best way to organize your data and work efficiently with It
-
6. Learn how to create a Database
-
7. Use Vlookup in order to fill the Database sheet
-
8. Use Sumif in order to complete the Database sheet
-
9. Use Index & Match as a substitute of Vlookup
-
10. Mapping of the rows in the Database sheet
-
11. Building the structure of the P&L sheet
-
12. Formatting sets You apart from the competition in Excel - A Practical Example
-
13. Populate the P&L sheet with Sumif
-
14. Learn how to find mistakes with Countif
-
15. Calculating year-on-year percentage variations the proper way
-
16. Create professional and good-looking charts - Introduction
-
17. Build a Column Stacked Chart with a secondary line axis in Excel
-
18. Learn how to build effective Doughnut Charts in Excel
-
19. Learn how to build an Area Chart in Excel
-
20. Learn how to create Bridge Charts
Case Study - Building an FMCG Model from Scratch
-
1. Introduction to the Case Study
-
2. Preliminary mapping of the data extraction
-
3. Working with an SAP data extraction
-
4. Creating an output structure of the FMCG model
-
5. Improving the layout and appearance of the FMCG report
-
6. Inserting formulas and automating calculations
-
7. Creating a Master Pivot Table: The main data source for the FMCG report
-
8. GetPivotData is great! Extracting data from the Master Pivot Table
-
9. Combining Slicers and GetPivotData: The key to our success
-
10. Getting fancy with Excel slicers - Good-looking Excel slicers
-
11. This is how the report can be used in practice by high-level executives
Financial Modeling Fundamentals
-
1. Financial Modeling Basics - Welcome Lecture
-
2. What is a Financial model?
-
3. Why use Financial models?
-
4. Financial modeling: Worst Practices - Things you should avoid
-
5. Financial modeling: Best practices
-
6. Financial modeling: The types of models that are built in practice
-
7. Financial modeling: The right level of detail in a model
-
8. Financial modeling: Forecasting guidelines
-
9. Building a complete model - Important considerations
-
10. Modeling the Income statement
-
11. Modeling the Balance sheet - Part 1
-
12. Modeling the Balance sheet - Part 2
Learn how to build a Discounted Cash Flow model in Excel
-
1. Valuation Case Study - Welcome Lecture
-
2. Introduction to the DCF exercise
-
3. The various stages of a complete DCF Valuation
-
4. Description of the structure of the DCF model
-
5. A glimpse at the company we are valuing - Cheeseco
-
6. Modeling the top line
-
7. Introducing scenarios to the model with Choose
-
8. Modeling other items: Other revenues and Cogs
-
9. Modeling other items: Operating expenses and D&A
-
10. Modeling other items: Interest expenses, Extraordinary items and Taxes
-
11. Forecasting Balance Sheet items
-
12. An introduction to the "Days" methodology
-
13. Calculation of DSO, DPO and DOI for the historical period
-
14. Forecasting DSO, DPO and DOI
-
15. Forecasting Property, Plant & Equipment, Other assets and Other liabilities
-
16. Creating an output P&L sheet
-
17. Populating the output P&L sheet
-
18. Populating the output BS sheet
-
19. Completing the output BS sheet for the historical period
-
20. Creating a structure for the calculation of Unlevered Free Cash Flows
-
21. Bridging Unlevered Free Cash Flow to Net Cash Flow
-
22. Calculating Unlevered Free Cash Flow
-
23. Calculating Net Cash Flow
-
24. Obtaining the rest of the Cash Flows through Find and Replace
-
25. Introducing Weighted Average Cost of Capital and Perpetuity Growth
-
26. Discounting Unlevered Free Cash Flows in order to obtain their Present Value
-
27. Calculating Continuing Value and Enterprise Value of the business
-
28. Calculating Equity Value
-
29. Sensitivity analysis for WACC and perpetuity growth
-
30. A possible application of Goal Seek
-
31. Using charts in order to summarize the results of the DCF Model
-
32. You Made It!
-
33. Congratulations!!
About The Complete Financial Modeling and Valuation Course Certification Video Training Course
The Complete Financial Modeling and Valuation Course certification video training course by prepaway along with practice test questions and answers, study guide and exam dumps provides the ultimate training package to help you pass.
This video course is dedicated to Financial Modeling in Excel. If you want to be an expert in Excel and get a job with good prospects, this training is definitely for you.
What are the topics included in the course?
After a short introduction, you will begin to master Excel. There are lectures covering Excel ribbon, data entry, formulas and functions, operations with columns and rows. 19 concise lectures will highlight the tips and tricks that you can take into consideration when working in Excel: using wrap text button, creating printable documents with set print area, selecting special types of cells, and etc.
After learning key functions of Excel, you’ll go on to financial functions. There is a special section about Excel Pivot Tables. You will know how to create and apply them. The course includes case studies. First of all, you will learn how to build a P&L in Excel from the very beginning. Secondly, you will be taught to build an FMCG model. Step-by-step explanations will be provided for you. Fundamentals of financial modeling are explained in detail in the special part of the course. You will be given forecasting guidelines, information about worst and best practices, and other related knowledge. 33 lectures are combined under the task to build a discounted cash flow model in Excel.
After the course, you will be good at:
- Building Financial Models
- Understanding company valuation mechanics
- Working in Excel at a high professional level
Without any doubt, you are more interested in practical experience than just theoretical information. The creators of the course understand this thus you will be provided with real practical tasks and experience. Take this informative and practical course! You won’t regret!
Prepaway's The Complete Financial Modeling and Valuation Course video training course for passing certification exams is the only solution which you need.
Pass Finance Courses The Complete Financial Modeling and Valuation Course Exam in First Attempt Guaranteed!
Get 100% Latest Exam Questions, Accurate & Verified Answers As Seen in the Actual Exam!
30 Days Free Updates, Instant Download!
Student Feedback
Can View Online Video Courses
Please fill out your email address below in order to view Online Courses.
Registration is Free and Easy, You Simply need to provide an email address.
- Trusted By 1.2M IT Certification Candidates Every Month
- Hundreds Hours of Videos
- Instant download After Registration
A confirmation link will be sent to this email address to verify your login.
Please Log In to view Online Course
Registration is free and easy - just provide your E-mail address.
Click Here to Register