1. Beginner to Pro in Excel Financial Modeling and Valuation - Welcome!

  1. What does the course cover.vtt

  2. Bonus! Welcome gift.html

  4. The best way to take this course.mp4

  5. Download all course materials.html

 10. Introduction to Excel charts

  1. How to insert a chart in Excel.vtt

  2. Editing Excel charts.mp4

  2.1 96. Formatting-a-Chart-Lecture.xlsm.xlsm

  3. Excel chart formatting.vtt

  4. How to create a bridge chart in Excel.mp4

  4.1 98. Bridge-Charts-Lecture.xlsx.xlsx

  5. New ways to visualize your data - Treemap charts.vtt

  6. Sparklines.mp4

  6.1 100. Sparklines-Lecture.xlsx.xlsx

 11

  1. Create professional and good-looking charts - Introduction.vtt

  2. Build a column stacked chart with a secondary line axis in Excel.vtt

  2.2 102. Column stacked chart-Lecture-after.xlsm.xlsm

  3. Learn how to build effective doughnut charts in Excel.vtt

  3.2 103. Doughnut chart-Lecture-before.xlsm.xlsm

  4. Learn how to build an area chart in Excel.vtt

  4.2 104. Area chart-Lecture-before.xlsm.xlsm

  5. Learn how to create bridge charts.vtt

  5.2 105. Bridge chart-Lecture-before.xlsm.xlsm

  6. Learn how to create bridge charts in Excel 2007, 2010, and 2013.vtt

  8. Course Challenge - Apply your skills in practice!.mp4

  8.1 107. Course-Challenge - Solved.xlsx.xlsx

 12. Case Study - Building an FMCG Model from Scratch

  1. Introduction to the Case Study.vtt

  10. Combining Slicers and GETPIVOTDATA The key to our success.mp4

  10.1 117. Exercise-Build-an-FMCG-Model-Inserting-Slicers-Lecture.xlsx.xlsx

  11. Getting fancy with Excel slicers - Good-looking Excel slicers.vtt

  12. This is how the report can be used in practice by high-level executives.mp4

  12.1 119. Exercise-Build-an-FMCG-Model-Complete.xlsx.xlsx

  2. Preliminary mapping of the data extraction.mp4

  2.1 109. Exercise-Build-an-FMCG-Model-Mapping-Lecture.xlsx.xlsx

  3. Working with an SAP data extraction.vtt

  4. Creating an output structure of the FMCG model.vtt

  5. Improving the layout and appearance of the FMCG report.mp4

  5.1 112. Exercise-Build-an-FMCG-Model-Formatting-Lecture.xlsx.xlsx

  6. Inserting formulas and automating calculations.vtt

  7. Creating a Master Pivot Table The main data source for the FMCG report.mp4

  7.1 114. Exercise-Build-an-FMCG-Model-Creating-a-Pivot-Table-Lecture.xlsx.xlsx

  8. GETPIVOTDATA is great! Extracting data from the Master Pivot Table.vtt

  9. A potential error with GETPIVOTDATA you might encounter and its fix.mp4

 13. Financial Modeling Fundamentals

  1. Financial Modeling basics - Welcome lecture.vtt

  11. Building a complete model - Important considerations.mp4

  12. Modeling the Income statement.mp4

  13. Modeling the Balance sheet - Part 1.mp4

  14. Modeling the Balance sheet - Part 2.mp4

  15. Building a financial model - Quiz.html

  2. What is a financial model.vtt

  3. Why use financial models.vtt

  4. Financial modeling - worst practices - things you should avoid.vtt

  5. Financial modeling - best practices.vtt

  6. Financial modeling - The types of models that are built in practice.vtt

  8. Financial modeling The right level of detail in a model.mp4

  9. Financial modeling Forecasting guidelines.mp4

 14. Introduction to Company Valuation

 15. Introduction to Mergers & Acquisitions

 16

  1. Valuation Case study - Welcome lecture.vtt

  10. Modeling other items Interest expenses, Extraordinary items and Taxes.vtt

  10.2 9. Interest expenses, taxes_after.xlsm.xlsm

  11. Forecasting Balance sheet items.vtt

  12. An introduction to the Days methodology.mp4

  12.1 Working Capital Days.pptx.pptx

  13. Calculation of DSO, DPO and DOI for the historical period.vtt

  13.2 12. Days calculation_after.xlsm.xlsm

  14. Forecasting DSO, DPO and DOI.vtt

  14.2 13. Forecasting DSO, DPO, DIO_after.xlsm.xlsm

  15. Forecasting Property, Plant & Equipment, Other assets and Other liabilities.vtt

  15.2 14. Forecasting PP&E, Other assets, and Other liabilities_before.xlsm.xlsm

  16. Creating an output P&L sheet.vtt

  16.2 15. P&L structure_before.xlsm.xlsm

  17. Populating the output P&L sheet.vtt

  17.2 16. Populating the P&L sheet_before.xlsm.xlsm

  18. Populating the output BS sheet.vtt

  18.2 17. Populating BS sheet_after.xlsm.xlsm

  19. Completing the output BS sheet for the historical period.vtt

  19.2 18. Completing the Balance Sheet_before.xlsm.xlsm

  2. Introduction to the DCF exercise.vtt

  20. Creating a structure for the calculation of Unlevered Free Cash Flows.vtt

  20.2 19. Cash flow structure_before.xlsm.xlsm

  21. Bridging Unlevered free cash flow to Net cash flow.vtt

  21.2 20. Bridge UFCF to Net cash flow_after.xlsm.xlsm

  22. Calculating Unlevered free cash flow.vtt

  22.2 21. Calculating UFCF_before.xlsm.xlsm

  23. Calculating Net cash flow.vtt

  23.2 Cash Flow Classification By Activities.xlsx

  24. Obtaining the rest of the cash flows through Find and Replace.mp4

  24.1 23. Find and replace_after.xlsm.xlsm

  25. Introducing Weighted average cost of capital and Perpetuity growth.mp4

  25.1 24. Introducing WACC and g_before.xlsm.xlsm

  26. Discounting Unlevered free cash flows to obtain their Present value.mp4

  26.1 25. Calculating PV of Cash Flows_after.xlsm.xlsm

  27. Calculating Continuing value and Enterprise value of the business.mp4

  27.1 26. Calculating CV and EV_after.xlsm.xlsm

  28. Calculating Equity value.mp4

  28.1 27. Calculating equity value_before.xlsm.xlsm

  29. Sensitivity analysis for WACC and perpetuity growth.mp4

  29.1 28. Sensitivity analysis_before.xlsm.xlsm

  29.3 Sensitivity Analysis.xlsx

  3. The stages of a complete DCF Valuation.vtt

  30. A possible application of Goal seek.mp4

  30.1 29. Goal seek_before.xlsm.xlsm

  31. Using charts to summarize the results of the DCF model.mp4

  32. You made it!.mp4

  4. Description of the structure of the DCF model.mp4

  4.1 3. Structure of the DCF model.xlsm.xlsm

  5. A glimpse at the company we are valuing - Cheeseco.mp4

  5.1 Cheeseco.pptx.pptx

  6. Modeling the top line.vtt

  6.2 5. Modeling revenues_before.xlsm.xlsm

  7. Introducing scenarios to the model with Choose.vtt

  7.2 6. Choose_before.xlsm.xlsm

  8. Modeling other items Other revenues and Cogs.vtt

  8.2 7. Other revenues and Cogs_before.xlsm.xlsm

  9. Modeling other items Operating expenses and D&A.vtt

  9.2 8. Opex and D&A_after.xlsm.xlsm

 17. Tesla valuation - Complete practical exercise

  1. Organizing external inputs in a 'Drivers' sheet.vtt

  1.2 Tesla 2016.pdf.pdf

  1.4 Tesla 2018 Q2.pdf.pdf

  1.6 Tesla 2015.pdf.pdf

  10. Forecasting 'energy' and 'services' revenue.mp4

  10.1 6. Energy and Other revenue - Before.xlsx.xlsx

  11. Calculating 'energy' and 'services' gross profit and cost of sales.mp4

  11.1 7. Energy and Other - Gross profit, cost of sales - Before.xlsx.xlsx

  12. Forecasting operating expenses.mp4

  12.1 8. Opex - Before.xlsx.xlsx

  13. Building a fixed asset roll forward estimating Capex.mp4

  13.1 9. PP&E forecasting and comparables_before.xlsx.xlsx

  14. Building a fixed asset roll forward D&A schedule.mp4

  14.1 10. PP&E schedule_after.xlsx.xlsx

  15. Peer comparison D&A as a percentage of revenues.mp4

  15.1 10a. PP&E comparison.xlsx.xlsx

  16. Calculating DSO, DIO, DPO.vtt

  16.2 11. Working capital forecasting_after.xlsx.xlsx

  17. Producing a clean P&L output sheet.vtt

  18. Fill in the P&L output sheet.mp4

  18.1 12a. P&L fill in_after.xlsx.xlsx

  19. Calculating investments in working capital.mp4

  19.1 13. Calculating working capital_after.xlsx.xlsx

  2. The input data we will work with.mp4

  2.1 0aa. Inputs_before.xlsx.xlsx

  20. Forecasting Unlevered free cash flow.mp4

  20.1 14. Cash flow - UFCF_after.xlsx.xlsx

  21. Forecasting other assets.mp4

  21.1 15. Balance Sheet forecasting assets_after.xlsx.xlsx

  22. Forecasting other liabilities.mp4

  22.1 16. Balance Sheet forecasting liabilities_after.xlsx.xlsx

  23. Completing Unlevered free cash flow.mp4

  23.1 16a. Complete UFCF_after.xlsx.xlsx

  24. Modeling Tesla's financing needs in the forecast period.mp4

  24.1 17. Financing_before.xlsx.xlsx

  25. Calculating Net income.mp4

  25.1 18. P&L complete_before.xlsx.xlsx

  26. Bridging Unlevered free cash flow to Net cash flow.mp4

  26.1 19. Cash flow_complete_after.xlsx.xlsx

  27. Balancing the Balance sheet.mp4

  27.1 20. Complete the BS_before.xlsx.xlsx

  28. Estimating Weighted average cost of capital (WACC).mp4

  28.1 21. WACC_before.xlsx.xlsx

  29. Performing discounted cash flow valuation (DCF).mp4

  29.1 22. DCF_after.xlsx.xlsx

  3. Forecasting Tesla's expected deliveries.mp4

  3.1 1. Deliveries_before.xlsx.xlsx

  30. Calculating enterprise value, equity value, and price per share.mp4

  30.1 23. EV, Equity value, Price per share_before.xlsx.xlsx

  31. Final comments.mp4

  4. Comparing delivery figures with the ones of industry peers.mp4

  4.1 1a. Deliveries development.xlsx.xlsx

  5. Estimating an average selling price of Tesla vehicles.vtt

  5.2 2. Average price_after.xlsx.xlsx

  6. Calculating automotive revenue.vtt

  6.2 3. Revenue calculation and scenarios - after.xlsx.xlsx

  7. Peer comparison Gross profit %.vtt

  8. Calculating automotive gross profit.mp4

  8.1 4a. Gross profit automotive - before.xlsx.xlsx

  9. Calculating automotive cost of sales.mp4

  9.1 5. Cost of sales and chart.xlsx.xlsx

 18. Capital budgeting - The theory

  1. Introduction to Capital budgeting.vtt

  2. Why we need Capital budgeting.vtt

  3. The time value of money.vtt

  4. Calculating future and present Value.vtt

  5. Calculating cost of equity.vtt

  6. Coming up with project-specific beta.vtt

  7. Weighted average cost of capital (WACC).vtt

  8. The type of cash flows we will have in a project.vtt

  9. Estimating the project's cash flows.vtt

 19. Capital Budgeting - A Complete Case Study

  1. Introduction to the Capital budgeting exercise.vtt

  10. Finding cost of equity.vtt

  10.2 8. WACC.xlsx.xlsx

  11. Discounting the project's cash flows and residual value.vtt

  11.2 9. Discounted cash flow.xlsx.xlsx

  12. Performing sensitivity analysis and completing the exercise.vtt

  12.2 10. Sensitivity analysis_unsolved.xlsx.xlsx

  14. Congratulations!!.mp4

  2. Organizing an Inputs sheet.mp4

  2.1 1. Drivers.xlsx.xlsx

  3. Forecasting savings Building a plant in Vietnam vs. producing cars in Italy.vtt

  3.2 2. Savings Forecast_unsolved.xlsx.xlsx

  4. Fixed asset rollforward.vtt

  4.2 3. Fixed Asset Rollforward.xlsx.xlsx

  5. The impact of working capital.vtt

  5.2 4. Working Capital_unsolved.xlsx.xlsx

  6. Modeling debt financing.vtt

  6.2 5. Financing.xlsx.xlsx

  7. Adding a P&L sheet.vtt

  7.2 6. P&L_unsolved.xlsx.xlsx

  8. Calculating project cash flows.vtt

  8.2 7. Cash flow.xlsx.xlsx

  9. Estimating the weighted average cost of capital (WACC).vtt

  9.2 8. WACC_unsolved.xlsx.xlsx

 2. Introduction to Excel

  1. Introduction to Excel - welcome lecture.vtt

  11. Introduction to Excel functions.mp4

  11.1 13. Functions- Exercise - Solved.xlsx.xlsx

  11.3 Introduction-to-Excels-basic-features.pdf.pdf

  11.5 13. Functions-Exercise - Unsolved.xlsx.xlsx

  12. Cut, copy, & paste.vtt

  12.2 14. Copy-Cut-Paste-Exercise - Unsolved.xlsx.xlsx

  13. Cut, copy, & paste.html

  14. Paste special.vtt

  14.2 15. Paste-Special-Exercise - Solved.xlsx.xlsx

  15. Basic operations in Excel - 38 pages.html

  2. Overview of Excel.vtt

  2.2 7. Overview-of-Excel-Exercise-Solved.xlsx.xlsx

  3. Overview of Excel.html

  4. Basic manipulations with rows and columns.vtt

  4.2 8. Basic-Manipulations - Exercise - Unsolved.xlsx.xlsx

  5. Rows and columns.html

  6. The Excel ribbon.vtt

  6.2 9. The-Ribbon-Exercise-Exercise - Unsolved.xlsx.xlsx

  7. Data entry in Excel.vtt

  7.2 10. Data-Entry-Exercise - Unsolved.xlsx.xlsx

  8. Introduction to formatting.mp4

  8.1 11. Formatting - Lecture - Solved.xlsx.xlsx

  8.3 11. Formatting- Exercise - Solved.xlsx.xlsx

  9. Introduction to Excel formulas.mp4

  9.1 12. Formulas- Lecture - Solved.xlsx.xlsx

  9.3 12. Formulas- Exercise - Solved.xlsx.xlsx

  9.5 Introduction-to-Excels-basic-features.pdf.pdf

 20. Bonus lecture

 3

  1. Excel best practices - Welcome lecture.vtt

  11. Learn how to use the Wrap Text button.mp4

  11.1 24. Wrap-Text-Exercise - Solved.xlsx.xlsx

  11.3 24. Wrap-Text-Exercise - Unsolved.xlsx.xlsx

  11.5 Useful-Tips-Tools.pdf.pdf

  12. Create easily printable documents in Excel by using Set Print Area.vtt

  12.2 25. Set-Print-Area-Lecture - Solved.xlsx.xlsx

  13. Find and select special types of cells with Select Special (F5).mp4

  13.1 26. Select-Special-Lecture.xlsx.xlsx

  13.3 26. Select-Special-F5-Exercise - Unsolved.xlsx.xlsx

  14. Select Special.html

  15. Learn how to assign dynamic names within a financial model.vtt

  15.2 Useful-Tips-Tools.pdf.pdf

  15.4 27. Dynamic-Naming-Lecture - Solved.xlsx.xlsx

  16. Assigning dynamic names.html

  17. Define a named range in Excel.vtt

  17.2 28. Naming-ranges-Lecture - Unsolved.xlsx.xlsx

  17.4 Useful-Tips-Tools.pdf.pdf

  18. Assign custom formats to specific cells within a financial model (e.g Multiples).mp4

  18.1 29. Assigning Custom Formats - Exercise - Unsolved.xlsx.xlsx

  18.3 29. Assigning Custom Formats - Exercise - Solved.xlsx.xlsx

  19. Macros are a great timesaver! Here's why!.vtt

  19.2 30. Creating-a-Macro-Lecture - Solved.xlsx.xlsx

  19.4 30. Creating-a-Macro-Lecture - Unsolved.xlsx.xlsx

  2. Initial formatting of an Excel sheet to render it professional.mp4

  2.1 18. Formatting-a-Worksheet-Exercise - Unsolved.xlsx.xlsx

  2.3 Useful-Tips-Tools.pdf.pdf

  2.5 18. Formatting-a-worksheet-Lecture - Unsolved.xlsx.xlsx

  20. How to save macros and use them across several workbooks.vtt

  20.2 31. How-to-save-macros-Lecture-before.xlsx.xlsx

  21. Excel Macros - quiz.html

  22. Create a drop-down list by using Data Validation.vtt

  22.2 32. Drop-down-List-Exercise - Solved.xlsx.xlsx

  22.4 32. Data-Validation-Lecture - Unsolved.xlsx.xlsx

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

  23.1 33. Custom-Sort-Exercise - Unsolved.xlsx.xlsx

  23.3 33. Sort-data-Lecture - Unsolved.xlsx.xlsx

  23.5 33. Custom-Sort-Exercise - Solved.xlsx.xlsx

  24. Create a great Index page at the beginning of your models - Hyperlinks.vtt

  24.2 34. Hyperlinks-Exercise - Solved.xlsx.xlsx

  25. Fix the top row of your table with Freeze Panes.mp4

  25.1 35. Freeze-Panes-Lecture - Unsolved.xlsx.xlsx

  25.3 Useful-Tips-Tools.pdf.pdf

  26. Filter by color - an excellent tool.vtt

  26.2 36. Exercise-Filter-by-Color-Solved.xlsx.xlsx

  27. Working with conditional formatting.vtt

  27.2 Exercise_Conditional Formatting.xlsx.xlsx

  28. A neat trick - Multiply by 1.vtt

  28.2 38. Multiply-by-1-Lecture-after.xlsx.xlsx

  3. Fast scrolling through Excel sheets.mp4

  3.1 Useful-Tips-Tools.pdf.pdf

  3.3 19. Fast-Scrolling-Exercise - Solved.xlsx.xlsx

  30. Find and replace - references.mp4

  30.1 39. Find-and-Replace-references-Lecture-after.xlsx.xlsx

  31. Find and replace - formatting.mp4

  31.1 40. Find-replace-Lecture-before.xlsx.xlsx

  32. Removing (automatic) green arrows.mp4

  32.1 41. Green-references-Lecture.xlsx.xlsx

  33. Beauty saving - The professional way of saving files.vtt

  33.2 42. Beauty-saving-Lecture-after.xlsx.xlsx

  34. Formula auditing with F2.vtt

  4. Be even quicker F5 + Enter.mp4

  4.1 20. F5-go-to - Lecture.xlsm.xlsm

  6. Introduction to fixing of cell references.mp4

  6.1 Useful-Tips-Tools.pdf.pdf

  6.3 21. Fixing-references-Lecture - Unsolved.xlsx.xlsx

  6.5 21. Fixing-references-Lecture - Solved.xlsx.xlsx

  8. Using the 'Alt + Enter' combination.mp4

  8.1 22. Alt-Enter-Exercise - Unsolved.xlsx.xlsx

  8.3 22. Alt-Enter- Lecture - Solved.xlsx.xlsx

  9. Learn how to organize your data with Text to Columns.mp4

  9.1 23. Text-to-Columns-Exercise - Solved.xlsx.xlsx

  9.3 23. Text-to-columns-Lecture - Unsolved.xlsx.xlsx

  9.5 23.Text-to-columns-Lecture - Solved.xlsx.xlsx

 4. Keyboard shortcuts in Excel

  1. Keyboard shortcuts Save LOTS of time in Excel.vtt

 5

  1. Excel's key functions - Welcome lecture.vtt

  10. Working with text in Excel.vtt

  10.2 53. Work-with-text-Lecture-before.xlsx.xlsx

  11. Find the minimum or maximum value in a range of cells in Excel.vtt

  11.2 54. MIN-MAX-Exercise - Unsolved.xlsx.xlsx

  11.4 54. MIN-MAX-Exercise - Solved.xlsx.xlsx

  12. Include ROUND in your financial models.vtt

  12.2 55. Excel-functions-Lecture.xlsx.xlsx

  12.4 55. Round-Exercise - Solved.xlsx.xlsx

  13. Learn how to transfer data efficiently in Excel VLOOKUP and HLOOKUP.vtt

  13.2 56. Vlookup-Hlookup- Lecture - Solved.xlsx.xlsx

  13.4 56. Vlookup-Hlookup-Exercise - Solved.xlsx.xlsx

  14. How to enlarge the formula bar.mp4

  14.1 57. Enlarge-the-formula-bar-Lecture.xlsm.xlsm

  15. INDEX, MATCH and their combination - the perfect substitute for VLOOKUP.vtt

  15.2 Excel-Functions.pdf.pdf

  15.4 58. Index-Match-Lecture - Unsolved.xlsx.xlsx

  16. A great Excel technique INDEX, MATCH, MATCH.mp4

  16.1 59. Exercise-Index-Match-Match-Solved.xlsx.xlsx

  17. INDEX, MATCH and their combination - the perfect substitute for VLOOKUP.html

  18. Using Excel's IFERROR function to trap spreadsheet errors.vtt

  18.2 60. Iferror-Exercise - Solved.xlsx.xlsx

  18.4 Excel-Functions.pdf.pdf

  19. RANK is a valuable tool when using Excel for Financial and Business analysis.mp4

  19.1 61. Rank-function-Lecture-after.xlsx.xlsx

  2. Key functions in Excel IF.mp4

  2.1 47. IF-function--Lecture-before.xlsm.xlsm

  2.3 Key functions - Excel.pdf.pdf

  2.5 Functions - English to Spanish.pdf.pdf

  20. Learn how to render your models flexible with CHOOSE.mp4

  20.1 62. Choose-Lecture - Unsolved.xlsx.xlsx

  20.3 62. Choose-Exercise-Solved.xlsx.xlsx

  20.5 62. Choose-Exercise - Unsolved.xlsx.xlsx

  21. Use Goal Seek to find the result that you are looking for.vtt

  21.2 Excel-Functions.pdf.pdf

  21.4 63. Goal-Seek-Lecture - Solved.xlsx.xlsx

  22. Use Goal Seek in order to find the result that you are looking for.html

  23. Include sensitivity analysis in your models through Data Tables.vtt

  23.2 64. Sensitivity-analysis-Exercise-Unsolved.xlsm.xlsm

  23.4 64. Sensitivity analysis - Lecture - Unsolved.xlsm.xlsm

  25. Excel's dynamic and interactive tables Pivot tables.mp4

  25.1 65. Pivot tables - Lecture - Unsolved.xlsm.xlsm

  25.3 65. Pivot tables - Lecture - Solved.xlsm.xlsm

  26. Excel's key functions and functionalities made easy.html

  3. Key Excel functions SUM, SUMIF and SUMIFS.vtt

  3.2 48. Sum-Sumif-Sumifs-Lecture - Solved.xlsx.xlsx

  3.4 Excel-Functions.pdf.pdf

  4. = and + are interchangeable when you start typing a formula.mp4

  4.1 49. = and + are interchangeable -after.xlsm.xlsm

  5. Key Excel functions COUNT, COUNTA, COUNTIF, COUNTIFS.mp4

  5.1 50.Counts-Exercise-Solved.xlsx.xlsx

  5.3 Lecture-Count-Countif-Countifs-Solved.xlsx.xlsx

  5.5 50.Counts-Exercise-Unsolved.xlsx.xlsx

  6. Key Excel functions AVERAGE and AVERAGEIF.vtt

  6.2 51. Average-AverageIF-Exercise - Solved.xlsx.xlsx

  6.4 51. Average-AverageIF-Exercise - Unsolved.xlsx.xlsx

  7. Key Excel functions AVERAGE and AVERAGEIF.html

  8. Elaborate text efficiently LEFT, RIGHT, MID, UPPER, LOWER, PROPER, CONCATENATE.vtt

  8.2 52. Text functions - Exercise - Unsolved.xlsx.xlsx

  8.4 52. Text-Functions- Lecture - Unsolved.xlsx.xlsx

 6. Update! SUMIFS - Exercise

  2. Exercise - Excel's SUMIFS function - solved & explained.mp4

  2.1 67. Exercise-Sumifs-With-Solutions.xlsx.xlsx

 7. Financial functions in Excel

  1. Future and present values in Excel.vtt

  2. Calculating the rate of return of an investment with the IRR function.mp4

  2.1 69. Exercise-IRR-Solved.xlsx.xlsx

  2.3 69. Exercise-IRR-Unsolved.xlsx.xlsx

  3. Calculating a complete loan schedule in Excel.vtt

  3.2 70. Exercise-Loan-Schedule-Solved.xlsx.xlsx

  4. Date functions in Excel.mp4

  4.1 71. Date Functions-Exercise-Solved.xlsx.xlsx

  4.3 71. Date Functions-Exercise-Unsolved.xlsx.xlsx

 8. Microsoft Excel's Pivot Tables in Depth

  1. Introduction to Pivot Tables and the way they are applied.vtt

  2. Creating Pivot Tables easily!.vtt

  2.2 73. Creating-a-Pivot-Table - Lecture – before.xlsx.xlsx

  3. Give your Excel Pivot Tables a makeover.vtt

  3.2 74. Formatting-a-Pivot-Table - Lecture - before.xlsx.xlsx

  4. Modifying and pivoting fields to obtain the Pivot Table you need.vtt

  4.2 75. Working-with-Pivot-Tables - Lecture - after.xlsx.xlsx

  5. Learn more about GETPIVOTDATA - A very important Excel function.vtt

  5.2 76. GetPivotData - Lecture – after.xlsx.xlsx

  6. An introduction to slicers - The modern-day Pivot Table filters.vtt

  6.2 77. Slicers - Lecture - before.xlsx.xlsx

 9

  1. Case study - Build a P&L from scratch - Welcome lecture.vtt

  10. Use INDEX & MATCH as a substitute for VLOOKUP.vtt

  10.2 87. Index Match-Lecture-after.xlsm.xlsm

  11. Mapping the rows in the Database sheet.vtt

  11.2 88. Mapping_before.xlsm.xlsm

  12. In case you have any doubts about the Mapping exercise.vtt

  12.2 89. Mapping-exercise-explained.pdf.pdf

  13. Building the structure of the P&L sheet.mp4

  13.1 90. Building a P&L-Lecture-before.xlsm.xlsm

  14. Formatting sets You apart from the competition in Excel - A Practical Example.mp4

  14.1 91. Formatting a P&L-Lecture-before.xlsm.xlsm

  15. Populate the P&L sheet with SUMIF.mp4

  15.1 92. Formatting the P&L-Lecture-after.xlsm.xlsm

  16. Learn how to find mistakes with COUNTIF.mp4

  16.1 93. Countif-Lecture-after.xlsm.xlsm

  17. Calculating year-on-year percentage variations the proper way.mp4

  17.1 94. Adding % variations-Lecture-after.xlsm.xlsm

  17.3 Y-o-Y Function explanation.pdf.pdf

  2. Introduction to the case study.vtt

  3. Understand your data source before you start working on it.vtt

  4. Order the source worksheets.mp4

  4.1 81. Order a worksheet_before.xlsm.xlsm

  5. Create a code the best way to organize your data and work efficiently with it.mp4

  5.1 82. Creating a code_before.xlsm.xlsm

  6. Learn how to create a database.mp4

  6.1 83. Creating a database_after.xlsm.xlsm

  7. Use VLOOKUP to fill the Database sheet.mp4

  7.1 84. Vlookup_before.xlsm.xlsm

  8. 50% Completed!.mp4

  9. Use SUMIF to complete the Database sheet.mp4

  9.1 86. Sumif_after.xlsm.xlsm