FreeAllCourse Com Udemy - Beginner to Pro in Excel Financial Modeling and Valuation

1. 1. Beginner to Pro in Excel Financial Modeling and Valuation - Welcome!/1. What does the course cover.mp432.78MB
2. 1. Beginner to Pro in Excel Financial Modeling and Valuation - Welcome!/4. The best way to take this course.mp417.62MB
3. 10. Introduction to Excel charts/1. How to insert a chart in Excel.mp422.28MB
4. 10. Introduction to Excel charts/2. Editing Excel charts.mp426.06MB
5. 10. Introduction to Excel charts/3. Excel chart formatting.mp432.75MB
6. 10. Introduction to Excel charts/4. How to create a bridge chart in Excel.mp413.66MB
7. 10. Introduction to Excel charts/5. New ways to visualize your data - Treemap charts.mp411.5MB
8. 10. Introduction to Excel charts/6. Sparklines.mp427.56MB
9. 11. P&L Case Study continued - Let's create some great-looking professional charts/1. Create professional and good-looking charts - Introduction.mp46.21MB
10. 11. P&L Case Study continued - Let's create some great-looking professional charts/2. Build a column stacked chart with a secondary line axis in Excel.mp446.38MB
11. 11. P&L Case Study continued - Let's create some great-looking professional charts/3. Learn how to build effective doughnut charts in Excel.mp438MB
12. 11. P&L Case Study continued - Let's create some great-looking professional charts/4. Learn how to build an area chart in Excel.mp428.59MB
13. 11. P&L Case Study continued - Let's create some great-looking professional charts/5. Learn how to create bridge charts.mp452.07MB
14. 11. P&L Case Study continued - Let's create some great-looking professional charts/6. Learn how to create bridge charts in Excel 2007, 2010, and 2013.mp4136.12MB
15. 11. P&L Case Study continued - Let's create some great-looking professional charts/8. Course Challenge - Apply your skills in practice!.mp47.92MB
16. 12. Case Study - Building an FMCG Model from Scratch/1. Introduction to the Case Study.mp424.07MB
17. 12. Case Study - Building an FMCG Model from Scratch/11. Combining Slicers and GETPIVOTDATA The key to our success.mp433.62MB
18. 12. Case Study - Building an FMCG Model from Scratch/12. Getting fancy with Excel slicers - Good-looking Excel slicers.mp432.42MB
19. 12. Case Study - Building an FMCG Model from Scratch/13. This is how the report can be used in practice by high-level executives.mp436.15MB
20. 12. Case Study - Building an FMCG Model from Scratch/2. Preliminary mapping of the data extraction.mp430.45MB
21. 12. Case Study - Building an FMCG Model from Scratch/3. Working with an SAP data extraction.mp437.13MB
22. 12. Case Study - Building an FMCG Model from Scratch/4. Creating an output structure of the FMCG model.mp419.7MB
23. 12. Case Study - Building an FMCG Model from Scratch/5. Improving the layout and appearance of the FMCG report.mp425.36MB
24. 12. Case Study - Building an FMCG Model from Scratch/6. Inserting formulas and automating calculations.mp416.15MB
25. 12. Case Study - Building an FMCG Model from Scratch/7. Creating a Master Pivot Table The main data source for the FMCG report.mp420.14MB
26. 12. Case Study - Building an FMCG Model from Scratch/8. GETPIVOTDATA is great! Extracting data from the Master Pivot Table.mp449.98MB
27. 12. Case Study - Building an FMCG Model from Scratch/9. A potential error with GETPIVOTDATA you might encounter and its fix.mp413.76MB
28. 13. Financial modeling fundamentals/1. Financial modeling basics - Welcome lecture.mp42.09MB
29. 13. Financial modeling fundamentals/11. Building a complete model - Important considerations.mp48.45MB
30. 13. Financial modeling fundamentals/12. Modeling the Income statement.mp413.33MB
31. 13. Financial modeling fundamentals/13. Modeling the Balance sheet - Part 1.mp46.15MB
32. 13. Financial modeling fundamentals/14. Modeling the Balance sheet - Part 2.mp410.6MB
33. 13. Financial modeling fundamentals/2. What is a financial model.mp45.48MB
34. 13. Financial modeling fundamentals/3. Why use financial models.mp410.04MB
35. 13. Financial modeling fundamentals/4. Financial modeling - worst practices - things you should avoid.mp419.92MB
36. 13. Financial modeling fundamentals/5. Financial modeling - best practices.mp417.22MB
37. 13. Financial modeling fundamentals/6. Financial modeling - The types of models that are built in practice.mp414.26MB
38. 13. Financial modeling fundamentals/8. Financial modeling The right level of detail in a model.mp47.29MB
39. 13. Financial modeling fundamentals/9. Financial modeling Forecasting guidelines.mp47.12MB
40. 16. Learn how to build a Discounted Cash Flow model in Excel/1. Valuation Case study - Welcome lecture.mp41.78MB
41. 16. Learn how to build a Discounted Cash Flow model in Excel/10. Modeling other items Interest expenses, Extraordinary items and Taxes.mp430.02MB
42. 16. Learn how to build a Discounted Cash Flow model in Excel/11. Forecasting Balance sheet items.mp44.66MB
43. 16. Learn how to build a Discounted Cash Flow model in Excel/12. An introduction to the Days methodology.mp410.08MB
44. 16. Learn how to build a Discounted Cash Flow model in Excel/13. Calculation of DSO, DPO and DOI for the historical period.mp412.11MB
45. 16. Learn how to build a Discounted Cash Flow model in Excel/14. Forecasting DSO, DPO and DOI.mp420.86MB
46. 16. Learn how to build a Discounted Cash Flow model in Excel/15. Forecasting Property, Plant & Equipment, Other assets and Other liabilities.mp422.63MB
47. 16. Learn how to build a Discounted Cash Flow model in Excel/16. Creating an output P&L sheet.mp418.81MB
48. 16. Learn how to build a Discounted Cash Flow model in Excel/17. Populating the output P&L sheet.mp425.53MB
49. 16. Learn how to build a Discounted Cash Flow model in Excel/18. Populating the output BS sheet.mp416.93MB
50. 16. Learn how to build a Discounted Cash Flow model in Excel/19. Completing the output BS sheet for the historical period.mp438.04MB
51. 16. Learn how to build a Discounted Cash Flow model in Excel/2. Introduction to the DCF exercise.mp47.88MB
52. 16. Learn how to build a Discounted Cash Flow model in Excel/20. Creating a structure for the calculation of Unlevered free cash flows.mp422.76MB
53. 16. Learn how to build a Discounted Cash Flow model in Excel/21. Bridging Unlevered free cash flow to Net cash flow.mp414.57MB
54. 16. Learn how to build a Discounted Cash Flow model in Excel/22. Calculating Unlevered free cash flow.mp459.73MB
55. 16. Learn how to build a Discounted Cash Flow model in Excel/23. Calculating Net cash flow.mp437.91MB
56. 16. Learn how to build a Discounted Cash Flow model in Excel/24. Obtaining the rest of the cash flows through Find and Replace.mp446.74MB
57. 16. Learn how to build a Discounted Cash Flow model in Excel/25. Introducing Weighted average cost of capital and Perpetuity growth.mp413.21MB
58. 16. Learn how to build a Discounted Cash Flow model in Excel/26. Discounting Unlevered free cash flows to obtain their Present value.mp420.23MB
59. 16. Learn how to build a Discounted Cash Flow model in Excel/27. Calculating Continuing value and Enterprise value of the business.mp417.73MB
60. 16. Learn how to build a Discounted Cash Flow model in Excel/28. Calculating Equity value.mp412.2MB
61. 16. Learn how to build a Discounted Cash Flow model in Excel/29. Sensitivity analysis for WACC and perpetuity growth.mp440.49MB
62. 16. Learn how to build a Discounted Cash Flow model in Excel/3. The stages of a complete DCF Valuation.mp449.25MB
63. 16. Learn how to build a Discounted Cash Flow model in Excel/30. A possible application of Goal seek.mp415.63MB
64. 16. Learn how to build a Discounted Cash Flow model in Excel/31. Using charts to summarize the results of the DCF model.mp432.89MB
65. 16. Learn how to build a Discounted Cash Flow model in Excel/32. You made it!.mp411.26MB
66. 16. Learn how to build a Discounted Cash Flow model in Excel/4. Description of the structure of the DCF model.mp418.54MB
67. 16. Learn how to build a Discounted Cash Flow model in Excel/5. A glimpse at the company we are valuing - Cheeseco.mp415.68MB
68. 16. Learn how to build a Discounted Cash Flow model in Excel/6. Modeling the top line.mp426.31MB
69. 16. Learn how to build a Discounted Cash Flow model in Excel/7. Introducing scenarios to the model with Choose.mp417.83MB
70. 16. Learn how to build a Discounted Cash Flow model in Excel/8. Modeling other items Other revenues and Cogs.mp444.56MB
71. 16. Learn how to build a Discounted Cash Flow model in Excel/9. Modeling other items Operating expenses and D&A.mp426.34MB
72. 17. Tesla valuation - Complete practical exercise/1. Organizing external inputs in a 'Drivers' sheet.mp431.01MB
73. 17. Tesla valuation - Complete practical exercise/10. Forecasting 'energy' and 'services' revenue.mp425.29MB
74. 17. Tesla valuation - Complete practical exercise/11. Calculating 'energy' and 'services' gross profit and cost of sales.mp426.81MB
75. 17. Tesla valuation - Complete practical exercise/12. Forecasting operating expenses.mp434.91MB
76. 17. Tesla valuation - Complete practical exercise/13. Building a fixed asset roll forward estimating Capex.mp456.58MB
77. 17. Tesla valuation - Complete practical exercise/14. Building a fixed asset roll forward D&A schedule.mp454.21MB
78. 17. Tesla valuation - Complete practical exercise/15. Peer comparison D&A as a percentage of revenues.mp413.61MB
79. 17. Tesla valuation - Complete practical exercise/17. Calculating DSO, DIO, DPO.mp417.51MB
80. 17. Tesla valuation - Complete practical exercise/18. Producing a clean P&L output sheet.mp48.44MB
81. 17. Tesla valuation - Complete practical exercise/19. Fill in the P&L output sheet.mp418.35MB
82. 17. Tesla valuation - Complete practical exercise/2. The input data we will work with.mp415.81MB
83. 17. Tesla valuation - Complete practical exercise/20. Calculating investments in working capital.mp419.03MB
84. 17. Tesla valuation - Complete practical exercise/21. Forecasting Unlevered free cash flow.mp455.94MB
85. 17. Tesla valuation - Complete practical exercise/22. Forecasting other assets.mp445.24MB
86. 17. Tesla valuation - Complete practical exercise/23. Forecasting other liabilities.mp421.96MB
87. 17. Tesla valuation - Complete practical exercise/24. Completing Unlevered free cash flow.mp440.89MB
88. 17. Tesla valuation - Complete practical exercise/25. Modeling Tesla's financing needs in the forecast period.mp442.36MB
89. 17. Tesla valuation - Complete practical exercise/26. Calculating Net income.mp414.81MB
90. 17. Tesla valuation - Complete practical exercise/27. Bridging Unlevered free cash flow to Net cash flow.mp450.73MB
91. 17. Tesla valuation - Complete practical exercise/28. Balancing the Balance sheet.mp413.27MB
92. 17. Tesla valuation - Complete practical exercise/29. Estimating Weighted average cost of capital (WACC).mp444.27MB
93. 17. Tesla valuation - Complete practical exercise/3. Forecasting Tesla's expected deliveries.mp4114.91MB
94. 17. Tesla valuation - Complete practical exercise/30. Performing discounted cash flow valuation (DCF).mp434.91MB
95. 17. Tesla valuation - Complete practical exercise/31. Calculating enterprise value, equity value, and price per share.mp422.55MB
96. 17. Tesla valuation - Complete practical exercise/32. Final comments.mp444.89MB
97. 17. Tesla valuation - Complete practical exercise/4. Comparing delivery figures with the ones of industry peers.mp420.93MB
98. 17. Tesla valuation - Complete practical exercise/5. Estimating an average selling price of Tesla vehicles.mp441.92MB
99. 17. Tesla valuation - Complete practical exercise/6. Calculating automotive revenue.mp446.57MB
100. 17. Tesla valuation - Complete practical exercise/7. Peer comparison Gross profit %.mp417.17MB
101. 17. Tesla valuation - Complete practical exercise/8. Calculating automotive gross profit.mp427.76MB
102. 17. Tesla valuation - Complete practical exercise/9. Calculating automotive cost of sales.mp417.5MB
103. 18. Capital budgeting - The theory/1. Introduction to Capital budgeting.mp45.43MB
104. 18. Capital budgeting - The theory/2. Why we need Capital budgeting.mp46.88MB
105. 18. Capital budgeting - The theory/3. The time value of money.mp46.69MB
106. 18. Capital budgeting - The theory/4. Calculating future and present value.mp413.08MB
107. 18. Capital budgeting - The theory/5. Calculating cost of equity.mp419.21MB
108. 18. Capital budgeting - The theory/6. Coming up with project-specific beta.mp49MB
109. 18. Capital budgeting - The theory/7. Weighted average cost of capital (WACC).mp45.5MB
110. 18. Capital budgeting - The theory/8. The type of cash flows we will have in a project.mp49.34MB
111. 18. Capital budgeting - The theory/9. Estimating the project's cash flows.mp418.8MB
112. 19. Capital Budgeting - A complete Case study/1. Introduction to the Capital budgeting exercise.mp48.63MB
113. 19. Capital Budgeting - A complete Case study/10. Finding cost of equity.mp413.93MB
114. 19. Capital Budgeting - A complete Case study/11. Discounting the project's cash flows and residual value.mp425.91MB
115. 19. Capital Budgeting - A complete Case study/12. Performing sensitivity analysis and completing the exercise.mp443.05MB
116. 19. Capital Budgeting - A complete Case study/15. Congratulations!!.mp42.31MB
117. 19. Capital Budgeting - A complete Case study/2. Organizing an Inputs sheet.mp411.06MB
118. 19. Capital Budgeting - A complete Case study/3. Forecasting savings Building a plant in Vietnam vs. producing cars in Italy.mp49.21MB
119. 19. Capital Budgeting - A complete Case study/4. Fixed asset rollforward.mp412.16MB
120. 19. Capital Budgeting - A complete Case study/5. The impact of working capital.mp45.36MB
121. 19. Capital Budgeting - A complete Case study/6. Modeling debt financing.mp46.18MB
122. 19. Capital Budgeting - A complete Case study/7. Adding a P&L sheet.mp44.88MB
123. 19. Capital Budgeting - A complete Case study/8. Calculating project cash flows.mp410.15MB
124. 19. Capital Budgeting - A complete Case study/9. Estimating the weighted average cost of capital (WACC).mp45.58MB
125. 2. Introduction to Excel/1. Introduction to Excel.mp41.99MB
126. 2. Introduction to Excel/11. Introduction to Excel functions.mp418.69MB
127. 2. Introduction to Excel/12. Cut, copy, & paste.mp412.99MB
128. 2. Introduction to Excel/14. Paste special.mp410.88MB
129. 2. Introduction to Excel/15. Format cells.mp429.12MB
130. 2. Introduction to Excel/2. Overview of Excel.mp420.69MB
131. 2. Introduction to Excel/4. The Excel ribbon.mp413.58MB
132. 2. Introduction to Excel/5. Basic operations with rows and columns.mp411.2MB
133. 2. Introduction to Excel/6. Data entry in Excel.mp415.99MB
134. 2. Introduction to Excel/7. Introduction to formatting.mp438.22MB
135. 2. Introduction to Excel/9. Introduction to Excel formulas.mp420.67MB
136. 21. APPENDIX - Microsoft Excel 2010 - Introduction to Excel/1. Overview of Excel.mp441.17MB
137. 21. APPENDIX - Microsoft Excel 2010 - Introduction to Excel/2. Basic manipulations with rows and columns.mp420.42MB
138. 21. APPENDIX - Microsoft Excel 2010 - Introduction to Excel/3. The Excel ribbon.mp428.91MB
139. 21. APPENDIX - Microsoft Excel 2010 - Introduction to Excel/4. Data entry in Excel.mp431.5MB
140. 21. APPENDIX - Microsoft Excel 2010 - Introduction to Excel/5. Introduction to formatting.mp475.39MB
141. 21. APPENDIX - Microsoft Excel 2010 - Introduction to Excel/6. Introduction to Excel formulas.mp418.77MB
142. 21. APPENDIX - Microsoft Excel 2010 - Introduction to Excel/7. Introduction to Excel functions.mp437.13MB
143. 21. APPENDIX - Microsoft Excel 2010 - Introduction to Excel/8. Cut, copy, & paste.mp47.56MB
144. 21. APPENDIX - Microsoft Excel 2010 - Introduction to Excel/9. Paste special.mp46.7MB
145. 22. APPENDIX - Microsoft Excel 2010 - Useful tips and tricks/1. Initial formatting of an Excel sheet to render it professional.mp47.98MB
146. 22. APPENDIX - Microsoft Excel 2010 - Useful tips and tricks/10. Find and select special types of cells with Select Special (F5).mp49.78MB
147. 22. APPENDIX - Microsoft Excel 2010 - Useful tips and tricks/11. Assign custom formats to specific cells within a financial model (e.g Multiples).mp45.42MB
148. 22. APPENDIX - Microsoft Excel 2010 - Useful tips and tricks/12. Define a named range in Excel.mp45.43MB
149. 22. APPENDIX - Microsoft Excel 2010 - Useful tips and tricks/13. Learn how to organize your data with Text to Columns.mp412.53MB
150. 22. APPENDIX - Microsoft Excel 2010 - Useful tips and tricks/14. Learn how to assign dynamic names within a financial model.mp47.32MB
151. 22. APPENDIX - Microsoft Excel 2010 - Useful tips and tricks/15. Create easily printable documents in Excel by using Set Print Area.mp44.74MB
152. 22. APPENDIX - Microsoft Excel 2010 - Useful tips and tricks/16. Using the 'Alt + Enter' combination.mp43.33MB
153. 22. APPENDIX - Microsoft Excel 2010 - Useful tips and tricks/2. Fast scrolling through Excel sheets.mp422.17MB
154. 22. APPENDIX - Microsoft Excel 2010 - Useful tips and tricks/3. Introduction to fixing of cell references.mp420.37MB
155. 22. APPENDIX - Microsoft Excel 2010 - Useful tips and tricks/4. Learn how to use the Wrap Text button.mp42.15MB
156. 22. APPENDIX - Microsoft Excel 2010 - Useful tips and tricks/5. Create a drop-down list by using Data Validation.mp410.59MB
157. 22. APPENDIX - Microsoft Excel 2010 - Useful tips and tricks/6. Using Custom-sort in order to sort multiple columns within a table.mp49.14MB
158. 22. APPENDIX - Microsoft Excel 2010 - Useful tips and tricks/7. Create a great Index page at the beginning of your models - Hyperlinks.mp45.35MB
159. 22. APPENDIX - Microsoft Excel 2010 - Useful tips and tricks/8. Fix the top row of your table with Freeze Panes.mp417.67MB
160. 22. APPENDIX - Microsoft Excel 2010 - Useful tips and tricks/9. Macros are a great timesaver! Here's why!.mp411.1MB
161. 23. APPENDIX - Microsoft Excel 2010 - Keyboard shortcuts/1. Keyboard shortcuts Save LOTS of time in Excel 2010.mp430.43MB
162. 3. Useful tips and tools for your work in Excel/1. Excel best practices - Welcome lecture.mp42.14MB
163. 3. Useful tips and tools for your work in Excel/11. The wrap text button.mp43.66MB
164. 3. Useful tips and tools for your work in Excel/12. Set print area.mp47.58MB
165. 3. Useful tips and tools for your work in Excel/13. Custom sort helps you sort multiple columns in Excel tables.mp411.18MB
166. 3. Useful tips and tools for your work in Excel/14. Create drop-down lists with data validation.mp414.13MB
167. 3. Useful tips and tools for your work in Excel/15. Find and select special types of cells with Select special (F5).mp413.92MB
168. 3. Useful tips and tools for your work in Excel/17. Assign dynamic names in a financial model.mp47.73MB
169. 3. Useful tips and tools for your work in Excel/19. Define a named range in Excel.mp47.67MB
170. 3. Useful tips and tools for your work in Excel/2. Initial formatting of Excel sheets for a professional layout.mp411.59MB
171. 3. Useful tips and tools for your work in Excel/20. Create a great Index page at the beginning of your models - Hyperlinks.mp48.57MB
172. 3. Useful tips and tools for your work in Excel/21. Introduction to custom formatting in Excel.mp437.96MB
173. 3. Useful tips and tools for your work in Excel/22. Apply custom formatting in a financial model.mp49.15MB
174. 3. Useful tips and tools for your work in Excel/23. Macros are a great timesaver! Here's why!.mp417.17MB
175. 3. Useful tips and tools for your work in Excel/24. How to save macros and use them across several workbooks.mp412.79MB
176. 3. Useful tips and tools for your work in Excel/26. Fix the top row of your table with freeze panes.mp414.47MB
177. 3. Useful tips and tools for your work in Excel/27. How to search functionalities in Excel.mp47.54MB
178. 3. Useful tips and tools for your work in Excel/28. Filter by color - an excellent tool.mp49.87MB
179. 3. Useful tips and tools for your work in Excel/29. Working with conditional formatting.mp415.09MB
180. 3. Useful tips and tools for your work in Excel/3. Fast scrolling through Excel sheets.mp417.53MB
181. 3. Useful tips and tools for your work in Excel/31. A neat trick - Multiply by 1.mp414.84MB
182. 3. Useful tips and tools for your work in Excel/32. Find and replace - references.mp424.04MB
183. 3. Useful tips and tools for your work in Excel/34. Find and replace - formatting.mp413.78MB
184. 3. Useful tips and tools for your work in Excel/35. Removing (automatic) green arrows.mp412.6MB
185. 3. Useful tips and tools for your work in Excel/36. Beauty saving - The professional way of saving files.mp414.03MB
186. 3. Useful tips and tools for your work in Excel/37. Formula auditing with F2.mp417.74MB
187. 3. Useful tips and tools for your work in Excel/5. Be even quicker F5 + Enter.mp419.79MB
188. 3. Useful tips and tools for your work in Excel/6. Fixing cell references.mp424.11MB
189. 3. Useful tips and tools for your work in Excel/8. Alt + Enter.mp44.16MB
190. 3. Useful tips and tools for your work in Excel/9. Organize your data with text to columns.mp413.95MB
191. 4. Keyboard shortcuts in Excel/1. Keyboard shortcuts save LOTS of time in Excel.mp451.17MB
192. 5. Excel's key functions and functionalities made easy/1. Excel's key functions - Welcome lecture.mp42.31MB
193. 5. Excel's key functions and functionalities made easy/11. Working with text in Excel.mp416.01MB
194. 5. Excel's key functions and functionalities made easy/12. Find the minimum or maximum value in a range of cells in Excel.mp45.92MB
195. 5. Excel's key functions and functionalities made easy/13. Include ROUND in your financial models.mp43.13MB
196. 5. Excel's key functions and functionalities made easy/14. Learn how to transfer data efficiently in Excel VLOOKUP and HLOOKUP.mp434.6MB
197. 5. Excel's key functions and functionalities made easy/15. How to enlarge the formula bar.mp46.25MB
198. 5. Excel's key functions and functionalities made easy/16. INDEX, MATCH and their combination - the perfect substitute for VLOOKUP.mp438.95MB
199. 5. Excel's key functions and functionalities made easy/17. A great Excel technique INDEX, MATCH, MATCH.mp411.77MB
200. 5. Excel's key functions and functionalities made easy/19. Using Excel's IFERROR function to trap spreadsheet errors.mp47.52MB
201. 5. Excel's key functions and functionalities made easy/20. RANK is a valuable tool when using Excel for financial and business analysis.mp423.25MB
202. 5. Excel's key functions and functionalities made easy/21. Learn how to render your models flexible with CHOOSE.mp48.98MB
203. 5. Excel's key functions and functionalities made easy/22. Use Goal Seek to find the result that you are looking for.mp47.86MB
204. 5. Excel's key functions and functionalities made easy/24. Include sensitivity analysis in your models through Data Tables.mp414.29MB
205. 5. Excel's key functions and functionalities made easy/26. Excel's dynamic and interactive tables Pivot tables.mp423.2MB
206. 5. Excel's key functions and functionalities made easy/3. Key functions in Excel IF.mp416.65MB
207. 5. Excel's key functions and functionalities made easy/4. Key Excel functions SUM, SUMIF and SUMIFS.mp419.32MB
208. 5. Excel's key functions and functionalities made easy/5. = and + are interchangeable when you start typing a formula.mp45.79MB
209. 5. Excel's key functions and functionalities made easy/6. Key Excel functions COUNT, COUNTA, COUNTIF, COUNTIFS.mp416.99MB
210. 5. Excel's key functions and functionalities made easy/7. Key Excel functions AVERAGE and AVERAGEIF.mp47.85MB
211. 5. Excel's key functions and functionalities made easy/9. Elaborate text efficiently LEFT, RIGHT, MID, UPPER, LOWER, PROPER, CONCATENATE.mp416.79MB
212. 6. Update! SUMIFS - Exercise/2. Exercise - Excel's SUMIFS function - solved & explained.mp435.32MB
213. 7. Financial functions in Excel/1. Future and present values in Excel.mp414.97MB
214. 7. Financial functions in Excel/2. Calculating the rate of return of an investment with the IRR function.mp47.58MB
215. 7. Financial functions in Excel/3. Calculating a complete loan schedule in Excel.mp414.82MB
216. 7. Financial functions in Excel/4. Date functions in Excel.mp411.36MB
217. 8. Microsoft Excel's Pivot Tables in depth/1. Introduction to Pivot Tables and the way they are applied.mp46MB
218. 8. Microsoft Excel's Pivot Tables in depth/2. Creating Pivot Tables easily!.mp419.38MB
219. 8. Microsoft Excel's Pivot Tables in depth/3. Give your Excel Pivot Tables a makeover.mp411.28MB
220. 8. Microsoft Excel's Pivot Tables in depth/4. Modifying and pivoting fields to obtain the Pivot Table you need.mp423.01MB
221. 8. Microsoft Excel's Pivot Tables in depth/5. Learn more about GETPIVOTDATA - A very important Excel function.mp418.06MB
222. 8. Microsoft Excel's Pivot Tables in depth/6. An introduction to slicers - The modern-day Pivot Table filters.mp422.17MB
223. 9. Case study - Building a complete P&L from scratch in Excel/1. Case study - Build a P&L from scratch - Welcome lecture.mp43.13MB
224. 9. Case study - Building a complete P&L from scratch in Excel/11. Use INDEX & MATCH as a substitute for VLOOKUP.mp449.59MB
225. 9. Case study - Building a complete P&L from scratch in Excel/12. Mapping the rows in the database sheet.mp432.48MB
226. 9. Case study - Building a complete P&L from scratch in Excel/13. In case you have any doubts about the Mapping exercise.mp438.57MB
227. 9. Case study - Building a complete P&L from scratch in Excel/14. Building the structure of the P&L sheet.mp420.85MB
228. 9. Case study - Building a complete P&L from scratch in Excel/15. Formatting sets You apart from the competition in Excel - A Practical Example.mp425.43MB
229. 9. Case study - Building a complete P&L from scratch in Excel/16. Populate the P&L sheet with SUMIF.mp430.27MB
230. 9. Case study - Building a complete P&L from scratch in Excel/18. Learn how to find mistakes with COUNTIF.mp427.87MB
231. 9. Case study - Building a complete P&L from scratch in Excel/19. Calculating year-on-year percentage variations the proper way.mp429.97MB
232. 9. Case study - Building a complete P&L from scratch in Excel/2. Introduction to the case study.mp410.21MB
233. 9. Case study - Building a complete P&L from scratch in Excel/3. Understand your data source before you start working on it.mp428.17MB
234. 9. Case study - Building a complete P&L from scratch in Excel/4. Order the source worksheets.mp426.54MB
235. 9. Case study - Building a complete P&L from scratch in Excel/5. Create a code the best way to organize your data and work efficiently with it.mp424.48MB
236. 9. Case study - Building a complete P&L from scratch in Excel/6. Learn how to create a database.mp420.7MB
237. 9. Case study - Building a complete P&L from scratch in Excel/7. Use VLOOKUP to fill the database sheet.mp461.58MB
238. 9. Case study - Building a complete P&L from scratch in Excel/8. 50% completed!.mp44.31MB
239. 9. Case study - Building a complete P&L from scratch in Excel/9. Use SUMIF to complete the database sheet.mp447.95MB