FreeTutorials Us beginner-to-pro-in-excel-financial-modeling-and-valuation

1. 01 Beginner to Pro in Excel Financial Modeling and Valuation - Welcome/001 What does the course cover.mp48.94MB
2. 01 Beginner to Pro in Excel Financial Modeling and Valuation - Welcome/004 The best way to take this course.mp47.82MB
3. 02 Introduction to Excel/005 Introduction to Excel - Welcome Lecture.mp41.99MB
4. 02 Introduction to Excel/006 Overview of Excel.mp413.95MB
5. 02 Introduction to Excel/007 Basic Manipulations with Rows Columns.mp46.9MB
6. 02 Introduction to Excel/008 The Excel Ribbon.mp48.8MB
7. 02 Introduction to Excel/009 Data Entry in Excel.mp410.39MB
8. 02 Introduction to Excel/010 Introduction to Formatting.mp424.75MB
9. 02 Introduction to Excel/011 Introduction to Excel Formulas.mp48.69MB
10. 02 Introduction to Excel/012 Introduction to Excel Functions.mp412.05MB
11. 02 Introduction to Excel/013 Cut Copy Paste.mp47.56MB
12. 02 Introduction to Excel/014 Paste Special.mp46.69MB
13. 03 Useful tips and tools for your work in Excel/016 Excel Best Practices - Welcome Lecture.mp42.13MB
14. 03 Useful tips and tools for your work in Excel/017 Initial formatting of an Excel sheet in order to render it professional.mp47.98MB
15. 03 Useful tips and tools for your work in Excel/018 Fast scrolling through Excel sheets.mp422.16MB
16. 03 Useful tips and tools for your work in Excel/019 Introduction to fixing of cell references.mp420.37MB
17. 03 Useful tips and tools for your work in Excel/020 Using the Alt plus Enter combination.mp43.33MB
18. 03 Useful tips and tools for your work in Excel/021 Learn how to organize your data with Text to Columns.mp412.53MB
19. 03 Useful tips and tools for your work in Excel/022 Learn how to Use the Wrap Text Button.mp42.14MB
20. 03 Useful tips and tools for your work in Excel/023 Create easily printable documents in Excel by using Set Print Area.mp44.73MB
21. 03 Useful tips and tools for your work in Excel/024 Find and select special types of cells with Select Special F5.mp49.78MB
22. 03 Useful tips and tools for your work in Excel/025 Learn how to assign dynamic names within a Financial Model.mp47.31MB
23. 03 Useful tips and tools for your work in Excel/026 Define a named range in Excel.mp45.42MB
24. 03 Useful tips and tools for your work in Excel/027 Assign custom formats to specific cells within a Financial Model ex. Multiples.mp45.41MB
25. 03 Useful tips and tools for your work in Excel/028 Macros are a great timesaver Heres why.mp411.1MB
26. 03 Useful tips and tools for your work in Excel/029 Create a drop-down list by using Data Validation.mp410.58MB
27. 03 Useful tips and tools for your work in Excel/030 Using Custom-sort in order to sort multiple columns within a table.mp49.14MB
28. 03 Useful tips and tools for your work in Excel/031 Create a great Index page at the beginning of your models - Hyperlinks.mp45.35MB
29. 03 Useful tips and tools for your work in Excel/032 Fix the top row of your table with Freeze Panes.mp417.67MB
30. 03 Useful tips and tools for your work in Excel/033 Filter by color - an excellent tool.mp49.87MB
31. 03 Useful tips and tools for your work in Excel/034 Working with conditional formatting.mp415.08MB
32. 04 Keyboard shortcuts in Excel/035 Keyboard Shortcuts Save LOTS of time in Excel.mp430.43MB
33. 05 Excels key functions and functionalities made easy/037 Excels Key Functions - Welcome Lecture.mp42.31MB
34. 05 Excels key functions and functionalities made easy/039 Key Excel Functions Sum Sumif and Sumifs.mp419.32MB
35. 05 Excels key functions and functionalities made easy/040 Key Excel Functions Count Counta Countif Countifs.mp416.98MB
36. 05 Excels key functions and functionalities made easy/041 Key Excel Functions Average and Averageif.mp47.85MB
37. 05 Excels key functions and functionalities made easy/042 Elaborate text efficiently Left Right Mid Upper LowerProper Concatenate.mp416.79MB
38. 05 Excels key functions and functionalities made easy/043 Find the minimum or maximum value in a range of cells in Excel.mp45.91MB
39. 05 Excels key functions and functionalities made easy/044 Include Round in your Financial Models.mp43.12MB
40. 05 Excels key functions and functionalities made easy/045 Learn how to transfer data efficiently in Excel Vlookup and Hlookup.mp434.59MB
41. 05 Excels key functions and functionalities made easy/046 Index Match and their combination - the perfect substitute of Vlookup.mp438.95MB
42. 05 Excels key functions and functionalities made easy/047 A great Excel technique Index Match Match.mp411.76MB
43. 05 Excels key functions and functionalities made easy/048 Using Excels Iferror function to trap spreadsheet errors.mp47.51MB
44. 05 Excels key functions and functionalities made easy/049 Learn how to render your models flexible with Choose.mp48.98MB
45. 05 Excels key functions and functionalities made easy/050 Use Goal Seek in order to find the result that you are looking for.mp47.85MB
46. 05 Excels key functions and functionalities made easy/051 Include sensitivity analysis in your models through Data Tables.mp414.28MB
47. 05 Excels key functions and functionalities made easy/052 Excels dynamic and interactive tables Pivot tables.mp416.58MB
48. 06 Update 15 December - Exercise/054 Exercise - Excels Sumifs function - explained solved.mp435.31MB
49. 07 Microsoft Excels Pivot Tables in Depth/055 Introduction to Pivot Tables Their Application.mp46MB
50. 07 Microsoft Excels Pivot Tables in Depth/056 Creating Pivot Tables is easy.mp419.37MB
51. 07 Microsoft Excels Pivot Tables in Depth/057 Give Your Excel Pivot Tables a Makeover.mp411.27MB
52. 07 Microsoft Excels Pivot Tables in Depth/058 Modifying and Pivoting Fields In Order to Obtain the Pivot Table that You Need.mp423MB
53. 07 Microsoft Excels Pivot Tables in Depth/059 Learn More About GetPivotData - A Very Important Excel Function.mp418.06MB
54. 07 Microsoft Excels Pivot Tables in Depth/060 An Introduction to Slicers - The Moden Day Pivot Table Filters.mp422.16MB
55. 08 Case Study - Building a Complete PL from scratch in Excel/061 Case Study - Build a PL From Scratch - Welcome Lecture.mp43.13MB
56. 08 Case Study - Building a Complete PL from scratch in Excel/062 Introduction to the Case Study.mp46.8MB
57. 08 Case Study - Building a Complete PL from scratch in Excel/063 Understand your data source before you start working on It.mp421.24MB
58. 08 Case Study - Building a Complete PL from scratch in Excel/064 Order the source worksheets.mp418.36MB
59. 08 Case Study - Building a Complete PL from scratch in Excel/065 Create a code the best way to organize your data and work efficiently with It.mp418.7MB
60. 08 Case Study - Building a Complete PL from scratch in Excel/066 Learn how to create a Database.mp418.11MB
61. 08 Case Study - Building a Complete PL from scratch in Excel/067 Use Vlookup in order to fill the Database sheet.mp448.85MB
62. 08 Case Study - Building a Complete PL from scratch in Excel/068 50 Completed.mp44.3MB
63. 08 Case Study - Building a Complete PL from scratch in Excel/069 Use Sumif in order to complete the Database sheet.mp444.48MB
64. 08 Case Study - Building a Complete PL from scratch in Excel/070 Use Index Match as a substitute of Vlookup.mp442.14MB
65. 08 Case Study - Building a Complete PL from scratch in Excel/071 Mapping of the rows in the Database sheet.mp429.75MB
66. 08 Case Study - Building a Complete PL from scratch in Excel/072 Building the structure of the PL sheet.mp410.45MB
67. 08 Case Study - Building a Complete PL from scratch in Excel/073 Formatting sets You apart from the competition in Excel - A Practical Example.mp415.24MB
68. 08 Case Study - Building a Complete PL from scratch in Excel/074 Populate the PL sheet with Sumif.mp418.78MB
69. 08 Case Study - Building a Complete PL from scratch in Excel/075 Learn how to find mistakes with Countif.mp423.74MB
70. 08 Case Study - Building a Complete PL from scratch in Excel/076 Calculating year-on-year percentage variations the proper way.mp420.75MB
71. 08 Case Study - Building a Complete PL from scratch in Excel/077 Create professional and good-looking charts - Introduction.mp43.6MB
72. 08 Case Study - Building a Complete PL from scratch in Excel/078 Build a Column Stacked Chart with a secondary line axis in Excel.mp432.72MB
73. 08 Case Study - Building a Complete PL from scratch in Excel/079 Learn how to build effective Doughnut Charts in Excel.mp420.77MB
74. 08 Case Study - Building a Complete PL from scratch in Excel/080 Learn how to build an Area Chart in Excel.mp422.89MB
75. 08 Case Study - Building a Complete PL from scratch in Excel/081 Learn how to create Bridge Charts.mp456.48MB
76. 08 Case Study - Building a Complete PL from scratch in Excel/082 Course Challenge - Apply Your Skills in Practice.mp47.91MB
77. 09 Case Study - Building an FMCG Model from Scratch/083 Introduction to the Case Study.mp412.05MB
78. 09 Case Study - Building an FMCG Model from Scratch/084 Preliminary mapping of the data extraction.mp422.6MB
79. 09 Case Study - Building an FMCG Model from Scratch/085 Working with an SAP data extraction.mp421.95MB
80. 09 Case Study - Building an FMCG Model from Scratch/086 Creating an output structure of the FMCG model.mp411.65MB
81. 09 Case Study - Building an FMCG Model from Scratch/087 Improving the layout and appearance of the FMCG report.mp413.5MB
82. 09 Case Study - Building an FMCG Model from Scratch/088 Inserting formulas and automating calculations.mp48.83MB
83. 09 Case Study - Building an FMCG Model from Scratch/089 Creating a Master Pivot Table The main data source for the FMCG report.mp413.82MB
84. 09 Case Study - Building an FMCG Model from Scratch/090 GetPivotData is great Extracting data from the Master Pivot Table.mp431.04MB
85. 09 Case Study - Building an FMCG Model from Scratch/091 Combining Slicers and GetPivotData The key to our success.mp417.83MB
86. 09 Case Study - Building an FMCG Model from Scratch/092 Getting fancy with Excel slicers - Good-looking Excel slicers.mp417.11MB
87. 09 Case Study - Building an FMCG Model from Scratch/093 This is how the report can be used in practice by high-level executives.mp419.8MB
88. 10 Financial Modeling Fundamentals/094 Financial Modeling Basics - Welcome Lecture.mp42.09MB
89. 10 Financial Modeling Fundamentals/095 What is a Financial model.mp45.48MB
90. 10 Financial Modeling Fundamentals/096 Why use Financial models.mp410.03MB
91. 10 Financial Modeling Fundamentals/097 Financial modeling Worst Practices - Things you should avoid.mp419.91MB
92. 10 Financial Modeling Fundamentals/098 Financial modeling Best practices.mp417.22MB
93. 10 Financial Modeling Fundamentals/099 Financial modeling The types of models that are built in practice.mp414.26MB
94. 10 Financial Modeling Fundamentals/100 Financial modeling The right level of detail in a model.mp47.29MB
95. 10 Financial Modeling Fundamentals/101 Financial modeling Forecasting guidelines.mp47.11MB
96. 10 Financial Modeling Fundamentals/102 Building a complete model - Important considerations.mp48.44MB
97. 10 Financial Modeling Fundamentals/103 Modeling the Income statement.mp413.33MB
98. 10 Financial Modeling Fundamentals/104 Modeling the Balance sheet - Part 1.mp46.14MB
99. 10 Financial Modeling Fundamentals/105 Modeling the Balance sheet - Part 2.mp410.6MB
100. 13 Learn how to build a Discounted Cash Flow model in Excel/108 Valuation Case Study - Welcome Lecture.mp41.78MB
101. 13 Learn how to build a Discounted Cash Flow model in Excel/109 Introduction to the DCF exercise.mp411.61MB
102. 13 Learn how to build a Discounted Cash Flow model in Excel/110 The various stages of a complete DCF Valuation.mp422.89MB
103. 13 Learn how to build a Discounted Cash Flow model in Excel/111 Description of the structure of the DCF model.mp412.53MB
104. 13 Learn how to build a Discounted Cash Flow model in Excel/112 A glimpse at the company we are valuing - Cheeseco.mp44.5MB
105. 13 Learn how to build a Discounted Cash Flow model in Excel/113 Modeling the top line.mp414.26MB
106. 13 Learn how to build a Discounted Cash Flow model in Excel/114 Introducing scenarios to the model with Choose.mp49.64MB
107. 13 Learn how to build a Discounted Cash Flow model in Excel/115 Modeling other items Other revenues and Cogs.mp427.14MB
108. 13 Learn how to build a Discounted Cash Flow model in Excel/116 Modeling other items Operating expenses and DA.mp419.58MB
109. 13 Learn how to build a Discounted Cash Flow model in Excel/117 Modeling other items Interest expenses Extraordinary items and Taxes.mp418.85MB
110. 13 Learn how to build a Discounted Cash Flow model in Excel/118 Forecasting Balance Sheet items.mp42.57MB
111. 13 Learn how to build a Discounted Cash Flow model in Excel/119 An introduction to the Days methodology.mp45.63MB
112. 13 Learn how to build a Discounted Cash Flow model in Excel/120 Calculation of DSO DPO and DOI for the historical period.mp48.36MB
113. 13 Learn how to build a Discounted Cash Flow model in Excel/121 Forecasting DSO DPO and DOI.mp411.99MB
114. 13 Learn how to build a Discounted Cash Flow model in Excel/122 Forecasting Property Plant Equipment Other assets and Other liabilities.mp415.99MB
115. 13 Learn how to build a Discounted Cash Flow model in Excel/123 Creating an output PL sheet.mp410.45MB
116. 13 Learn how to build a Discounted Cash Flow model in Excel/124 Populating the output PL sheet.mp418.49MB
117. 13 Learn how to build a Discounted Cash Flow model in Excel/125 Populating the output BS sheet.mp410.32MB
118. 13 Learn how to build a Discounted Cash Flow model in Excel/126 Completing the output BS sheet for the historical period.mp426MB
119. 13 Learn how to build a Discounted Cash Flow model in Excel/127 Creating a structure for the calculation of Unlevered Free Cash Flows.mp410.79MB
120. 13 Learn how to build a Discounted Cash Flow model in Excel/128 Bridging Unlevered Free Cash Flow to Net Cash Flow.mp47.64MB
121. 13 Learn how to build a Discounted Cash Flow model in Excel/129 Calculating Unlevered Free Cash Flow.mp434.24MB
122. 13 Learn how to build a Discounted Cash Flow model in Excel/130 Calculating Net Cash Flow.mp423.56MB
123. 13 Learn how to build a Discounted Cash Flow model in Excel/131 Obtaining the rest of the Cash Flows through Find and Replace.mp432.33MB
124. 13 Learn how to build a Discounted Cash Flow model in Excel/132 Introducing Weighted Average Cost of Capital and Perpetuity Growth.mp47.12MB
125. 13 Learn how to build a Discounted Cash Flow model in Excel/133 Discounting Unlevered Free Cash Flows in order to obtain their Present Value.mp410.66MB
126. 13 Learn how to build a Discounted Cash Flow model in Excel/134 Calculating Continuing Value and Enterprise Value of the business.mp49.67MB
127. 13 Learn how to build a Discounted Cash Flow model in Excel/135 Calculating Equity Value.mp48.33MB
128. 13 Learn how to build a Discounted Cash Flow model in Excel/136 Sensitivity analysis for WACC and perpetuity growth.mp428.94MB
129. 13 Learn how to build a Discounted Cash Flow model in Excel/137 A possible application of Goal Seek.mp410.61MB
130. 13 Learn how to build a Discounted Cash Flow model in Excel/138 Using charts in order to summarize the results of the DCF Model.mp425.44MB
131. 13 Learn how to build a Discounted Cash Flow model in Excel/139 You Made It.mp420.07MB
132. 13 Learn how to build a Discounted Cash Flow model in Excel/140 Congratulations.mp42.3MB