Filename Size 1. Beginner to Pro in Excel Financial Modeling and Valuation - Welcome!/1. What does the course cover.mp4 8.9 MB 1. Beginner to Pro in Excel Financial Modeling and Valuation - Welcome!/1. What does the course cover.vtt 3.1 KB 1. Beginner to Pro in Excel Financial Modeling and Valuation - Welcome!/1.1 Course Notes - Beginner to Pro in Excel.pdf.pdf 19 MB 1. Beginner to Pro in Excel Financial Modeling and Valuation - Welcome!/2. Bonus! Welcome gift.html 164 B 1. Beginner to Pro in Excel Financial Modeling and Valuation - Welcome!/3. Welcome gift number 2.html 164 B 1. Beginner to Pro in Excel Financial Modeling and Valuation - Welcome!/4. The best way to take this course.mp4 20.2 MB 1. Beginner to Pro in Excel Financial Modeling and Valuation - Welcome!/4. The best way to take this course.vtt 2.5 KB 1. Beginner to Pro in Excel Financial Modeling and Valuation - Welcome!/5. Download all course materials.html 775 B 10. Introduction to Excel charts/1. How to insert a chart in Excel.mp4 22.3 MB 10. Introduction to Excel charts/1. How to insert a chart in Excel.vtt 2.6 KB 10. Introduction to Excel charts/1.1 95. Inserting-Charts-Lecture.xlsm.xlsm 11.4 MB 10. Introduction to Excel charts/2. Editing Excel charts.mp4 26.1 MB 10. Introduction to Excel charts/2. Editing Excel charts.vtt 2.9 KB 10. Introduction to Excel charts/2.1 96. Formatting-a-Chart-Lecture.xlsm.xlsm 11.5 MB 10. Introduction to Excel charts/3. Excel chart formatting.mp4 32.7 MB 10. Introduction to Excel charts/3. Excel chart formatting.vtt 3.4 KB 10. Introduction to Excel charts/3.1 97. Modifying-a-Chart-Lecture.xlsm.xlsm 11.4 MB 10. Introduction to Excel charts/4. How to create a bridge chart in Excel.mp4 13.7 MB 10. Introduction to Excel charts/4. How to create a bridge chart in Excel.vtt 1.9 KB 10. Introduction to Excel charts/4.1 98. Bridge-Charts-Lecture.xlsx.xlsx 13.1 KB 10. Introduction to Excel charts/5. New ways to visualize your data - Treemap charts.mp4 11.5 MB 10. Introduction to Excel charts/5. New ways to visualize your data - Treemap charts.vtt 1.7 KB 10. Introduction to Excel charts/5.1 99. Treemap-Charts-Lecture.xlsx.xlsx 12.6 KB 10. Introduction to Excel charts/6. Sparklines.mp4 27.6 MB 10. Introduction to Excel charts/6. Sparklines.vtt 4.2 KB 10. Introduction to Excel charts/6.1 100. Sparklines-Lecture.xlsx.xlsx 9.6 KB 11/1. Create professional and good-looking charts - Introduction.mp4 6.2 MB 11/1. Create professional and good-looking charts - Introduction.vtt 727 B 11/2. Build a column stacked chart with a secondary line axis in Excel.mp4 46.4 MB 11/2. Build a column stacked chart with a secondary line axis in Excel.vtt 5.6 KB 11/2.1 102. Column stacked chart-Lecture-before.xlsm.xlsm 11.5 MB 11/2.2 102. Column stacked chart-Lecture-after.xlsm.xlsm 11.5 MB 11/3. Learn how to build effective doughnut charts in Excel.mp4 38 MB 11/3. Learn how to build effective doughnut charts in Excel.vtt 5.4 KB 11/3.1 103. Doughnut chart-Lecture-after.xlsm.xlsm 11.5 MB 11/3.2 103. Doughnut chart-Lecture-before.xlsm.xlsm 11.5 MB 11/4. Learn how to build an area chart in Excel.mp4 28.6 MB 11/4. Learn how to build an area chart in Excel.vtt 3.5 KB 11/4.1 104. Area chart-Lecture-after.xlsm.xlsm 11.5 MB 11/4.2 104. Area chart-Lecture-before.xlsm.xlsm 11.5 MB 11/5. Learn how to create bridge charts.mp4 52.1 MB 11/5. Learn how to create bridge charts.vtt 7.5 KB 11/5.1 105. Bridge chart-Lecture-after.xlsm.xlsm 11.5 MB 11/5.2 105. Bridge chart-Lecture-before.xlsm.xlsm 11.5 MB 11/6. Learn how to create bridge charts in Excel 2007, 2010, and 2013.mp4 136.1 MB 11/6. Learn how to create bridge charts in Excel 2007, 2010, and 2013.vtt 11.7 KB 11/7. Case Study - Building a Complete P&L from scratch in Excel.html 159 B 11/8. Course Challenge - Apply your skills in practice!.mp4 7.9 MB 11/8. Course Challenge - Apply your skills in practice!.vtt 1.2 KB 11/8.1 107. Course-Challenge - Solved.xlsx.xlsx 543.9 KB 11/8.2 107. Course-Challenge - Unsolved.xlsx.xlsx 505.5 KB 12. Case Study - Building an FMCG Model from Scratch/1. Introduction to the Case Study.mp4 12.1 MB 12. Case Study - Building an FMCG Model from Scratch/1. Introduction to the Case Study.vtt 2.4 KB 12. Case Study - Building an FMCG Model from Scratch/1.1 108. Exercise-Build-an-FMCG-Model-Lecture-before.xlsx.xlsx 13.3 MB 12. Case Study - Building an FMCG Model from Scratch/10. Combining Slicers and GETPIVOTDATA The key to our success.mp4 17.8 MB 12. Case Study - Building an FMCG Model from Scratch/10. Combining Slicers and GETPIVOTDATA The key to our success.vtt 3.4 KB 12. Case Study - Building an FMCG Model from Scratch/10.1 117. Exercise-Build-an-FMCG-Model-Inserting-Slicers-Lecture.xlsx.xlsx 20.8 MB 12. Case Study - Building an FMCG Model from Scratch/11. Getting fancy with Excel slicers - Good-looking Excel slicers.mp4 17.1 MB 12. Case Study - Building an FMCG Model from Scratch/11. Getting fancy with Excel slicers - Good-looking Excel slicers.vtt 3.4 KB 12. Case Study - Building an FMCG Model from Scratch/11.1 118. Exercise-Build-an-FMCG-Model-Complete-Lecture.xlsx.xlsx 22.8 MB 12. Case Study - Building an FMCG Model from Scratch/12. This is how the report can be used in practice by high-level executives.mp4 19.8 MB 12. Case Study - Building an FMCG Model from Scratch/12. This is how the report can be used in practice by high-level executives.vtt 4.4 KB 12. Case Study - Building an FMCG Model from Scratch/12.1 119. Exercise-Build-an-FMCG-Model-Complete.xlsx.xlsx 22.8 MB 12. Case Study - Building an FMCG Model from Scratch/13. Dynamic reporting with GETPIVOTDATA and slicers.html 163 B 12. Case Study - Building an FMCG Model from Scratch/2. Preliminary mapping of the data extraction.mp4 22.6 MB 12. Case Study - Building an FMCG Model from Scratch/2. Preliminary mapping of the data extraction.vtt 2.4 KB 12. Case Study - Building an FMCG Model from Scratch/2.1 109. Exercise-Build-an-FMCG-Model-Mapping-Lecture.xlsx.xlsx 14.9 MB 12. Case Study - Building an FMCG Model from Scratch/3. Working with an SAP data extraction.mp4 22 MB 12. Case Study - Building an FMCG Model from Scratch/3. Working with an SAP data extraction.vtt 3.8 KB 12. Case Study - Building an FMCG Model from Scratch/4. Creating an output structure of the FMCG model.mp4 11.7 MB 12. Case Study - Building an FMCG Model from Scratch/4. Creating an output structure of the FMCG model.vtt 2.8 KB 12. Case Study - Building an FMCG Model from Scratch/4.1 111. Exercise-Build-an-FMCG-Model-Structure-Lecture.xlsx.xlsx 14.9 MB 12. Case Study - Building an FMCG Model from Scratch/5. Improving the layout and appearance of the FMCG report.mp4 13.5 MB 12. Case Study - Building an FMCG Model from Scratch/5. Improving the layout and appearance of the FMCG report.vtt 4.6 KB 12. Case Study - Building an FMCG Model from Scratch/5.1 112. Exercise-Build-an-FMCG-Model-Formatting-Lecture.xlsx.xlsx 14.9 MB 12. Case Study - Building an FMCG Model from Scratch/6. Inserting formulas and automating calculations.mp4 8.8 MB 12. Case Study - Building an FMCG Model from Scratch/6. Inserting formulas and automating calculations.vtt 4.6 KB 12. Case Study - Building an FMCG Model from Scratch/6.1 113. Exercise-Build-an-FMCG-Model-Adding-Calculations-Lecture.xlsx.xlsx 14.9 MB 12. Case Study - Building an FMCG Model from Scratch/7. Creating a Master Pivot Table The main data source for the FMCG report.mp4 13.8 MB 12. Case Study - Building an FMCG Model from Scratch/7. Creating a Master Pivot Table The main data source for the FMCG report.vtt 2.1 KB 12. Case Study - Building an FMCG Model from Scratch/7.1 114. Exercise-Build-an-FMCG-Model-Creating-a-Pivot-Table-Lecture.xlsx.xlsx 20.8 MB 12. Case Study - Building an FMCG Model from Scratch/8. GETPIVOTDATA is great! Extracting data from the Master Pivot Table.mp4 31 MB 12. Case Study - Building an FMCG Model from Scratch/8. GETPIVOTDATA is great! Extracting data from the Master Pivot Table.vtt 6.7 KB 12. Case Study - Building an FMCG Model from Scratch/8.1 115. Exercise-Build-an-FMCG-Model-GETPIVOTDATA-Lecture.xlsx.xlsx 20.8 MB 12. Case Study - Building an FMCG Model from Scratch/9. A potential error with GETPIVOTDATA you might encounter and its fix.mp4 13.8 MB 12. Case Study - Building an FMCG Model from Scratch/9. A potential error with GETPIVOTDATA you might encounter and its fix.vtt 1.5 KB 13. Financial Modeling Fundamentals/1. Financial Modeling basics - Welcome lecture.mp4 2.1 MB 13. Financial Modeling Fundamentals/1. Financial Modeling basics - Welcome lecture.vtt 1.1 KB 13. Financial Modeling Fundamentals/10. Forecasting financials - Quiz.html 160 B 13. Financial Modeling Fundamentals/11. Building a complete model - Important considerations.mp4 6.4 MB 13. Financial Modeling Fundamentals/11. Building a complete model - Important considerations.vtt 2.7 KB 13. Financial Modeling Fundamentals/12. Modeling the Income statement.mp4 12.4 MB 13. Financial Modeling Fundamentals/12. Modeling the Income statement.vtt 7 KB 13. Financial Modeling Fundamentals/13. Modeling the Balance sheet - Part 1.mp4 5.2 MB 13. Financial Modeling Fundamentals/13. Modeling the Balance sheet - Part 1.vtt 3.2 KB 13. Financial Modeling Fundamentals/14. Modeling the Balance sheet - Part 2.mp4 9.4 MB 13. Financial Modeling Fundamentals/14. Modeling the Balance sheet - Part 2.vtt 5.7 KB 13. Financial Modeling Fundamentals/15. Building a financial model - Quiz.html 160 B 13. Financial Modeling Fundamentals/2. What is a financial model.mp4 4.6 MB