Download Free Download : Udemy Beginner to Pro in Excel Financial Modeling and Valuation
mp4 | Video: h264,1920X1080 | Audio: AAC, 44.1 KHz
Genre:eLearning | Language: English | Size:8.06 GB
Files Included :
1 - What does the course cover.mp4 (57.91 MB)
MP4
4 - The best way to take this course.mp4 (20.01 MB)
MP4
74 - Future and present values in Excel.mp4 (44.03 MB)
MP4
75 - Calculating the rate of return of an investment with the IRR function.mp4 (18.55 MB)
MP4
76 - Calculating a complete loan schedule in Excel.mp4 (32.02 MB)
MP4
77 - Date functions in Excel.mp4 (26.76 MB)
MP4
78 - Introduction to Pivot Tables and the way they are applied.mp4 (9.92 MB)
MP4
79 - Creating Pivot Tables easily.mp4 (29.09 MB)
MP4
80 - Give your Excel Pivot Tables a makeover.mp4 (13.03 MB)
MP4
81 - Modifying and pivoting fields to obtain the Pivot Table you need.mp4 (71.52 MB)
MP4
82 - Learn more about GETPIVOTDATA A very important Excel function.mp4 (27.63 MB)
MP4
83 - An introduction to slicers The modernday Pivot Table filters.mp4 (26.44 MB)
MP4
101 - Learn how to find mistakes with COUNTIF.mp4 (35.38 MB)
MP4
102 - Calculating yearonyear percentage variations the proper way.mp4 (15.75 MB)
MP4
84 - Case study Build a PL from scratch Welcome lecture.mp4 (5.05 MB)
MP4
85 - Introduction to the case study.mp4 (3.91 MB)
MP4
86 - Understand your data source before you start working on it.mp4 (18.94 MB)
MP4
87 - Order the source worksheets.mp4 (20.02 MB)
MP4
88 - Create a code the best way to organize your data and work efficiently with it.mp4 (29.34 MB)
MP4
89 - Learn how to create a database.mp4 (36.69 MB)
MP4
90 - Use VLOOKUP to fill the database sheet.mp4 (74.45 MB)
MP4
91 - Use SUMIF to complete the database sheet.mp4 (58.52 MB)
MP4
93 - Use INDEX MATCH as a substitute for VLOOKUP.mp4 (91.18 MB)
MP4
94 - Substituting VLOOKUP with XLOOKUP Office 365 Only.mp4 (26.32 MB)
MP4
95 - Mapping the rows in the database sheet.mp4 (49.65 MB)
MP4
96 - In case you have any doubts about the Mapping exercise.mp4 (36.92 MB)
MP4
97 - Building the structure of the PL sheet.mp4 (16.96 MB)
MP4
98 - Formatting sets You apart from the competition in Excel A Practical Example.mp4 (16.08 MB)
MP4
99 - Populate the PL sheet with SUMIF.mp4 (36.12 MB)
MP4
104 - How to insert a chart in Excel.mp4 (27.56 MB)
MP4
105 - Editing Excel charts.mp4 (20.64 MB)
MP4
106 - Excel chart formatting.mp4 (26.2 MB)
MP4
107 - How to create a bridge chart in Excel.mp4 (10.54 MB)
MP4
108 - New ways to visualize your data Treemap charts.mp4 (9.47 MB)
MP4
109 - Sparklines.mp4 (22.5 MB)
MP4
110 - Create professional and goodlooking charts Introduction.mp4 (3.05 MB)
MP4
111 - Build a column stacked chart with a secondary line axis in Excel.mp4 (33.11 MB)
MP4
112 - Learn how to build effective doughnut charts in Excel.mp4 (37.1 MB)
MP4
113 - Learn how to build an area chart in Excel.mp4 (20.9 MB)
MP4
114 - Learn how to create bridge charts.mp4 (50.1 MB)
MP4
115 - Learn how to create bridge charts in Excel 2007 2010 and 2013.mp4 (160.3 MB)
MP4
116 - Course Challenge Apply your skills in practice.mp4 (19.71 MB)
MP4
117 - Trend Analysis in Excel.mp4 (62.86 MB)
MP4
118 - Comparative Analysis in Excel.mp4 (55.16 MB)
MP4
119 - Valuebased analysis in Excel.mp4 (37.82 MB)
MP4
120 - Correlation analysis in Excel.mp4 (24.09 MB)
MP4
121 - Time series analysis in Excel.mp4 (77.22 MB)
MP4
122 - Regression analysis in Excel.mp4 (31.07 MB)
MP4
123 - Introduction to the Case Study.mp4 (18.23 MB)
MP4
124 - Preliminary mapping of the data extraction.mp4 (35.36 MB)
MP4
125 - Working with an SAP data extraction.mp4 (70.56 MB)
MP4
126 - Creating an output structure of the FMCG model.mp4 (32.11 MB)
MP4
127 - Improving the layout and appearance of the FMCG report.mp4 (25.74 MB)
MP4
128 - Inserting formulas and automating calculations.mp4 (15.63 MB)
MP4
129 - Creating a Master Pivot Table The main data source for the FMCG report.mp4 (25.4 MB)
MP4
130 - GETPIVOTDATA is great Extracting data from the Master Pivot Table.mp4 (93.37 MB)
MP4
131 - A potential error with GETPIVOTDATA you might encounter and its fix.mp4 (17.07 MB)
MP4
133 - Combining Slicers and GETPIVOTDATA The key to our success.mp4 (43.69 MB)
MP4
134 - Getting fancy with Excel slicers Goodlooking Excel slicers.mp4 (43.25 MB)
MP4
135 - This is how the report can be used in practice by highlevel executives.mp4 (71.24 MB)
MP4
136 - Financial modeling basics Welcome lecture.mp4 (3.37 MB)
MP4
137 - What is a financial model.mp4 (13.2 MB)
MP4
138 - Why use financial models.mp4 (17.38 MB)
MP4
139 - Financial modeling worst practices things you should avoid.mp4 (36.64 MB)
MP4
140 - Financial modeling best practices.mp4 (102.96 MB)
MP4
141 - Financial modeling The types of models that are built in practice.mp4 (20.84 MB)
MP4
142 - Financial modeling The right level of detail in a model.mp4 (9.89 MB)
MP4
143 - Financial modeling Forecasting guidelines.mp4 (9.16 MB)
MP4
144 - Building a complete model Important considerations.mp4 (21 MB)
MP4
145 - Modeling the Income statement.mp4 (17.97 MB)
MP4
146 - Modeling the Balance sheet Part 1.mp4 (7.53 MB)
MP4
147 - Modeling the Balance sheet Part 2.mp4 (11.64 MB)
MP4
148 - Why value a company.mp4 (19.12 MB)
MP4
149 - An investors perspective.mp4 (13.5 MB)
MP4
150 - The main value drivers when valuing a business.mp4 (6.64 MB)
MP4
151 - How to calculate Unlevered Free Cash Flow.mp4 (66.02 MB)
MP4
152 - How to calculate Weighted Average Cost of Capital WACC.mp4 (13.73 MB)
MP4
153 - How to calculate cost of debt.mp4 (7.01 MB)
MP4
154 - How to calculate cost of equity.mp4 (26.35 MB)
MP4
155 - Forecasting a firms financials.mp4 (25.05 MB)
MP4
156 - How to obtain Terminal Value.mp4 (12.5 MB)
MP4
157 - Discounting cash flows.mp4 (12.95 MB)
MP4
158 - How to obtain Enterprise and Equity Value.mp4 (15.23 MB)
MP4
10 - Data entry in Excel.mp4 (17.34 MB)
MP4
11 - Introduction to formatting.mp4 (60.31 MB)
MP4
12 - Introduction to Excel formulas.mp4 (19.45 MB)
MP4
13 - Introduction to Excel functions.mp4 (15.12 MB)
MP4
14 - Cut copy paste.mp4 (8.55 MB)
MP4
15 - Paste special.mp4 (7.99 MB)
MP4
16 - Format cells.mp4 (19.1 MB)
MP4
6 - Introduction to Excel.mp4 (3.12 MB)
MP4
7 - Overview of Excel.mp4 (24.24 MB)
MP4
8 - The Excel ribbon.mp4 (22.29 MB)
MP4
9 - Basic operations with rows and columns.mp4 (8.41 MB)
MP4
160 - Valuation Case study Welcome lecture.mp4 (2.74 MB)
MP4
161 - Introduction to the DCF exercise.mp4 (3.31 MB)
MP4
162 - The stages of a complete DCF Valuation.mp4 (21.25 MB)
MP4
163 - Description of the structure of the DCF model.mp4 (10.66 MB)
MP4
164 - A glimpse at the company we are valuing Cheeseco.mp4 (9.05 MB)
MP4
165 - Modeling the top line.mp4 (17.74 MB)
MP4
166 - Introducing scenarios to the model with Choose.mp4 (10.04 MB)
MP4
167 - Modeling other items Other revenues and Cogs.mp4 (47.82 MB)
MP4
168 - Modeling other items Operating expenses and DA.mp4 (13.84 MB)
MP4
169 - Modeling other items Interest expenses Extraordinary items and Taxes.mp4 (20.12 MB)
MP4
170 - Forecasting Balance sheet items.mp4 (2.71 MB)
MP4
171 - An introduction to the Days methodology.mp4 (5.01 MB)
MP4
172 - Calculation of DSO DPO and DOI for the historical period.mp4 (7.89 MB)
MP4
173 - Forecasting DSO DPO and DOI.mp4 (13.48 MB)
MP4
174 - Forecasting Property Plant Equipment Other assets and Other liabilities.mp4 (23.2 MB)
MP4
175 - Creating an output PL sheet.mp4 (10.18 MB)
MP4
176 - Populating the output PL sheet.mp4 (18.84 MB)
MP4
177 - Populating the output BS sheet.mp4 (8.74 MB)
MP4
178 - Completing the output BS sheet for the historical period.mp4 (50.9 MB)
MP4
179 - Creating a structure for the calculation of Unlevered free cash flows.mp4 (12.64 MB)
MP4
180 - Bridging Unlevered free cash flow to Net cash flow.mp4 (8.04 MB)
MP4
181 - Calculating Unlevered free cash flow.mp4 (74.21 MB)
MP4
182 - Calculating Net cash flow.mp4 (27.53 MB)
MP4
183 - Obtaining the rest of the cash flows through Find and Replace.mp4 (33.32 MB)
MP4
184 - Introducing Weighted average cost of capital and Perpetuity growth.mp4 (7.07 MB)
MP4
185 - Discounting Unlevered free cash flows to obtain their Present value.mp4 (23.6 MB)
MP4
186 - Calculating Continuing value and Enterprise value of the business.mp4 (9.9 MB)
MP4
187 - Calculating Equity value.mp4 (13.92 MB)
MP4
188 - Sensitivity analysis for WACC and perpetuity growth.mp4 (21.94 MB)
MP4
189 - A possible application of Goal seek.mp4 (8.31 MB)
MP4
190 - Using charts to summarize the results of the DCF model.mp4 (37.92 MB)
MP4
191 - Organizing external inputs in a Drivers sheet.mp4 (53.65 MB)
MP4
192 - Forecasting Teslas expected deliveries.mp4 (205.09 MB)
MP4
193 - Comparing delivery figures with the ones of industry peers.mp4 (31.8 MB)
MP4
194 - Estimating an average selling price of Tesla vehicles.mp4 (62.15 MB)
MP4
195 - Calculating automotive revenue.mp4 (83.39 MB)
MP4
196 - Peer comparison Gross profit.mp4 (37.5 MB)
MP4
197 - Calculating automotive gross profit.mp4 (38.51 MB)
MP4
198 - Calculating automotive cost of sales.mp4 (13.12 MB)
MP4
199 - Forecasting energy and services revenue.mp4 (19.48 MB)
MP4
200 - Calculating energy and services gross profit and cost of sales.mp4 (34.67 MB)
MP4
201 - Forecasting operating expenses.mp4 (37.74 MB)
MP4
202 - Building a fixed asset roll forward PPE.mp4 (49.01 MB)
MP4
203 - Building a fixed asset roll forward estimating Capex.mp4 (68.51 MB)
MP4
204 - Building a fixed asset roll forward DA schedule.mp4 (47.01 MB)
MP4
205 - Calculating DSO DIO DPO.mp4 (15.87 MB)
MP4
206 - Producing a clean PL output sheet.mp4 (12.69 MB)
MP4
207 - Calculating investments in working capital.mp4 (37.27 MB)
MP4
208 - Forecasting Unlevered free cash flow.mp4 (43.76 MB)
MP4
209 - Forecasting other assets.mp4 (63.46 MB)
MP4
210 - Forecasting other liabilities.mp4 (18.66 MB)
MP4
211 - Completing Unlevered free cash flow.mp4 (112.87 MB)
MP4
212 - Modeling Teslas financing needs in the forecast period.mp4 (77.95 MB)
MP4
213 - Calculating Net income.mp4 (18.6 MB)
MP4
214 - Bridging Unlevered free cash flow to Net cash flow.mp4 (81.83 MB)
MP4
215 - Balancing the Balance sheet.mp4 (23.38 MB)
MP4
216 - Estimating Weighted average cost of capital WACC.mp4 (50.54 MB)
MP4
217 - Performing discounted cash flow valuation DCF.mp4 (42.97 MB)
MP4
218 - Calculating enterprise value equity value and price per share.mp4 (17.89 MB)
MP4
219 - Final comments.mp4 (114.26 MB)
MP4
220 - You made it.mp4 (4.86 MB)
MP4
221 - What are valuation multiples and why we use them.mp4 (21.8 MB)
MP4
222 - What types of valuation multiples are there.mp4 (11.49 MB)
MP4
223 - Trading vs transaction valuation multiples.mp4 (11.96 MB)
MP4
224 - Main principles of multiples valuation.mp4 (28.16 MB)
MP4
225 - Comparison of earnings multiples PE vs EVEBITDA.mp4 (25.63 MB)
MP4
226 - Introduction to the exercise.mp4 (16.2 MB)
MP4
227 - Highlevel assessment of peer companies.mp4 (40.63 MB)
MP4
228 - Assessment of PL data comparable companies.mp4 (25.07 MB)
MP4
229 - How to adjust EBIT theoretical framework.mp4 (15.6 MB)
MP4
230 - How to adjust EV theoretical framework.mp4 (10.66 MB)
MP4
231 - How to adjust EBIT practical example Volkswagen.mp4 (103.54 MB)
MP4
232 - How to adjust EV practical example Volkswagen.mp4 (52.92 MB)
MP4
233 - Conclusion of the practical exercise.mp4 (13.91 MB)
MP4
235 - Introduction to LBO Modeling exercise.mp4 (4.58 MB)
MP4
236 - Key drivers in the LBO model.mp4 (26.47 MB)
MP4
237 - Constructing the Profit and Loss header.mp4 (9.75 MB)
MP4
238 - Analyzing historical Profit and Loss figures.mp4 (7.12 MB)
MP4
239 - Valuing the Target company.mp4 (10.33 MB)
MP4
240 - Estimating transaction fees.mp4 (19.85 MB)
MP4
241 - Sources and uses of funds.mp4 (18.57 MB)
MP4
242 - Shaping the Balance sheet at transaction.mp4 (22.68 MB)
MP4
243 - Goodwill calculation.mp4 (4.84 MB)
MP4
244 - Integrating assumptions into the Drivers sheet.mp4 (25.13 MB)
MP4
245 - Building a Fixed asset roll forward schedule.mp4 (16.94 MB)
MP4
246 - Forecasting financials using the Drivers sheet.mp4 (25.71 MB)
MP4
247 - Completing the Profit and Loss statement up to EBITDA.mp4 (47.25 MB)
MP4
248 - Modeling Working capital.mp4 (42.4 MB)
MP4
249 - Filling in the Balance sheet at transaction sheet.mp4 (17.59 MB)
MP4
250 - Add financials to the Balance sheet.mp4 (19.67 MB)
MP4
251 - Projecting Fixed asset roll forward.mp4 (38.05 MB)
MP4
252 - Developing a Debt schedule.mp4 (23.18 MB)
MP4
253 - Creating a Fixed asset amortization schedule.mp4 (53.33 MB)
MP4
254 - Structuring Cash Flow.mp4 (11.88 MB)
MP4
255 - Designing the Financing sheet.mp4 (45 MB)
MP4
256 - Calculating Cash Flow.mp4 (46.69 MB)
MP4
257 - Building an Equity schedule.mp4 (24.47 MB)
MP4
258 - Finalizing the Financing Cash Flow.mp4 (20.73 MB)
MP4
259 - Modeling the Revolver facility first part.mp4 (91.98 MB)
MP4
260 - Completing the Profit and Loss statement.mp4 (17.6 MB)
MP4
261 - Modeling the Revolver facility second part.mp4 (4.78 MB)
MP4
262 - Balancing the Balance sheet.mp4 (46.72 MB)
MP4
263 - Exit valuation and IRR comparison.mp4 (70.8 MB)
MP4
264 - Introduction to Capital budgeting.mp4 (7.6 MB)
MP4
265 - Why we need Capital budgeting.mp4 (10.28 MB)
MP4
266 - The time value of money.mp4 (7.24 MB)
MP4
267 - Calculating future and present value.mp4 (14.86 MB)
MP4
268 - Calculating cost of equity.mp4 (47.8 MB)
MP4
269 - Coming up with projectspecific beta.mp4 (10.59 MB)
MP4
270 - Weighted average cost of capital WACC.mp4 (6.26 MB)
MP4
271 - The type of cash flows we will have in a project.mp4 (9.36 MB)
MP4
272 - Estimating the projects cash flows.mp4 (21.27 MB)
MP4
273 - Introduction to the Capital budgeting exercise.mp4 (19.19 MB)
MP4
274 - Organizing an Inputs sheet.mp4 (23.21 MB)
MP4
275 - Forecasting savings Building a plant in Vietnam vs producing cars in Italy.mp4 (29.3 MB)
MP4
276 - Fixed asset rollforward.mp4 (32.3 MB)
MP4
277 - The impact of working capital.mp4 (11.09 MB)
MP4
278 - Modeling debt financing.mp4 (13.09 MB)
MP4
279 - Adding a PL sheet.mp4 (25.26 MB)
MP4
280 - Calculating project cash flows.mp4 (55.78 MB)
MP4
281 - Estimating the weighted average cost of capital WACC.mp4 (11.58 MB)
MP4
282 - Finding cost of equity.mp4 (52.44 MB)
MP4
283 - Discounting the projects cash flows and residual value.mp4 (17.3 MB)
MP4
284 - Performing sensitivity analysis and completing the exercise.mp4 (33.35 MB)
MP4
286 - Congratulations.mp4 (4.34 MB)
MP4
288 - Overview of Excel.mp4 (16.49 MB)
MP4
289 - Basic manipulations with rows and columns.mp4 (13.6 MB)
MP4
290 - The Excel ribbon.mp4 (18.5 MB)
MP4
291 - Data entry in Excel.mp4 (21.36 MB)
MP4
292 - Introduction to formatting.mp4 (44.82 MB)
MP4
293 - Introduction to Excel formulas.mp4 (12.17 MB)
MP4
294 - Introduction to Excel functions.mp4 (23.32 MB)
MP4
295 - Cut copy paste.mp4 (13.11 MB)
MP4
296 - Paste special.mp4 (10.43 MB)
MP4
297 - Initial formatting of an Excel sheet to render it professional.mp4 (12.65 MB)
MP4
298 - Fast scrolling through Excel sheets.mp4 (38.8 MB)
MP4
299 - Introduction to fixing of cell references.mp4 (17.3 MB)
MP4
300 - Learn how to use the Wrap Text button.mp4 (2.82 MB)
MP4
301 - Create a dropdown list by using Data Validation.mp4 (9.34 MB)
MP4
302 - Using Customsort in order to sort multiple columns within a table.mp4 (9.88 MB)
MP4
303 - Create a great Index page at the beginning of your models Hyperlinks.mp4 (5.49 MB)
MP4
304 - Fix the top row of your table with Freeze Panes.mp4 (11.5 MB)
MP4
305 - Macros are a great timesaver Heres why.mp4 (18.6 MB)
MP4
306 - Find and select special types of cells with Select Special F5.mp4 (8.34 MB)
MP4
307 - Assign custom formats to specific cells within a financial model eg Multiples.mp4 (6.76 MB)
MP4
308 - Define a named range in Excel.mp4 (6.36 MB)
MP4
309 - Learn how to organize your data with Text to Columns.mp4 (9.79 MB)
MP4
310 - Learn how to assign dynamic names within a financial model.mp4 (6.99 MB)
MP4
311 - Create easily printable documents in Excel by using Set Print Area.mp4 (9.02 MB)
MP4
312 - Using the Alt Enter combination.mp4 (5.09 MB)
MP4
313 - Keyboard shortcuts Save LOTS of time in Excel 2010.mp4 (63.77 MB)
MP4
314 - Key Excel functions SUM SUMIF and SUMIFS.mp4 (28.35 MB)
MP4
315 - Key Excel functions COUNT COUNTA COUNTIF COUNTIFS.mp4 (18.29 MB)
MP4
316 - Key Excel functions AVERAGE and AVERAGEIF.mp4 (8.64 MB)
MP4
317 - Elaborate text efficiently LEFT RIGHT MID UPPER LOWER PROPER CONCATENATE.mp4 (24.47 MB)
MP4
318 - Find the minimum or maximum value in a range of cells in Excel.mp4 (4.23 MB)
MP4
319 - Include ROUND in your financial models.mp4 (5.41 MB)
MP4
320 - Key Excel functions VLOOKUP and HLOOKUP.mp4 (48.89 MB)
MP4
321 - INDEX MATCH and their combination the perfect substitute for VLOOKUP.mp4 (34.48 MB)
MP4
322 - Using Excels IFERROR function to trap spreadsheet errors.mp4 (8.13 MB)
MP4
323 - Learn how to render your models flexible with CHOOSE.mp4 (10.13 MB)
MP4
324 - Use Goal Seek to find the result that you are looking for.mp4 (12.21 MB)
MP4
325 - Include sensitivity analysis in your models through Data Tables.mp4 (17.39 MB)
MP4
326 - Excels dynamic and interactive tables Pivot tables.mp4 (19.44 MB)
MP4
327 - Why value a company.mp4 (3.87 MB)
MP4
328 - An investors perspective when valuing a company.mp4 (14.31 MB)
MP4
329 - Which are the drivers of company value.mp4 (3.72 MB)
MP4
330 - How to calculate UFCF.mp4 (8.99 MB)
MP4
331 - What is WACC.mp4 (8.12 MB)
MP4
332 - How to find cost of debt.mp4 (2.41 MB)
MP4
333 - How to find cost of equity.mp4 (25.81 MB)
MP4
334 - Forecasting financials.mp4 (5.46 MB)
MP4
335 - Calculating terminal value.mp4 (4.97 MB)
MP4
336 - Discounting cash flows.mp4 (6.36 MB)
MP4
337 - Calculating enterprise and equity value.mp4 (2.29 MB)
MP4
18 - Excel best practices Welcome lecture.mp4 (3.36 MB)
MP4
19 - Initial formatting of Excel sheets for a professional layout.mp4 (10.99 MB)
MP4
20 - Fast scrolling through Excel sheets.mp4 (23.64 MB)
MP4
21 - Be even quicker F5 Enter.mp4 (24.48 MB)
MP4
22 - Fixing cell references.mp4 (17.24 MB)
MP4
23 - Alt Enter.mp4 (3.07 MB)
MP4
24 - Organize your data with text to columns.mp4 (9.53 MB)
MP4
25 - The wrap text button.mp4 (2.72 MB)
MP4
26 - Set print area.mp4 (7.93 MB)
MP4
27 - Custom sort helps you sort multiple columns in Excel tables.mp4 (7.22 MB)
MP4
28 - Create dropdown lists with data validation.mp4 (11.75 MB)
MP4
29 - Find and select special types of cells with Select special F5.mp4 (8.56 MB)
MP4
30 - Assign dynamic names in a financial model.mp4 (5.73 MB)
MP4
31 - Define a named range in Excel.mp4 (6.38 MB)
MP4
32 - Create a great Index page at the beginning of your models Hyperlinks.mp4 (12.4 MB)
MP4
33 - Introduction to custom formatting in Excel.mp4 (27.02 MB)
MP4
34 - Apply custom formatting in a financial model.mp4 (6.4 MB)
MP4
35 - Macros are a great timesaver Heres why.mp4 (26.46 MB)
MP4
36 - How to save macros and use them across several workbooks.mp4 (8.05 MB)
MP4
37 - Fix the top row of your table with freeze panes.mp4 (9.43 MB)
MP4
38 - How to search functionalities in Excel.mp4 (5.36 MB)
MP4
39 - Filter by color an excellent tool.mp4 (30.19 MB)
MP4
40 - Working with conditional formatting.mp4 (75.98 MB)
MP4
41 - A neat trick Multiply by 1.mp4 (7.85 MB)
MP4
42 - Find and replace references.mp4 (14.92 MB)
MP4
44 - Find and replace formatting.mp4 (7.73 MB)
MP4
45 - Removing automatic green arrows.mp4 (9.51 MB)
MP4
46 - Beauty saving The professional way of saving files.mp4 (9.39 MB)
MP4
47 - Formula auditing with F2.mp4 (13.02 MB)
MP4
48 - Keyboard shortcuts save LOTS of time in Excel.mp4 (71.82 MB)
MP4
50 - Excels key functions Welcome lecture.mp4 (3.67 MB)
MP4
52 - Key functions in Excel IF.mp4 (9.67 MB)
MP4
53 - Key Excel functions SUM SUMIF and SUMIFS.mp4 (19.56 MB)
MP4
54 - and are interchangeable when you start typing a formula.mp4 (3.4 MB)
MP4
55 - Key Excel functions COUNT COUNTA COUNTIF COUNTIFS.mp4 (17.82 MB)
MP4
56 - Key Excel functions AVERAGE and AVERAGEIF.mp4 (10.62 MB)
MP4
57 - Work with text efficiently LEFT RIGHT MID UPPER LOWER PROPER CONCATENATE.mp4 (21.59 MB)
MP4
58 - Working with text continued.mp4 (10.31 MB)
MP4
59 - Find the minimum or maximum value in a range of cells in Excel.mp4 (3.63 MB)
MP4
60 - Include ROUND in your financial models.mp4 (3.45 MB)
MP4
61 - Key Excel functions VLOOKUP and HLOOKUP.mp4 (45.04 MB)
MP4
62 - How to enlarge the formula bar.mp4 (3.73 MB)
MP4
63 - INDEX MATCH and their combination the perfect substitute for VLOOKUP.mp4 (43.74 MB)
MP4
64 - A great Excel technique INDEX MATCH MATCH.mp4 (22.38 MB)
MP4
65 - XLOOKUP a solid substitute for VLOOKUP and INDEXMATCH.mp4 (28.61 MB)
MP4
66 - Using Excels IFERROR function to trap spreadsheet errors.mp4 (10.82 MB)
MP4
67 - RANK is a valuable tool when using Excel for financial and business analysis.mp4 (13.1 MB)
MP4
68 - CHOOSE Learn how to render your models flexible.mp4 (11.94 MB)
MP4
69 - Use Goal Seek to find the result that you are looking for.mp4 (8.57 MB)
MP4
70 - Include sensitivity analysis in your models through Data Tables.mp4 (16.75 MB)
MP4
71 - Excels dynamic and interactive tables Pivot tables.mp4 (15.85 MB)
MP4
73 - Exercise Excels SUMIFS function solved explained.mp4 (94.74 MB)
MP4
MP4
4 - The best way to take this course.mp4 (20.01 MB)
MP4
74 - Future and present values in Excel.mp4 (44.03 MB)
MP4
75 - Calculating the rate of return of an investment with the IRR function.mp4 (18.55 MB)
MP4
76 - Calculating a complete loan schedule in Excel.mp4 (32.02 MB)
MP4
77 - Date functions in Excel.mp4 (26.76 MB)
MP4
78 - Introduction to Pivot Tables and the way they are applied.mp4 (9.92 MB)
MP4
79 - Creating Pivot Tables easily.mp4 (29.09 MB)
MP4
80 - Give your Excel Pivot Tables a makeover.mp4 (13.03 MB)
MP4
81 - Modifying and pivoting fields to obtain the Pivot Table you need.mp4 (71.52 MB)
MP4
82 - Learn more about GETPIVOTDATA A very important Excel function.mp4 (27.63 MB)
MP4
83 - An introduction to slicers The modernday Pivot Table filters.mp4 (26.44 MB)
MP4
101 - Learn how to find mistakes with COUNTIF.mp4 (35.38 MB)
MP4
102 - Calculating yearonyear percentage variations the proper way.mp4 (15.75 MB)
MP4
84 - Case study Build a PL from scratch Welcome lecture.mp4 (5.05 MB)
MP4
85 - Introduction to the case study.mp4 (3.91 MB)
MP4
86 - Understand your data source before you start working on it.mp4 (18.94 MB)
MP4
87 - Order the source worksheets.mp4 (20.02 MB)
MP4
88 - Create a code the best way to organize your data and work efficiently with it.mp4 (29.34 MB)
MP4
89 - Learn how to create a database.mp4 (36.69 MB)
MP4
90 - Use VLOOKUP to fill the database sheet.mp4 (74.45 MB)
MP4
91 - Use SUMIF to complete the database sheet.mp4 (58.52 MB)
MP4
93 - Use INDEX MATCH as a substitute for VLOOKUP.mp4 (91.18 MB)
MP4
94 - Substituting VLOOKUP with XLOOKUP Office 365 Only.mp4 (26.32 MB)
MP4
95 - Mapping the rows in the database sheet.mp4 (49.65 MB)
MP4
96 - In case you have any doubts about the Mapping exercise.mp4 (36.92 MB)
MP4
97 - Building the structure of the PL sheet.mp4 (16.96 MB)
MP4
98 - Formatting sets You apart from the competition in Excel A Practical Example.mp4 (16.08 MB)
MP4
99 - Populate the PL sheet with SUMIF.mp4 (36.12 MB)
MP4
104 - How to insert a chart in Excel.mp4 (27.56 MB)
MP4
105 - Editing Excel charts.mp4 (20.64 MB)
MP4
106 - Excel chart formatting.mp4 (26.2 MB)
MP4
107 - How to create a bridge chart in Excel.mp4 (10.54 MB)
MP4
108 - New ways to visualize your data Treemap charts.mp4 (9.47 MB)
MP4
109 - Sparklines.mp4 (22.5 MB)
MP4
110 - Create professional and goodlooking charts Introduction.mp4 (3.05 MB)
MP4
111 - Build a column stacked chart with a secondary line axis in Excel.mp4 (33.11 MB)
MP4
112 - Learn how to build effective doughnut charts in Excel.mp4 (37.1 MB)
MP4
113 - Learn how to build an area chart in Excel.mp4 (20.9 MB)
MP4
114 - Learn how to create bridge charts.mp4 (50.1 MB)
MP4
115 - Learn how to create bridge charts in Excel 2007 2010 and 2013.mp4 (160.3 MB)
MP4
116 - Course Challenge Apply your skills in practice.mp4 (19.71 MB)
MP4
117 - Trend Analysis in Excel.mp4 (62.86 MB)
MP4
118 - Comparative Analysis in Excel.mp4 (55.16 MB)
MP4
119 - Valuebased analysis in Excel.mp4 (37.82 MB)
MP4
120 - Correlation analysis in Excel.mp4 (24.09 MB)
MP4
121 - Time series analysis in Excel.mp4 (77.22 MB)
MP4
122 - Regression analysis in Excel.mp4 (31.07 MB)
MP4
123 - Introduction to the Case Study.mp4 (18.23 MB)
MP4
124 - Preliminary mapping of the data extraction.mp4 (35.36 MB)
MP4
125 - Working with an SAP data extraction.mp4 (70.56 MB)
MP4
126 - Creating an output structure of the FMCG model.mp4 (32.11 MB)
MP4
127 - Improving the layout and appearance of the FMCG report.mp4 (25.74 MB)
MP4
128 - Inserting formulas and automating calculations.mp4 (15.63 MB)
MP4
129 - Creating a Master Pivot Table The main data source for the FMCG report.mp4 (25.4 MB)
MP4
130 - GETPIVOTDATA is great Extracting data from the Master Pivot Table.mp4 (93.37 MB)
MP4
131 - A potential error with GETPIVOTDATA you might encounter and its fix.mp4 (17.07 MB)
MP4
133 - Combining Slicers and GETPIVOTDATA The key to our success.mp4 (43.69 MB)
MP4
134 - Getting fancy with Excel slicers Goodlooking Excel slicers.mp4 (43.25 MB)
MP4
135 - This is how the report can be used in practice by highlevel executives.mp4 (71.24 MB)
MP4
136 - Financial modeling basics Welcome lecture.mp4 (3.37 MB)
MP4
137 - What is a financial model.mp4 (13.2 MB)
MP4
138 - Why use financial models.mp4 (17.38 MB)
MP4
139 - Financial modeling worst practices things you should avoid.mp4 (36.64 MB)
MP4
140 - Financial modeling best practices.mp4 (102.96 MB)
MP4
141 - Financial modeling The types of models that are built in practice.mp4 (20.84 MB)
MP4
142 - Financial modeling The right level of detail in a model.mp4 (9.89 MB)
MP4
143 - Financial modeling Forecasting guidelines.mp4 (9.16 MB)
MP4
144 - Building a complete model Important considerations.mp4 (21 MB)
MP4
145 - Modeling the Income statement.mp4 (17.97 MB)
MP4
146 - Modeling the Balance sheet Part 1.mp4 (7.53 MB)
MP4
147 - Modeling the Balance sheet Part 2.mp4 (11.64 MB)
MP4
148 - Why value a company.mp4 (19.12 MB)
MP4
149 - An investors perspective.mp4 (13.5 MB)
MP4
150 - The main value drivers when valuing a business.mp4 (6.64 MB)
MP4
151 - How to calculate Unlevered Free Cash Flow.mp4 (66.02 MB)
MP4
152 - How to calculate Weighted Average Cost of Capital WACC.mp4 (13.73 MB)
MP4
153 - How to calculate cost of debt.mp4 (7.01 MB)
MP4
154 - How to calculate cost of equity.mp4 (26.35 MB)
MP4
155 - Forecasting a firms financials.mp4 (25.05 MB)
MP4
156 - How to obtain Terminal Value.mp4 (12.5 MB)
MP4
157 - Discounting cash flows.mp4 (12.95 MB)
MP4
158 - How to obtain Enterprise and Equity Value.mp4 (15.23 MB)
MP4
10 - Data entry in Excel.mp4 (17.34 MB)
MP4
11 - Introduction to formatting.mp4 (60.31 MB)
MP4
12 - Introduction to Excel formulas.mp4 (19.45 MB)
MP4
13 - Introduction to Excel functions.mp4 (15.12 MB)
MP4
14 - Cut copy paste.mp4 (8.55 MB)
MP4
15 - Paste special.mp4 (7.99 MB)
MP4
16 - Format cells.mp4 (19.1 MB)
MP4
6 - Introduction to Excel.mp4 (3.12 MB)
MP4
7 - Overview of Excel.mp4 (24.24 MB)
MP4
8 - The Excel ribbon.mp4 (22.29 MB)
MP4
9 - Basic operations with rows and columns.mp4 (8.41 MB)
MP4
160 - Valuation Case study Welcome lecture.mp4 (2.74 MB)
MP4
161 - Introduction to the DCF exercise.mp4 (3.31 MB)
MP4
162 - The stages of a complete DCF Valuation.mp4 (21.25 MB)
MP4
163 - Description of the structure of the DCF model.mp4 (10.66 MB)
MP4
164 - A glimpse at the company we are valuing Cheeseco.mp4 (9.05 MB)
MP4
165 - Modeling the top line.mp4 (17.74 MB)
MP4
166 - Introducing scenarios to the model with Choose.mp4 (10.04 MB)
MP4
167 - Modeling other items Other revenues and Cogs.mp4 (47.82 MB)
MP4
168 - Modeling other items Operating expenses and DA.mp4 (13.84 MB)
MP4
169 - Modeling other items Interest expenses Extraordinary items and Taxes.mp4 (20.12 MB)
MP4
170 - Forecasting Balance sheet items.mp4 (2.71 MB)
MP4
171 - An introduction to the Days methodology.mp4 (5.01 MB)
MP4
172 - Calculation of DSO DPO and DOI for the historical period.mp4 (7.89 MB)
MP4
173 - Forecasting DSO DPO and DOI.mp4 (13.48 MB)
MP4
174 - Forecasting Property Plant Equipment Other assets and Other liabilities.mp4 (23.2 MB)
MP4
175 - Creating an output PL sheet.mp4 (10.18 MB)
MP4
176 - Populating the output PL sheet.mp4 (18.84 MB)
MP4
177 - Populating the output BS sheet.mp4 (8.74 MB)
MP4
178 - Completing the output BS sheet for the historical period.mp4 (50.9 MB)
MP4
179 - Creating a structure for the calculation of Unlevered free cash flows.mp4 (12.64 MB)
MP4
180 - Bridging Unlevered free cash flow to Net cash flow.mp4 (8.04 MB)
MP4
181 - Calculating Unlevered free cash flow.mp4 (74.21 MB)
MP4
182 - Calculating Net cash flow.mp4 (27.53 MB)
MP4
183 - Obtaining the rest of the cash flows through Find and Replace.mp4 (33.32 MB)
MP4
184 - Introducing Weighted average cost of capital and Perpetuity growth.mp4 (7.07 MB)
MP4
185 - Discounting Unlevered free cash flows to obtain their Present value.mp4 (23.6 MB)
MP4
186 - Calculating Continuing value and Enterprise value of the business.mp4 (9.9 MB)
MP4
187 - Calculating Equity value.mp4 (13.92 MB)
MP4
188 - Sensitivity analysis for WACC and perpetuity growth.mp4 (21.94 MB)
MP4
189 - A possible application of Goal seek.mp4 (8.31 MB)
MP4
190 - Using charts to summarize the results of the DCF model.mp4 (37.92 MB)
MP4
191 - Organizing external inputs in a Drivers sheet.mp4 (53.65 MB)
MP4
192 - Forecasting Teslas expected deliveries.mp4 (205.09 MB)
MP4
193 - Comparing delivery figures with the ones of industry peers.mp4 (31.8 MB)
MP4
194 - Estimating an average selling price of Tesla vehicles.mp4 (62.15 MB)
MP4
195 - Calculating automotive revenue.mp4 (83.39 MB)
MP4
196 - Peer comparison Gross profit.mp4 (37.5 MB)
MP4
197 - Calculating automotive gross profit.mp4 (38.51 MB)
MP4
198 - Calculating automotive cost of sales.mp4 (13.12 MB)
MP4
199 - Forecasting energy and services revenue.mp4 (19.48 MB)
MP4
200 - Calculating energy and services gross profit and cost of sales.mp4 (34.67 MB)
MP4
201 - Forecasting operating expenses.mp4 (37.74 MB)
MP4
202 - Building a fixed asset roll forward PPE.mp4 (49.01 MB)
MP4
203 - Building a fixed asset roll forward estimating Capex.mp4 (68.51 MB)
MP4
204 - Building a fixed asset roll forward DA schedule.mp4 (47.01 MB)
MP4
205 - Calculating DSO DIO DPO.mp4 (15.87 MB)
MP4
206 - Producing a clean PL output sheet.mp4 (12.69 MB)
MP4
207 - Calculating investments in working capital.mp4 (37.27 MB)
MP4
208 - Forecasting Unlevered free cash flow.mp4 (43.76 MB)
MP4
209 - Forecasting other assets.mp4 (63.46 MB)
MP4
210 - Forecasting other liabilities.mp4 (18.66 MB)
MP4
211 - Completing Unlevered free cash flow.mp4 (112.87 MB)
MP4
212 - Modeling Teslas financing needs in the forecast period.mp4 (77.95 MB)
MP4
213 - Calculating Net income.mp4 (18.6 MB)
MP4
214 - Bridging Unlevered free cash flow to Net cash flow.mp4 (81.83 MB)
MP4
215 - Balancing the Balance sheet.mp4 (23.38 MB)
MP4
216 - Estimating Weighted average cost of capital WACC.mp4 (50.54 MB)
MP4
217 - Performing discounted cash flow valuation DCF.mp4 (42.97 MB)
MP4
218 - Calculating enterprise value equity value and price per share.mp4 (17.89 MB)
MP4
219 - Final comments.mp4 (114.26 MB)
MP4
220 - You made it.mp4 (4.86 MB)
MP4
221 - What are valuation multiples and why we use them.mp4 (21.8 MB)
MP4
222 - What types of valuation multiples are there.mp4 (11.49 MB)
MP4
223 - Trading vs transaction valuation multiples.mp4 (11.96 MB)
MP4
224 - Main principles of multiples valuation.mp4 (28.16 MB)
MP4
225 - Comparison of earnings multiples PE vs EVEBITDA.mp4 (25.63 MB)
MP4
226 - Introduction to the exercise.mp4 (16.2 MB)
MP4
227 - Highlevel assessment of peer companies.mp4 (40.63 MB)
MP4
228 - Assessment of PL data comparable companies.mp4 (25.07 MB)
MP4
229 - How to adjust EBIT theoretical framework.mp4 (15.6 MB)
MP4
230 - How to adjust EV theoretical framework.mp4 (10.66 MB)
MP4
231 - How to adjust EBIT practical example Volkswagen.mp4 (103.54 MB)
MP4
232 - How to adjust EV practical example Volkswagen.mp4 (52.92 MB)
MP4
233 - Conclusion of the practical exercise.mp4 (13.91 MB)
MP4
235 - Introduction to LBO Modeling exercise.mp4 (4.58 MB)
MP4
236 - Key drivers in the LBO model.mp4 (26.47 MB)
MP4
237 - Constructing the Profit and Loss header.mp4 (9.75 MB)
MP4
238 - Analyzing historical Profit and Loss figures.mp4 (7.12 MB)
MP4
239 - Valuing the Target company.mp4 (10.33 MB)
MP4
240 - Estimating transaction fees.mp4 (19.85 MB)
MP4
241 - Sources and uses of funds.mp4 (18.57 MB)
MP4
242 - Shaping the Balance sheet at transaction.mp4 (22.68 MB)
MP4
243 - Goodwill calculation.mp4 (4.84 MB)
MP4
244 - Integrating assumptions into the Drivers sheet.mp4 (25.13 MB)
MP4
245 - Building a Fixed asset roll forward schedule.mp4 (16.94 MB)
MP4
246 - Forecasting financials using the Drivers sheet.mp4 (25.71 MB)
MP4
247 - Completing the Profit and Loss statement up to EBITDA.mp4 (47.25 MB)
MP4
248 - Modeling Working capital.mp4 (42.4 MB)
MP4
249 - Filling in the Balance sheet at transaction sheet.mp4 (17.59 MB)
MP4
250 - Add financials to the Balance sheet.mp4 (19.67 MB)
MP4
251 - Projecting Fixed asset roll forward.mp4 (38.05 MB)
MP4
252 - Developing a Debt schedule.mp4 (23.18 MB)
MP4
253 - Creating a Fixed asset amortization schedule.mp4 (53.33 MB)
MP4
254 - Structuring Cash Flow.mp4 (11.88 MB)
MP4
255 - Designing the Financing sheet.mp4 (45 MB)
MP4
256 - Calculating Cash Flow.mp4 (46.69 MB)
MP4
257 - Building an Equity schedule.mp4 (24.47 MB)
MP4
258 - Finalizing the Financing Cash Flow.mp4 (20.73 MB)
MP4
259 - Modeling the Revolver facility first part.mp4 (91.98 MB)
MP4
260 - Completing the Profit and Loss statement.mp4 (17.6 MB)
MP4
261 - Modeling the Revolver facility second part.mp4 (4.78 MB)
MP4
262 - Balancing the Balance sheet.mp4 (46.72 MB)
MP4
263 - Exit valuation and IRR comparison.mp4 (70.8 MB)
MP4
264 - Introduction to Capital budgeting.mp4 (7.6 MB)
MP4
265 - Why we need Capital budgeting.mp4 (10.28 MB)
MP4
266 - The time value of money.mp4 (7.24 MB)
MP4
267 - Calculating future and present value.mp4 (14.86 MB)
MP4
268 - Calculating cost of equity.mp4 (47.8 MB)
MP4
269 - Coming up with projectspecific beta.mp4 (10.59 MB)
MP4
270 - Weighted average cost of capital WACC.mp4 (6.26 MB)
MP4
271 - The type of cash flows we will have in a project.mp4 (9.36 MB)
MP4
272 - Estimating the projects cash flows.mp4 (21.27 MB)
MP4
273 - Introduction to the Capital budgeting exercise.mp4 (19.19 MB)
MP4
274 - Organizing an Inputs sheet.mp4 (23.21 MB)
MP4
275 - Forecasting savings Building a plant in Vietnam vs producing cars in Italy.mp4 (29.3 MB)
MP4
276 - Fixed asset rollforward.mp4 (32.3 MB)
MP4
277 - The impact of working capital.mp4 (11.09 MB)
MP4
278 - Modeling debt financing.mp4 (13.09 MB)
MP4
279 - Adding a PL sheet.mp4 (25.26 MB)
MP4
280 - Calculating project cash flows.mp4 (55.78 MB)
MP4
281 - Estimating the weighted average cost of capital WACC.mp4 (11.58 MB)
MP4
282 - Finding cost of equity.mp4 (52.44 MB)
MP4
283 - Discounting the projects cash flows and residual value.mp4 (17.3 MB)
MP4
284 - Performing sensitivity analysis and completing the exercise.mp4 (33.35 MB)
MP4
286 - Congratulations.mp4 (4.34 MB)
MP4
288 - Overview of Excel.mp4 (16.49 MB)
MP4
289 - Basic manipulations with rows and columns.mp4 (13.6 MB)
MP4
290 - The Excel ribbon.mp4 (18.5 MB)
MP4
291 - Data entry in Excel.mp4 (21.36 MB)
MP4
292 - Introduction to formatting.mp4 (44.82 MB)
MP4
293 - Introduction to Excel formulas.mp4 (12.17 MB)
MP4
294 - Introduction to Excel functions.mp4 (23.32 MB)
MP4
295 - Cut copy paste.mp4 (13.11 MB)
MP4
296 - Paste special.mp4 (10.43 MB)
MP4
297 - Initial formatting of an Excel sheet to render it professional.mp4 (12.65 MB)
MP4
298 - Fast scrolling through Excel sheets.mp4 (38.8 MB)
MP4
299 - Introduction to fixing of cell references.mp4 (17.3 MB)
MP4
300 - Learn how to use the Wrap Text button.mp4 (2.82 MB)
MP4
301 - Create a dropdown list by using Data Validation.mp4 (9.34 MB)
MP4
302 - Using Customsort in order to sort multiple columns within a table.mp4 (9.88 MB)
MP4
303 - Create a great Index page at the beginning of your models Hyperlinks.mp4 (5.49 MB)
MP4
304 - Fix the top row of your table with Freeze Panes.mp4 (11.5 MB)
MP4
305 - Macros are a great timesaver Heres why.mp4 (18.6 MB)
MP4
306 - Find and select special types of cells with Select Special F5.mp4 (8.34 MB)
MP4
307 - Assign custom formats to specific cells within a financial model eg Multiples.mp4 (6.76 MB)
MP4
308 - Define a named range in Excel.mp4 (6.36 MB)
MP4
309 - Learn how to organize your data with Text to Columns.mp4 (9.79 MB)
MP4
310 - Learn how to assign dynamic names within a financial model.mp4 (6.99 MB)
MP4
311 - Create easily printable documents in Excel by using Set Print Area.mp4 (9.02 MB)
MP4
312 - Using the Alt Enter combination.mp4 (5.09 MB)
MP4
313 - Keyboard shortcuts Save LOTS of time in Excel 2010.mp4 (63.77 MB)
MP4
314 - Key Excel functions SUM SUMIF and SUMIFS.mp4 (28.35 MB)
MP4
315 - Key Excel functions COUNT COUNTA COUNTIF COUNTIFS.mp4 (18.29 MB)
MP4
316 - Key Excel functions AVERAGE and AVERAGEIF.mp4 (8.64 MB)
MP4
317 - Elaborate text efficiently LEFT RIGHT MID UPPER LOWER PROPER CONCATENATE.mp4 (24.47 MB)
MP4
318 - Find the minimum or maximum value in a range of cells in Excel.mp4 (4.23 MB)
MP4
319 - Include ROUND in your financial models.mp4 (5.41 MB)
MP4
320 - Key Excel functions VLOOKUP and HLOOKUP.mp4 (48.89 MB)
MP4
321 - INDEX MATCH and their combination the perfect substitute for VLOOKUP.mp4 (34.48 MB)
MP4
322 - Using Excels IFERROR function to trap spreadsheet errors.mp4 (8.13 MB)
MP4
323 - Learn how to render your models flexible with CHOOSE.mp4 (10.13 MB)
MP4
324 - Use Goal Seek to find the result that you are looking for.mp4 (12.21 MB)
MP4
325 - Include sensitivity analysis in your models through Data Tables.mp4 (17.39 MB)
MP4
326 - Excels dynamic and interactive tables Pivot tables.mp4 (19.44 MB)
MP4
327 - Why value a company.mp4 (3.87 MB)
MP4
328 - An investors perspective when valuing a company.mp4 (14.31 MB)
MP4
329 - Which are the drivers of company value.mp4 (3.72 MB)
MP4
330 - How to calculate UFCF.mp4 (8.99 MB)
MP4
331 - What is WACC.mp4 (8.12 MB)
MP4
332 - How to find cost of debt.mp4 (2.41 MB)
MP4
333 - How to find cost of equity.mp4 (25.81 MB)
MP4
334 - Forecasting financials.mp4 (5.46 MB)
MP4
335 - Calculating terminal value.mp4 (4.97 MB)
MP4
336 - Discounting cash flows.mp4 (6.36 MB)
MP4
337 - Calculating enterprise and equity value.mp4 (2.29 MB)
MP4
18 - Excel best practices Welcome lecture.mp4 (3.36 MB)
MP4
19 - Initial formatting of Excel sheets for a professional layout.mp4 (10.99 MB)
MP4
20 - Fast scrolling through Excel sheets.mp4 (23.64 MB)
MP4
21 - Be even quicker F5 Enter.mp4 (24.48 MB)
MP4
22 - Fixing cell references.mp4 (17.24 MB)
MP4
23 - Alt Enter.mp4 (3.07 MB)
MP4
24 - Organize your data with text to columns.mp4 (9.53 MB)
MP4
25 - The wrap text button.mp4 (2.72 MB)
MP4
26 - Set print area.mp4 (7.93 MB)
MP4
27 - Custom sort helps you sort multiple columns in Excel tables.mp4 (7.22 MB)
MP4
28 - Create dropdown lists with data validation.mp4 (11.75 MB)
MP4
29 - Find and select special types of cells with Select special F5.mp4 (8.56 MB)
MP4
30 - Assign dynamic names in a financial model.mp4 (5.73 MB)
MP4
31 - Define a named range in Excel.mp4 (6.38 MB)
MP4
32 - Create a great Index page at the beginning of your models Hyperlinks.mp4 (12.4 MB)
MP4
33 - Introduction to custom formatting in Excel.mp4 (27.02 MB)
MP4
34 - Apply custom formatting in a financial model.mp4 (6.4 MB)
MP4
35 - Macros are a great timesaver Heres why.mp4 (26.46 MB)
MP4
36 - How to save macros and use them across several workbooks.mp4 (8.05 MB)
MP4
37 - Fix the top row of your table with freeze panes.mp4 (9.43 MB)
MP4
38 - How to search functionalities in Excel.mp4 (5.36 MB)
MP4
39 - Filter by color an excellent tool.mp4 (30.19 MB)
MP4
40 - Working with conditional formatting.mp4 (75.98 MB)
MP4
41 - A neat trick Multiply by 1.mp4 (7.85 MB)
MP4
42 - Find and replace references.mp4 (14.92 MB)
MP4
44 - Find and replace formatting.mp4 (7.73 MB)
MP4
45 - Removing automatic green arrows.mp4 (9.51 MB)
MP4
46 - Beauty saving The professional way of saving files.mp4 (9.39 MB)
MP4
47 - Formula auditing with F2.mp4 (13.02 MB)
MP4
48 - Keyboard shortcuts save LOTS of time in Excel.mp4 (71.82 MB)
MP4
50 - Excels key functions Welcome lecture.mp4 (3.67 MB)
MP4
52 - Key functions in Excel IF.mp4 (9.67 MB)
MP4
53 - Key Excel functions SUM SUMIF and SUMIFS.mp4 (19.56 MB)
MP4
54 - and are interchangeable when you start typing a formula.mp4 (3.4 MB)
MP4
55 - Key Excel functions COUNT COUNTA COUNTIF COUNTIFS.mp4 (17.82 MB)
MP4
56 - Key Excel functions AVERAGE and AVERAGEIF.mp4 (10.62 MB)
MP4
57 - Work with text efficiently LEFT RIGHT MID UPPER LOWER PROPER CONCATENATE.mp4 (21.59 MB)
MP4
58 - Working with text continued.mp4 (10.31 MB)
MP4
59 - Find the minimum or maximum value in a range of cells in Excel.mp4 (3.63 MB)
MP4
60 - Include ROUND in your financial models.mp4 (3.45 MB)
MP4
61 - Key Excel functions VLOOKUP and HLOOKUP.mp4 (45.04 MB)
MP4
62 - How to enlarge the formula bar.mp4 (3.73 MB)
MP4
63 - INDEX MATCH and their combination the perfect substitute for VLOOKUP.mp4 (43.74 MB)
MP4
64 - A great Excel technique INDEX MATCH MATCH.mp4 (22.38 MB)
MP4
65 - XLOOKUP a solid substitute for VLOOKUP and INDEXMATCH.mp4 (28.61 MB)
MP4
66 - Using Excels IFERROR function to trap spreadsheet errors.mp4 (10.82 MB)
MP4
67 - RANK is a valuable tool when using Excel for financial and business analysis.mp4 (13.1 MB)
MP4
68 - CHOOSE Learn how to render your models flexible.mp4 (11.94 MB)
MP4
69 - Use Goal Seek to find the result that you are looking for.mp4 (8.57 MB)
MP4
70 - Include sensitivity analysis in your models through Data Tables.mp4 (16.75 MB)
MP4
71 - Excels dynamic and interactive tables Pivot tables.mp4 (15.85 MB)
MP4
73 - Exercise Excels SUMIFS function solved explained.mp4 (94.74 MB)
MP4
Code:
Bitte
Anmelden
oder
Registrieren
um Code Inhalt zu sehen!
Code:
Bitte
Anmelden
oder
Registrieren
um Code Inhalt zu sehen!
Code:
Bitte
Anmelden
oder
Registrieren
um Code Inhalt zu sehen!