Filename Size 1. Welcome! Course Introduction/1. What Does the Course Cover.mp4 78.2 MB 1. Welcome! Course Introduction/1. What Does the Course Cover.vtt 7.3 KB 1. Welcome! Course Introduction/1.1 Financial Analyst - Course Curriculum.pdf.pdf 581.4 KB 1. Welcome! Course Introduction/2. Everything We Will Learn Has a Practical Application.mp4 25.7 MB 1. Welcome! Course Introduction/2. Everything We Will Learn Has a Practical Application.vtt 3.5 KB 1. Welcome! Course Introduction/2.1 Quick win.xlsx.xlsx 9.7 KB 1. Welcome! Course Introduction/3. The Best Way to Take This Course.mp4 31.9 MB 1. Welcome! Course Introduction/3. The Best Way to Take This Course.vtt 3.3 KB 1. Welcome! Course Introduction/4. Download All Course Materials.html 903 B 1. Welcome! Course Introduction/4.1 Download all course materials.html 134 B 10. Microsoft Excel - Working with Pivot Tables in Excel/1. Pivot Tables - Excel's Dynamic and Interactive Tables.mp4 15.1 MB 10. Microsoft Excel - Working with Pivot Tables in Excel/1. Pivot Tables - Excel's Dynamic and Interactive Tables.vtt 2 KB 10. Microsoft Excel - Working with Pivot Tables in Excel/2. Creating a Pivot Table Choosing Row and Column Parameters.mp4 38.9 MB 10. Microsoft Excel - Working with Pivot Tables in Excel/2. Creating a Pivot Table Choosing Row and Column Parameters.vtt 4 KB 10. Microsoft Excel - Working with Pivot Tables in Excel/2.1 87. Creating-a-Pivot-Table-Lecture.xlsx.xlsx 1.4 MB 10. Microsoft Excel - Working with Pivot Tables in Excel/3. Design the Layout and Format of Your Pivot Tables.mp4 21.5 MB 10. Microsoft Excel - Working with Pivot Tables in Excel/3. Design the Layout and Format of Your Pivot Tables.vtt 2 KB 10. Microsoft Excel - Working with Pivot Tables in Excel/3.1 88. Formatting-a-Pivot-Table-Lecture.xlsx.xlsx 1.4 MB 10. Microsoft Excel - Working with Pivot Tables in Excel/4. Additional Techniques That Will Ease Your Work with Pivot Tables.mp4 46 MB 10. Microsoft Excel - Working with Pivot Tables in Excel/4. Additional Techniques That Will Ease Your Work with Pivot Tables.vtt 4.4 KB 10. Microsoft Excel - Working with Pivot Tables in Excel/4.1 89. Working-with-Pivot-Tables-Lecture.xlsx.xlsx 1.9 MB 10. Microsoft Excel - Working with Pivot Tables in Excel/5. One of the Most Useful Excel Functions - GetPivotData.mp4 36.3 MB 10. Microsoft Excel - Working with Pivot Tables in Excel/5. One of the Most Useful Excel Functions - GetPivotData.vtt 4 KB 10. Microsoft Excel - Working with Pivot Tables in Excel/5.1 90. GetPivotData-Lecture.xlsx.xlsx 1.9 MB 10. Microsoft Excel - Working with Pivot Tables in Excel/6. Welcome to the Future - Pivot Table Slicers.mp4 45.2 MB 10. Microsoft Excel - Working with Pivot Tables in Excel/6. Welcome to the Future - Pivot Table Slicers.vtt 4.1 KB 10. Microsoft Excel - Working with Pivot Tables in Excel/6.1 91. Slicers-Lecture.xlsx.xlsx 1.9 MB 10. Microsoft Excel - Working with Pivot Tables in Excel/7. Introduction to the Course Challenge.mp4 13.2 MB 10. Microsoft Excel - Working with Pivot Tables in Excel/7. Introduction to the Course Challenge.vtt 1.4 KB 10. Microsoft Excel - Working with Pivot Tables in Excel/8. COURSE CHALLENGE - Part 1.mp4 14.4 MB 10. Microsoft Excel - Working with Pivot Tables in Excel/8. COURSE CHALLENGE - Part 1.vtt 1.6 KB 10. Microsoft Excel - Working with Pivot Tables in Excel/8.1 93. Course-Challenge - Before solutions.xlsx.xlsx 505.5 KB 11/1. Introduction to the Case Study.mp4 26.7 MB 11/1. Introduction to the Case Study.vtt 2.4 KB 11/1.1 94. Exercise-Build-an-FMCG-Model-Lecture-before.xlsx.xlsx 13.3 MB 11/10. Combining Slicers and GETPIVOTDATA The Key to Our Success.mp4 36.4 MB 11/10. Combining Slicers and GETPIVOTDATA The Key to Our Success.vtt 3.3 KB 11/10.1 103. Exercise-Build-an-FMCG-Model-Inserting-Slicers-Lecture.xlsx.xlsx 20.8 MB 11/11. Getting Fancy with Excel Slicers.mp4 35.8 MB 11/11. Getting Fancy with Excel Slicers.vtt 3.3 KB 11/11.1 104. Exercise-Build-an-FMCG-Model-Complete-Lecture.xlsx.xlsx 22.8 MB 11/12. This is How the Report Can be Used in Practice by High-level Executives.mp4 40.8 MB 11/12. This is How the Report Can be Used in Practice by High-level Executives.vtt 4.6 KB 11/12.1 105. Exercise-Build-an-FMCG-Model-Complete.xlsx.xlsx 22.8 MB 11/2. Working with an SAP Data Extraction.mp4 39.2 MB 11/2. Working with an SAP Data Extraction.vtt 3.6 KB 11/3. Preliminary Mapping of the Data Extraction.mp4 31.2 MB 11/3. Preliminary Mapping of the Data Extraction.vtt 2.4 KB 11/3.1 96. Exercise-Build-an-FMCG-Model-Mapping-Lecture.xlsx.xlsx 14.9 MB 11/4. Creating an Output Structure of the FMCG Model.mp4 22.2 MB 11/4. Creating an Output Structure of the FMCG Model.vtt 2.5 KB 11/4.1 97. Exercise-Build-an-FMCG-Model-Structure-Lecture.xlsx.xlsx 14.9 MB 11/5. Improving the Layout and Appearance of the FMCG Report.mp4 27.1 MB 11/5. Improving the Layout and Appearance of the FMCG Report.vtt 4 KB 11/5.1 98. Exercise-Build-an-FMCG-Model-Formatting-Lecture.xlsx.xlsx 14.9 MB 11/6. Inserting Formulas and Automating Calculations.mp4 18.1 MB 11/6. Inserting Formulas and Automating Calculations.vtt 2.4 KB 11/6.1 99. Exercise-Build-an-FMCG-Model-Adding-Calculations-Lecture.xlsx.xlsx 14.9 MB 11/7. Creating a Master Pivot Table The Main Data Source for the FMCG Report.mp4 21.8 MB 11/7. Creating a Master Pivot Table The Main Data Source for the FMCG Report.vtt 2 KB 11/7.1 100. Exercise-Build-an-FMCG-Model-Creating-a-Pivot-Table-Lecture.xlsx.xlsx 20.8 MB 11/8. GETPIVOTDATA is Great! Extracting Data from the Master Pivot Table.mp4 54.2 MB 11/8. GETPIVOTDATA is Great! Extracting Data from the Master Pivot Table.vtt 6.7 KB 11/8.1 101. Exercise-Build-an-FMCG-Model-GETPIVOTDATA-Lecture.xlsx.xlsx 20.8 MB 11/9. GETPIVOTDATA fix.mp4 13.6 MB 11/9. GETPIVOTDATA fix.vtt 1.4 KB 12. Modeling in Excel - Building a Complete 3-statement Model/1. Introduction to the Exercise.mp4 36.6 MB 12. Modeling in Excel - Building a Complete 3-statement Model/1. Introduction to the Exercise.vtt 3.2 KB 12. Modeling in Excel - Building a Complete 3-statement Model/1.1 Financial Modeling Notes.pdf.pdf 690.1 KB 12. Modeling in Excel - Building a Complete 3-statement Model/1.2 106. Exercise-after.xlsx.xlsx 32.7 KB 12. Modeling in Excel - Building a Complete 3-statement Model/1.3 106. Exerxise-before.xlsx.xlsx 18.7 KB 12. Modeling in Excel - Building a Complete 3-statement Model/2. Let's Create a Mapping of Financials.mp4 30.7 MB 12. Modeling in Excel - Building a Complete 3-statement Model/2. Let's Create a Mapping of Financials.vtt 2.8 KB 12. Modeling in Excel - Building a Complete 3-statement Model/2.1 107. Exercise - after.xlsx.xlsx 34.2 KB 12. Modeling in Excel - Building a Complete 3-statement Model/2.2 107. Exercise - before.xlsx.xlsx 30.5 KB 12. Modeling in Excel - Building a Complete 3-statement Model/3. Building an Output P&L Sheet.mp4 30.5 MB 12. Modeling in Excel - Building a Complete 3-statement Model/3. Building an Output P&L Sheet.vtt 4 KB 12. Modeling in Excel - Building a Complete 3-statement Model/3.1 108. Exercise - before.xlsx.xlsx 32.4 KB 12. Modeling in Excel - Building a Complete 3-statement Model/3.2 108. Exercise - after.xlsx.xlsx 41.5 KB 12. Modeling in Excel - Building a Complete 3-statement Model/4. Filling in the Output P&L Sheet with Historical Financials.mp4 23.9 MB 12. Modeling in Excel - Building a Complete 3-statement Model/4. Filling in the Output P&L Sheet with Historical Financials.vtt 2.9 KB 12. Modeling in Excel - Building a Complete 3-statement Model/4.1 109. Exersice - after.xlsx.xlsx 41.3 KB 12. Modeling in Excel - Building a Complete 3-statement Model/4.2 109. Exersice - before.xlsx.xlsx 37.6 KB 12. Modeling in Excel - Building a Complete 3-statement Model/5. Calculating Percentage Variances and Applying Conditional Formatting.mp4 27.2 MB 12. Modeling in Excel - Building a Complete 3-statement Model/5. Calculating Percentage Variances and Applying Conditional Formatting.vtt 3.2 KB 12. Modeling in Excel - Building a Complete 3-statement Model/5.1 110. Exercise - after.xlsx.xlsx 41.7 KB 12. Modeling in Excel - Building a Complete 3-statement Model/5.2 110. Exercise - before.xlsx.xlsx 39.3 KB 12. Modeling in Excel - Building a Complete 3-statement Model/6. Building an Output Balance Sheet.mp4 29.5 MB 12. Modeling in Excel - Building a Complete 3-statement Model/6. Building an Output Balance Sheet.vtt 3.7 KB 12. Modeling in Excel - Building a Complete 3-statement Model/6.1 111. Exercise - before.xlsx.xlsx 47.5 KB 12. Modeling in Excel - Building a Complete 3-statement Model/6.2 111. Exercise - after.xlsx.xlsx 54.4 KB 12. Modeling in Excel - Building a Complete 3-statement Model/7. Using INDEX, MATCH, MATCH to Fill in the output Balance Sheet.mp4 43.5 MB 12. Modeling in Excel - Building a Complete 3-statement Model/7. Using INDEX, MATCH, MATCH to Fill in the output Balance Sheet.vtt 5.3 KB 12. Modeling in Excel - Building a Complete 3-statement Model/7.1 112. Exersice - before.xlsx.xlsx 49.8 KB 12. Modeling in Excel - Building a Complete 3-statement Model/7.2 112. Exersise - after.xlsx.xlsx 57.1 KB 12. Modeling in Excel - Building a Complete 3-statement Model/8. Adding the Forecast Period.mp4 32.1 MB 12. Modeling in Excel - Building a Complete 3-statement Model/8. Adding the Forecast Period.vtt 3.8 KB 12. Modeling in Excel - Building a Complete 3-statement Model/8.1 113. Exersice - after.xlsx.xlsx 55 KB 12. Modeling in Excel - Building a Complete 3-statement Model/8.2 113. Exersice - before.xlsx.xlsx 50.3 KB