1. Welcome! Course Introduction/3. The Best Way to Take This Course.mp4
31.2 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
10. Pivot Tables & Slicers in Practice - World-Class Financial Reporting Shown Here/1. Introduction to the Case Study.mp4
26.7 MB
10. Pivot Tables & Slicers in Practice - World-Class Financial Reporting Shown Here/1. Introduction to the Case Study.vtt
2.4 KB
10. Pivot Tables & Slicers in Practice - World-Class Financial Reporting Shown Here/1.1 0. Exercise - Build an FMCG Model_before.xlsx.xlsx
13.3 MB
10. Pivot Tables & Slicers in Practice - World-Class Financial Reporting Shown Here/10. Combining Slicers and GetPivotData The key to our success.mp4
36.4 MB
10. Pivot Tables & Slicers in Practice - World-Class Financial Reporting Shown Here/10. Combining Slicers and GetPivotData The key to our success.vtt
3.3 KB
10. Pivot Tables & Slicers in Practice - World-Class Financial Reporting Shown Here/10.1 8. Exercise - Build an FMCG Model_Inserting Slicers.xlsx.xlsx
20.8 MB
10. Pivot Tables & Slicers in Practice - World-Class Financial Reporting Shown Here/11. Getting fancy with Excel slicers.mp4
35.8 MB
10. Pivot Tables & Slicers in Practice - World-Class Financial Reporting Shown Here/11. Getting fancy with Excel slicers.vtt
3.3 KB
10. Pivot Tables & Slicers in Practice - World-Class Financial Reporting Shown Here/11.1 10. Exercise - Build an FMCG Model_Complete.xlsx.xlsx
22.8 MB
10. Pivot Tables & Slicers in Practice - World-Class Financial Reporting Shown Here/12. This is how the report can be used in practice by high-level executives.mp4
40.8 MB
10. Pivot Tables & Slicers in Practice - World-Class Financial Reporting Shown Here/12. This is how the report can be used in practice by high-level executives.vtt
4.6 KB
10. Pivot Tables & Slicers in Practice - World-Class Financial Reporting Shown Here/12.1 10. Exercise - Build an FMCG Model_Complete.xlsx.xlsx
22.8 MB
10. Pivot Tables & Slicers in Practice - World-Class Financial Reporting Shown Here/2. Working with an SAP data extraction.mp4
39.2 MB
10. Pivot Tables & Slicers in Practice - World-Class Financial Reporting Shown Here/2. Working with an SAP data extraction.vtt
3.6 KB
10. Pivot Tables & Slicers in Practice - World-Class Financial Reporting Shown Here/3. Preliminary mapping of the data extraction.mp4
31.2 MB
10. Pivot Tables & Slicers in Practice - World-Class Financial Reporting Shown Here/3. Preliminary mapping of the data extraction.vtt
2.4 KB
10. Pivot Tables & Slicers in Practice - World-Class Financial Reporting Shown Here/3.1 1. Exercise - Build an FMCG Model_Mapping.xlsx.xlsx
14.9 MB
10. Pivot Tables & Slicers in Practice - World-Class Financial Reporting Shown Here/4. Creating an output structure of the FMCG model.mp4
22.2 MB
10. Pivot Tables & Slicers in Practice - World-Class Financial Reporting Shown Here/4. Creating an output structure of the FMCG model.vtt
2.5 KB
10. Pivot Tables & Slicers in Practice - World-Class Financial Reporting Shown Here/4.1 2. Exercise - Build an FMCG Model_Structure.xlsx.xlsx
14.9 MB
10. Pivot Tables & Slicers in Practice - World-Class Financial Reporting Shown Here/5. Improving the layout and appearance of the FMCG report.mp4
27.1 MB
10. Pivot Tables & Slicers in Practice - World-Class Financial Reporting Shown Here/5. Improving the layout and appearance of the FMCG report.vtt
4 KB
10. Pivot Tables & Slicers in Practice - World-Class Financial Reporting Shown Here/5.1 3. Exercise - Build an FMCG Model_Formatting.xlsx.xlsx
14.9 MB
10. Pivot Tables & Slicers in Practice - World-Class Financial Reporting Shown Here/6. Inserting formulas and automating calculations.mp4
18.1 MB
10. Pivot Tables & Slicers in Practice - World-Class Financial Reporting Shown Here/6. Inserting formulas and automating calculations.vtt
2.4 KB
10. Pivot Tables & Slicers in Practice - World-Class Financial Reporting Shown Here/6.1 4. Exercise - Build an FMCG Model_Adding Calculations.xlsx.xlsx
14.9 MB
10. Pivot Tables & Slicers in Practice - World-Class Financial Reporting Shown Here/7. Creating a Master Pivot Table The main data source for the FMCG report.mp4
21.8 MB
10. Pivot Tables & Slicers in Practice - World-Class Financial Reporting Shown Here/7. Creating a Master Pivot Table The main data source for the FMCG report.vtt
2 KB
10. Pivot Tables & Slicers in Practice - World-Class Financial Reporting Shown Here/7.1 5. Exercise - Build an FMCG Model_Creating a Pivot Table.xlsx.xlsx
20.8 MB
10. Pivot Tables & Slicers in Practice - World-Class Financial Reporting Shown Here/8. GetPivotData is great! Extracting data from the Master Pivot Table.mp4
54.2 MB
10. Pivot Tables & Slicers in Practice - World-Class Financial Reporting Shown Here/8. GetPivotData is great! Extracting data from the Master Pivot Table.vtt
6.7 KB
10. Pivot Tables & Slicers in Practice - World-Class Financial Reporting Shown Here/8.1 6. Exercise - Build an FMCG Model_GETPIVOTDATA.xlsx.xlsx
20.8 MB
10. Pivot Tables & Slicers in Practice - World-Class Financial Reporting Shown Here/9. GetPivotData fix.mp4
13.6 MB
10. Pivot Tables & Slicers in Practice - World-Class Financial Reporting Shown Here/9. GetPivotData fix.vtt
1.4 KB
11. Modeling in Excel - Building a complete 3-statement model/1. Introduction to the Exercise.mp4
36.6 MB
11. Modeling in Excel - Building a complete 3-statement model/1. Introduction to the Exercise.vtt
3.2 KB
11. Modeling in Excel - Building a complete 3-statement model/1.1 Financial Modeling Notes.pdf.pdf
690.1 KB
11. Modeling in Excel - Building a complete 3-statement model/1.2 1.1_after.xlsx.xlsx
32.7 KB
11. Modeling in Excel - Building a complete 3-statement model/1.3 1.1_before.xlsx.xlsx
18.7 KB
11. Modeling in Excel - Building a complete 3-statement model/2. Let's create a mapping of financials.mp4
30.7 MB
11. Modeling in Excel - Building a complete 3-statement model/2. Let's create a mapping of financials.vtt
2.8 KB
11. Modeling in Excel - Building a complete 3-statement model/2.1 1.2_before.xlsx.xlsx
30.5 KB
11. Modeling in Excel - Building a complete 3-statement model/2.2 1.2_after.xlsx.xlsx
34.2 KB
11. Modeling in Excel - Building a complete 3-statement model/3. Building an output P&L sheet.mp4
30.5 MB
11. Modeling in Excel - Building a complete 3-statement model/3. Building an output P&L sheet.vtt
4 KB
11. Modeling in Excel - Building a complete 3-statement model/3.1 1.3_before.xlsx.xlsx
32.4 KB
11. Modeling in Excel - Building a complete 3-statement model/3.2 1.3_after.xlsx.xlsx
41.5 KB
11. Modeling in Excel - Building a complete 3-statement model/4. Filling in the output P&L sheet with historical financials.mp4
23.9 MB
11. Modeling in Excel - Building a complete 3-statement model/4. Filling in the output P&L sheet with historical financials.vtt
2.9 KB
11. Modeling in Excel - Building a complete 3-statement model/4.1 1.4_before.xlsx.xlsx
37.6 KB
11. Modeling in Excel - Building a complete 3-statement model/4.2 1.4_after.xlsx.xlsx
41.3 KB
11. Modeling in Excel - Building a complete 3-statement model/5. Calculating percentage variances and applying conditional formatting.mp4
27.2 MB
11. Modeling in Excel - Building a complete 3-statement model/5. Calculating percentage variances and applying conditional formatting.vtt
3.2 KB
11. Modeling in Excel - Building a complete 3-statement model/5.1 1.5_before.xlsx.xlsx
39.3 KB
11. Modeling in Excel - Building a complete 3-statement model/5.2 1.5_after.xlsx.xlsx
41.7 KB
11. Modeling in Excel - Building a complete 3-statement model/6. Building an output Balance sheet.mp4
29.5 MB
11. Modeling in Excel - Building a complete 3-statement model/6. Building an output Balance sheet.vtt
3.7 KB
11. Modeling in Excel - Building a complete 3-statement model/6.1 1.6_after.xlsx.xlsx
54.4 KB
11. Modeling in Excel - Building a complete 3-statement model/6.2 1.6_before.xlsx.xlsx
47.5 KB
11. 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
11. 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
11. Modeling in Excel - Building a complete 3-statement model/7.1 1.7_after.xlsx.xlsx
57.1 KB
11. Modeling in Excel - Building a complete 3-statement model/7.2 1.7_before.xlsx.xlsx
49.8 KB
11. Modeling in Excel - Building a complete 3-statement model/8. Adding the forecast period.mp4
32.1 MB
11. Modeling in Excel - Building a complete 3-statement model/8. Adding the forecast period.vtt
3.8 KB
11. Modeling in Excel - Building a complete 3-statement model/8.1 1.8_before.xlsx.xlsx
50.3 KB
11. Modeling in Excel - Building a complete 3-statement model/8.2 1.8_after.xlsx.xlsx
55 KB
12. Modeling in Excel - Let's build a flexible model with multiple scenarios/1. Calculating historical percentage ratios and use Index and Match for scenarios.mp4
49.4 MB
12. Modeling in Excel - Let's build a flexible model with multiple scenarios/1. Calculating historical percentage ratios and use Index and Match for scenarios.vtt
5.3 KB
12. Modeling in Excel - Let's build a flexible model with multiple scenarios/1.1 1.9_before.xlsx.xlsx
52.8 KB
12. Modeling in Excel - Let's build a flexible model with multiple scenarios/1.2 1.9_after.xlsx.xlsx
54.9 KB
12. Modeling in Excel - Let's build a flexible model with multiple scenarios/2. Building a flexible model with Choose & Match.mp4
16.1 MB
12. Modeling in Excel - Let's build a flexible model with multiple scenarios/2. Building a flexible model with Choose & Match.vtt
1.7 KB
12. Modeling in Excel - Let's build a flexible model with multiple scenarios/2.1 1.10_before.xlsx.xlsx
53.1 KB
12. Modeling in Excel - Let's build a flexible model with multiple scenarios/2.2 1.10_after.xlsx.xlsx
54.7 KB
12. Modeling in Excel - Let's build a flexible model with multiple scenarios/3. Building a flexible model with Vlookup & Columns.mp4
36.3 MB
12. Modeling in Excel - Let's build a flexible model with multiple scenarios/3. Building a flexible model with Vlookup & Columns.vtt
3.4 KB
12. Modeling in Excel - Let's build a flexible model with multiple scenarios/3.1 1.11_before.xlsx.xlsx
53.1 KB
12. Modeling in Excel - Let's build a flexible model with multiple scenarios/3.2 1.11_after.xlsx.xlsx
55.1 KB
12. Modeling in Excel - Let's build a flexible model with multiple scenarios/4. Calculating historical DSO, DPO, DIO, Other assets %, and Other liabilities %.mp4
44.5 MB
12. Modeling in Excel - Let's build a flexible model with multiple scenarios/4. Calculating historical DSO, DPO, DIO, Other assets %, and Other liabilities %.vtt
5.3 KB
12. Modeling in Excel - Let's build a flexible model with multiple scenarios/4.1 1.12_before.xlsx.xlsx
53.6 KB
12. Modeling in Excel - Let's build a flexible model with multiple scenarios/4.2 Course notes - Building a financial model.pdf.pdf
575.2 KB
12. Modeling in Excel - Let's build a flexible model with multiple scenarios/4.3 1.12_after.xlsx.xlsx
56.6 KB
12. Modeling in Excel - Let's build a flexible model with multiple scenarios/5. Forecasting DSO, DPO, DIO, Other assets and Other liabilities.mp4
30.5 MB
12. Modeling in Excel - Let's build a flexible model with multiple scenarios/5. Forecasting DSO, DPO, DIO, Other assets and Other liabilities.vtt
3.3 KB
12. Modeling in Excel - Let's build a flexible model with multiple scenarios/5.1 1.13_after.xlsx.xlsx
57.7 KB
12. Modeling in Excel - Let's build a flexible model with multiple scenarios/5.2 1.13_before.xlsx.xlsx
54.6 KB
13. Modeling in Excel - We are almost there! Completing the 3-statement model/1. Building a Fixed asset roll forward.mp4
40.9 MB
13. Modeling in Excel - We are almost there! Completing the 3-statement model/1. Building a Fixed asset roll forward.vtt