Excl

10/14/2017 Beginner to Pro in Excel: Financial Modeling and Valuation | Udemy

(/)

Beginner to Pro in Excel: Financial Modeling and Valuation

Continue to Lecture 12
Rate This Course
14 of 165 items complete Reset progress

Search
Current Section All Sections All Resources
Section: 1 4/4
Beginner to Pro in Excel: Financial Modeling and Valuation - Welcome!
Section: 2 10 / 15
Introduction to Excel
5. Introduction to Excel - Welcome Lecture
6. Overview of Excel
02 6 Overview of Excel Exercise & Text.xlsx

02 6 Overview of Excel Solved.xlsx
Quiz 1: Overview of Excel
7. Basic Manipulations with Rows & Columns
02 7 Basic Manipulations Exercise Text.xlsx

02 7 Basic Manipulations Solved.xlsx
Quiz 2: Rows & Columns
8. The Excel Ribbon
02 8 The Ribbon Exercise & Text.xlsx

02-8-The-Ribbon-Solved.xlsx
9. Data Entry in Excel
02 9 Data Entry Exercise Text.xlsx

02 9 Data Entry Solved.xlsx
10. Introduction to Formatting
We use cookies to Formatting

give - Unsolved.xlsx
you the best online experience. By using our website, you agree to our use of cookies in accordance with our cookie policy. Learn more here
(/terms/privacy/). Formatting - Solved.xlsx
02 10 Formatting Exercise Text.xlsx OK

Show more (1)
https://www.udemy.com/beginner-to-pro-in-excel-financial-modeling-and-valuation/learn/v4/content 1/14
11. Introduction to Excel Formulas
Formulas Unsolved.xlsx
Formulas - Solved.xlsx
02 11 Formulas Exercise Text.xlsx
Show more (1)
Quiz 3: Introduction to Excel Formulas
12. Introduction to Excel Functions
Functions Unsolved.xlsx
Functions - Solved.xlsx
02 12 Functions Exercise & Text.xlsx
Show more (1)
13. Cut, Copy & Paste
02 13 Copy Cut Paste Exercise Text.xlsx

02 13 Copy Cut Paste Solved.xlsx
Quiz 4: Cut, Copy & Paste
14. Paste Special
02 14 Paste Special Exercise & Text.xlsx

02 14 Paste Special Solved.xlsx
15. Basic operations in Excel - 38 pages
Introduction to Excel's basic features.pdf
Section: 3 0 / 26
Useful tips and tools for your work in Excel
16. Excel Best Practices - Welcome Lecture
17. Initial formatting of an Excel sheet in order to render it professional
Useful Tips & Tools PDF Version

Formatting a worksheet Unsolved.xlsx
Formatting a worksheet - Solved.xlsx
Show more (2)
18. Fast scrolling through Excel sheets

Useful tips and tools - Excel le.xlsx
2. Fast Scrolling - Solved.xlsx
Show more (2)
Quiz 5: Fast scrolling through Excel sheets
19. Introduction to xing of cell references

We use cookies to give you the best online experience. By using our website, you agree to our use of cookies in accordance with our cookie policy. Learn more here
(/terms/privacy/).
Fixing references Unsolved.xlsx OK
Fixing references - Solved.xlsx
g
Show more (2)
Quiz 6: Introduction to xing of cell references
20. Using the Alt plus Enter combination

Alt + Enter Unsolved.xlsx
Alt + Enter - Solved.xlsx
Show more (2)
21. Learn how to organize your data with Text to Columns

Text to columns Unsolved.xlsx
Text to columns - Solved.xlsx
Show more (2)
Quiz 7: Learn how to organize your data with Text to Columns
22. Learn how to Use the Wrap Text Button

Wrap text Unsolved.xlsx
Wrap text - Solved.xlsx
Show more (2)
23. Create easily printable documents in Excel by using Set Print Area

Set Print Area Unsolved.xlsx
Set Print Area - Solved.xlsx
24. Find and select special types of cells with Select Special (F5)

Select Special.xlsx
03 24 Select Special (F5) Exercise & Text.xlsx
Show more (1)
Quiz 8: Select Special
25. Learn how to assign dynamic names within a Financial Model

Dynamic Naming Unsolved.xlsx
Dynamic Naming - Solved.xlsx
Show more (2)
Quiz 9: Assigning dynamic names
26. De ne a named range in Excel

Naming ranges Unsolved.xlsx
Naming ranges - Solved.xlsx
Show more (2)
(/terms/privacy/).
27. Assign custom formats to speci c cells within a Financial Model (ex. Multiples)
OK
03 27 Assigning Custom Formats Exercise & Text.xlsx
03 27 Assigning Custom Formats Solved.xlsx
28. Macros are a great timesaver! Here's why!

Creating a Macro - Unsolved.xlsx
Creating a Macro - Solved.xlsx
Show more (2)
Quiz 10: Excel Macros - Quiz
29. Create a drop-down list by using Data Validation

Data Validation Unsolved.xlsx
Data Validation - Solved.xlsx
Show more (2)
30. Using Custom-sort in order to sort multiple columns within a table

Sort data Unsolved.xlsx
Sort data - Solved.xlsx
Show more (2)
31. Create a great Index page at the beginning of your models - Hyperlinks

Useful Tips And Tools Excel File
03 31 Hyperlinks Exercise & Text.xlsx
Show more (1)
32. Fix the top row of your table with Freeze Panes

Freeze Panes Unsolved.xlsx
Freeze Panes - Solved.xlsx
33. Filter by color - an excellent tool
Exercise_Filter by Color.xlsx
Solution_Filter by Color.xlsx
34. Working with conditional formatting
Exercise_Conditional Formatting.xlsx
Solution_Conditional Formatting.xlsx
Quiz 11: Useful tips and tools for your work in Excel - Quiz
Section: 4 0/2
Keyboard shortcuts in Excel
35. Keyboard Shortcuts Save LOTS of time in Excel

(/terms/privacy/). 36. Keyboard shortcuts in Excel
OK
Beginner to Pro in Excel - Shortcuts.pdf
Beginner to Pro in Excel - Shortcuts for MAC.pdf
Section: 5 0 / 22
Excel's key functions and functionalities made easy
37. Excel's Key Functions - Welcome Lecture
38. Key Functions in Excel: If
Excel Functions
If Unsolved.xlsx
If - Solved.xlsx
39. Key Excel Functions: Sum, Sumif and Sumifs
Key Functions In Excel

Sum, Sumif, Sumifs - Unsolved.xlsx
Sum, Sumif, Sumifs Solved.xlsx
Show more (2)
40. Key Excel Functions: Count, Counta, Countif, Countifs

Count, Countif, Countifs Unsolved.xlsx
Count, Countif, Countifs - Solved.xlsx
Show more (2)
41. Key Excel Functions: Average and Averageif
Average, Averageif Unsolved.xlsx

Average, Averageif - Solved.xlsx
05 39 Average, AverageIF Exercise & Text.xlsx
Show more (1)
Quiz 12: Key Excel Functions: Average and Averageif
42. Elaborate text e ciently: Left, Right, Mid, Upper, Lower,Proper, Concatenate

Text Functions - Unsolved.xlsx
Text Functions - Solved.xlsx
Show more (2)
Quiz 13: Elaborate text e ciently: Left, Right, Mid, Upper, Lower,Proper, Concatenate
43. Find the minimum or maximum value in a range of cells in Excel
Max, min - Unsolved.xlsx

Max, min Solved.xlsx
05 41 MIN MAX Exercise & Text.xlsx
Show more (1)
44. Include Round in your Financial Models
Excel Functions
We use cookies to 05you
give 42 the
Round
best Exercise & Text.xlsx
online experience. By using our website, you agree to our use of cookies in accordance with our cookie policy. Learn more here
(/terms/privacy/). Show more (1)
OK
45 Learn how to transfer data e ciently in Excel: Vlookup and Hlookup
45. Learn how to transfer data e ciently in Excel: Vlookup and Hlookup

Vlookup, Hlookup - Unsolved.xlsx
Vlookup, Hlookup Solved.xlsx
Show more (2)
46. Index, Match and their combination - the perfect substitute of Vlookup

Index & Match - Unsolved.xlsx
Index & Match Solved.xlsx
Show more (4)
47. A great Excel technique: Index, Match, Match
Exercise_Index, Match, Match.xlsx

Solution_Index, Match, Match.xlsx
Quiz 14: Index, Match and their combination - the perfect substitute of Vlookup
48. Using Excel's Iferror function to trap spreadsheet errors

Iferror.xlsx
Iferror Unsolved.xlsx
Show more (2)
49. Learn how to render your models exible with Choose

Choose Unsolved.xlsx
Choose - Solved.xlsx
Show more (2)
50. Use Goal Seek in order to nd the result that you are looking for

Goal Seek Unsolved.xlsx
Goal Seek - Solved.xlsx
Show more (2)
Quiz 15: Use Goal Seek in order to nd the result that you are looking for
51. Include sensitivity analysis in your models through Data Tables

Data Tables Unsolved.xlsx
Data Tables - Solved.xlsx
Show more (2)
Quiz 16: Include sensitivity analysis in your models through Data Tables
52. Excel's dynamic and interactive tables: Pivot tables
Excel Functions
Excel functions.xlsx
Show more (2)
(/terms/privacy/).
Quiz 17: Excel's key functions and functionalities made easyOK
Section: 6 0/2
Update! 15 December - Exercise
53. Exercise - Excel's "Sumifs" function - unsolved
Exercise Sumifs Without Solutions
54. Exercise - Excel's "Sumifs" function - explained & solved
Exercise Sumifs With Solutions
Section: 7 0/4
Financial functions in Excel
55. Future and present values in Excel
05 12 FV & PV.xlsx
56. Calculating the rate of return of an investment with the IRR function
05 14 IRR.xlsx
57. Calculating a complete loan schedule in Excel
05 15 PMT.xlsx
58. Date functions in Excel
05 16 Date Functions.xlsx
Section: 8 0/6
Microsoft Excel's Pivot Tables in Depth
59. Introduction to Pivot Tables & Their Application
60. Creating Pivot Tables is easy!
2. Creating a Pivot Table.xlsx
61. Give Your Excel Pivot Tables a Makeover
3. Formatting a Pivot Table.xlsx
62. Modifying and Pivoting Fields In Order to Obtain the Pivot Table that You Need
4. Working with Pivot Tables.xlsx
63. Learn More About GetPivotData - A Very Important Excel Function
5. GetPivotData.xlsx
(/terms/privacy/).
64. An Introduction to Slicers - The Moden Day Pivot Table Filters
OK
6 Slicers xlsx
6. Slicers.xlsx
Database - Pivot & Slicers.xlsm
Section: 9 0 / 23
Case Study - Building a Complete P&L from scratch in Excel
65. Case Study - Build a P&L From Scratch - Welcome Lecture
66. Introduction to the Case Study
67. Understand your data source before you start working on It
68. Order the source worksheets
4. Order a worksheet - Unsolved.xlsx

4. Order a worksheet - Solved.xlsm
69. Create a code: the best way to organize your data and work e ciently with It
5. Creating a code - Solved.xlsx

5. Creating a code - Unsolved.xlsm
70. Learn how to create a Database
6. Creating a database - Solved.xlsx

6. Creating a database - Unsolved.xlsx
71. Use Vlookup in order to ll the Database sheet
7 Vlookup
7. Vlookup - Solved.xlsx
7. Vlookup - Unsolved.xlsx
72. 50% Completed!
73. Use Sumif in order to complete the Database sheet
8. Sumif - Solved.xlsx
8. Sumif - Unsolved.xlsx
74. Use Index & Match as a substitute of Vlookup
9. Index & Match - Solved.xlsx

9. Index & Match - Unsolved.xlsx
75. Mapping of the rows in the Database sheet
10. Mapping - Solved.xlsx

10. Mapping - Unsolved.xlsx
76. Building the structure of the P&L sheet
11 Building A P&L
11. Building a P&L - Solved.xlsx
We use cookies
to77.
give Formatting
you the best online experience.
sets You By using
apart from our website, you
the competition in agree
Excel to
- Aour use of cookies
Practical Examplein accordance with our cookie policy. Learn more here
(/terms/privacy/).
OK
12. Formatting the P&L - Unsolved.xlsx
12 F tti th P&L h t S l d l
12. Formatting the P&L sheet - Solved.xlsx
78. Populate the P&L sheet with Sumif
13. Populating the P&L sheet - Solved.xlsm

13. Populating the P&L sheet - Unsolved.xlsx
79. Learn how to nd mistakes with Countif
14. Countif - Solved.xlsx

14. Countif - Unsolved.xlsm
80. Calculating year-on-year percentage variations the proper way
15. Adding % variations - Solved.xlsx

15. Adding % variations - Unsolved.xlsx
81. Create professional and good-looking charts - Introduction
82. Build a Column Stacked Chart with a secondary line axis in Excel
Case Study Building A P&L From Scratch Complete

Column Stacked Chart - Solved.xlsm
Column Stacked Chart - Unsolved.xlsm
83. Learn how to build e ective Doughnut Charts in Excel
Doughnut Chart - Solved.xlsm

Doughnut Chart - Unsolved.xlsm
84. Learn how to build an Area Chart in Excel
Area Chart - Solved.xlsm

Area Chart - Unsolved.xlsm
85. Learn how to create Bridge Charts
Case Study Building A P&L From Scratch Complete

Bridge Chart - Solved.xlsm
Bridge Chart Unsolved.xlsm
Quiz 18: Case Study - Building a Complete P&L from scratch in Excel
86. Course Challenge - Apply Your Skills in Practice!
1. Course Challenge.xlsx
1.SOULUTIONS-Course-Challenge.xlsx
Section: 10 0 / 11
Case Study - Building an FMCG Model from Scratch
87. Introduction to the Case Study
0. Exercise - Build an FMCG Model_before.xlsx
88. Preliminary mapping of the data extraction
(/terms/privacy/).
OK
1. Exercise - Build an FMCG Model_Mapping.xlsx
89. Working with an SAP data extraction
90. Creating an output structure of the FMCG model
2. Exercise - Build an FMCG Model_Structure.xlsx
91. Improving the layout and appearance of the FMCG report
2. Exercise - Build an FMCG Model_Layout.xlsx
92. Inserting formulas and automating calculations
4. Exercise - Build an FMCG Model_Adding Calculations.xlsx
93. Creating a Master Pivot Table: The main data source for the FMCG report
5. Exercise - Build an FMCG Model_Creating a Pivot Table.xlsx
94. GetPivotData is great! Extracting data from the Master Pivot Table
6. Exercise - Build an FMCG Model_GETPIVOTDATA.xlsx
95. Combining Slicers and GetPivotData: The key to our success
8. Exercise - Build an FMCG Model_Inserting Slicers.xlsx
96. Getting fancy with Excel slicers - Good-looking Excel slicers
10. Exercise - Build an FMCG Model_Complete.xlsx
97. This is how the report can be used in practice by high-level executives
10. Exercise - Build an FMCG Model_Complete.xlsx
Section: 11 0 / 15
Financial Modeling Fundamentals
98. Financial Modeling Basics - Welcome Lecture
99. What is a Financial model?
100. Why use Financial models?
101. Financial modeling: Worst Practices - Things you should avoid
102. Financial modeling: Best practices
103. Financial modeling: The types of models that are built in practice
Quiz 19: Financial Modeling - Quiz
104. Financial modeling: The right level of detail in a model

(/terms/privacy/).
105. Financial modeling: Forecasting guidelines
OK
Quiz 20: Forecasting nancials - Quiz
106. Building a complete model - Important considerations
107. Modeling the Income statement
108. Modeling the Balance sheet - Part 1
109. Modeling the Balance sheet - Part 2
Quiz 21: Building a nancial model - Quiz
Section: 12 0/1
Introduction to Company Valuation
110. The core theory behind Company Valuation
Company valuation.pdf
Section: 13 0/1
Introduction to Mergers & Acquisitions
111. Introduction to Mergers & Acquisitions
Introduction to M&A.pdf
Section: 14 0 / 33
Learn how to build a Discounted Cash Flow model in Excel
112. Valuation Case Study - Welcome Lecture
113. Introduction to the DCF exercise
114. The various stages of a complete DCF Valuation
Valuation exercise.pdf
115. Description of the structure of the DCF model
3. Beginning of exercise.xlsm
DCF Model structure.pdf
116. A glimpse at the company we are valuing - Cheeseco
Beginning Of Exercise
117. Modeling the top line
5. Modeling revenues - Solved.xlsm

5. Modeling revenues - Unsolved.xlsm
(/terms/privacy/).
118. Introducing scenarios to the model with Choose
OK
6. Choose - Solved.xlsm
6. Choose Unsolved.xlsm
119. Modeling other items: Other revenues and Cogs
7. Modeling Cogs - Solved.xlsm

7. Modeling Cogs Unsolved.xlsm
120. Modeling other items: Operating expenses and D&A
8. Opex and D&A - Solved.xlsm

8. Opex and D&A - Unsolved.xlsm
121. Modeling other items: Interest expenses, Extraordinary items and Taxes
9. Interest expenses, Extraordinary items and Taxes - Solved.xlsm

9. Interest expenses, Extraordinary items and Taxes Unsolved.xlsm
122. Forecasting Balance Sheet items
10. Project BS items - Solved.xlsm

10. Project BS items Unsolved.xlsm
123. An introduction to the "Days" methodology
Working Capital Days.pptx
124. Calculation of DSO, DPO and DOI for the historical period
12. Calculating DSO, DPO and DIO - Solved.xlsm

12. Calculating DSO, DPO and DIO - Unsolved.xlsm
125. Forecasting DSO, DPO and DOI
13. Forecasting DSO, DPO and DIO - Solved.xlsm

13. Forecasting DSO, DPO and DIO - Unsolved.xlsm
126. Forecasting Property, Plant & Equipment, Other assets and Other liabilities
14. Forecasting PP&E, Other assets and Other liabilities - Solved.xlsm

14. Forecasting PP&E, Other assets and Other liabilities - Unsolved.xlsm
127. Creating an output P&L sheet
15. P&L structure - Solved.xlsm

15. P&L structure Unsolved.xlsm
128. Populating the output P&L sheet
16. Populating the P&L sheet - Solved.xlsm

16. Populating the P&L sheet Unsolved.xlsm
129. Populating the output BS sheet
17. Populating the Balance sheet Unsolved.xlsm

17. Populating the BS sheet - Solved.xlsm

(/terms/privacy/).
130. Completing the output BS sheet for the historical period
OK
18. Completing the BS items - Solved.xlsm
18. Completing the BS items Unsolved.xlsm
131. Creating a structure for the calculation of Unlevered Free Cash Flows
19. Building a Cash Flow Format Solved.xlsm

19. Building a Cash Flow Format Unsolved.xlsm
132. Bridging Unlevered Free Cash Flow to Net Cash Flow
20. From UFCF to Net Cash Flow Solved.xlsm

20. From UFCF to Net Cash Flow - Unsolved.xlsm
133. Calculating Unlevered Free Cash Flow
21. Calculating UFCF - Solved.xlsm

21. Calculating UFCF - Unsolved.xlsm
134. Calculating Net Cash Flow
Cash Flow Classi cation By Activities

22. From UFCF to Net Cash Flow - Solved.xlsm
22. From UFCF to Net Cash Flow - Unsolved.xlsm
135. Obtaining the rest of the Cash Flows through Find and Replace
23. Use Find and Replace - Solved.xlsm

23. Use Find and Replace - Unsolved.xlsm
136. Introducing Weighted Average Cost of Capital and Perpetuity Growth
24. Introducing WACC and g - Solved.xlsm

24. Introducing WACC and g - Unsolved.xlsm
137. Discounting Unlevered Free Cash Flows in order to obtain their Present Value
25. Calculating PV of Cash Flows - Solved.xlsm

25. Calculating PV of Cash Flows - Unsolved.xlsm
138. Calculating Continuing Value and Enterprise Value of the business
26. Calculating CV of the business - Solved.xlsm

26. Calculating CV of the business - Unsolved.xlsm
139. Calculating Equity Value
27. Calculating Equity Value - Solved.xlsm

27. Calculating Equity Value - Unsolved.xlsm
140. Sensitivity analysis for WACC and perpetuity growth
Sensitivity Analysis
28. Sensitivity analysis - Solved.xlsm
28. Sensitivity analysis - Unsolved.xlsm
141. A possible application of Goal Seek
We use cookies to 29.you

give Goal
the seek - Solved.xlsm
best online experience. By using our website, you agree to our use of cookies in accordance with our cookie policy. Learn more here
(/terms/privacy/). 29. Goal Seek - Unsolved.xlsm
OK
142 Using charts in order to summarize the results of the DCF Model
142. Using charts in order to summarize the results of the DCF Model
30. Charts - Solved.xlsm

30. Charts Unsolved.xlsm
143. You Made It!
144. Congratulations!!
English

(/)
Copyright @ 2017 Udemy, Inc.
Terms (/terms/) Privacy Policy and Cookie Policy (/terms/privacy/) Intellectual Property (/terms/copyright/)
(/terms/privacy/).
OK

Excl

Uploaded by

Copyright:

Available Formats

Excl

Uploaded by

Document Information

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

Excl

Uploaded by

Copyright:

Available Formats

10/14/2017 Beginner to Pro in Excel: Financial Modeling and Valuation | Udemy

Beginner to Pro in Excel: Financial Modeling and Valuation

Rate This Course

14 of 165 items complete Reset progress

Current Section All Sections All Resources

5. Introduction to Excel - Welcome Lecture

02 6 Overview of Excel Exercise & Text.xlsx

Quiz 1: Overview of Excel

7. Basic Manipulations with Rows & Columns

02 7 Basic Manipulations Exercise Text.xlsx

Quiz 2: Rows & Columns

8. The Excel Ribbon

02 8 The Ribbon Exercise & Text.xlsx

9. Data Entry in Excel

02 9 Data Entry Exercise Text.xlsx

10. Introduction to Formatting

We use cookies to Formatting

02 10 Formatting Exercise Text.xlsx OK

11. Introduction to Excel Formulas

Quiz 3: Introduction to Excel Formulas

12. Introduction to Excel Functions

13. Cut, Copy & Paste

02 13 Copy Cut Paste Exercise Text.xlsx

Quiz 4: Cut, Copy & Paste

14. Paste Special

02 14 Paste Special Exercise & Text.xlsx

15. Basic operations in Excel - 38 pages

Introduction to Excel's basic features.pdf

16. Excel Best Practices - Welcome Lecture

17. Initial formatting of an Excel sheet in order to render it professional

Useful Tips & Tools PDF Version

18. Fast scrolling through Excel sheets

Useful Tips & Tools PDF Version

Quiz 5: Fast scrolling through Excel sheets

19. Introduction to xing of cell references

Quiz 6: Introduction to xing of cell references

20. Using the Alt plus Enter combination

Useful Tips & Tools PDF Version

21. Learn how to organize your data with Text to Columns

Useful Tips & Tools PDF Version

Quiz 7: Learn how to organize your data with Text to Columns

22. Learn how to Use the Wrap Text Button

Useful Tips & Tools PDF Version

Useful Tips & Tools PDF Version

Useful Tips & Tools PDF Version

Quiz 8: Select Special

25. Learn how to assign dynamic names within a Financial Model

Useful Tips & Tools PDF Version

Quiz 9: Assigning dynamic names

26. De ne a named range in Excel

Useful Tips & Tools PDF Version

28. Macros are a great timesaver! Here's why!

Useful Tips & Tools PDF Version

Quiz 10: Excel Macros - Quiz

29. Create a drop-down list by using Data Validation

Useful Tips & Tools PDF Version

30. Using Custom-sort in order to sort multiple columns within a table

Useful Tips & Tools PDF Version

Useful Tips & Tools PDF Version

Useful Tips & Tools PDF Version