TC4S:\2022_3\The Complete Financial Analyst Course\10. Pivot Tables & Slicers in Practice - World-Class Financial Reporting Shown Here |
 Up one directory... |
|
|
 1. Introduction to the Case Study.mp4 | 27,384 KB | 4/21/2019 1:02 PM |
| 1. Introduction to the Case Study.vtt | 3 KB | 4/21/2019 12:45 PM |
| 1.1 0. Exercise - Build an FMCG Model_before.xlsx.xlsx | 13,578 KB | 4/21/2019 1:09 PM |
| 10. Combining Slicers and GetPivotData The key to our success.mp4 | 37,283 KB | 4/21/2019 1:12 PM |
| 10. Combining Slicers and GetPivotData The key to our success.vtt | 4 KB | 4/21/2019 1:08 PM |
| 10.1 8. Exercise - Build an FMCG Model_Inserting Slicers.xlsx.xlsx | 21,275 KB | 4/21/2019 1:11 PM |
| 11. Getting fancy with Excel slicers.mp4 | 36,671 KB | 4/21/2019 1:04 PM |
| 11. Getting fancy with Excel slicers.vtt | 4 KB | 4/21/2019 12:48 PM |
| 11.1 10. Exercise - Build an FMCG Model_Complete.xlsx.xlsx | 23,368 KB | 4/21/2019 1:13 PM |
| 12. This is how the report can be used in practice by high-level executives.mp4 | 41,822 KB | 4/21/2019 1:12 PM |
| 12. This is how the report can be used in practice by high-level executives.vtt | 5 KB | 4/21/2019 1:00 PM |
| 12.1 10. Exercise - Build an FMCG Model_Complete.xlsx.xlsx | 23,358 KB | 4/21/2019 1:10 PM |
| 2. Working with an SAP data extraction.mp4 | 40,133 KB | 4/21/2019 1:11 PM |
| 2. Working with an SAP data extraction.vtt | 4 KB | 4/21/2019 1:06 PM |
| 3. Preliminary mapping of the data extraction.mp4 | 31,921 KB | 4/21/2019 1:11 PM |
| 3. Preliminary mapping of the data extraction.vtt | 3 KB | 4/21/2019 12:45 PM |
| 3.1 1. Exercise - Build an FMCG Model_Mapping.xlsx.xlsx | 15,248 KB | 4/21/2019 1:10 PM |
| 4. Creating an output structure of the FMCG model.mp4 | 22,712 KB | 4/21/2019 1:11 PM |
| 4. Creating an output structure of the FMCG model.vtt | 3 KB | 4/21/2019 12:31 PM |
| 4.1 2. Exercise - Build an FMCG Model_Structure.xlsx.xlsx | 15,272 KB | 4/21/2019 1:03 PM |
| 5. Improving the layout and appearance of the FMCG report.mp4 | 27,784 KB | 4/21/2019 1:07 PM |
| 5. Improving the layout and appearance of the FMCG report.vtt | 5 KB | 4/21/2019 12:57 PM |
| 5.1 3. Exercise - Build an FMCG Model_Formatting.xlsx.xlsx | 15,272 KB | 4/21/2019 12:57 PM |
| 6. Inserting formulas and automating calculations.mp4 | 18,527 KB | 4/21/2019 1:08 PM |
| 6. Inserting formulas and automating calculations.vtt | 3 KB | 4/21/2019 12:45 PM |
| 6.1 4. Exercise - Build an FMCG Model_Adding Calculations.xlsx.xlsx | 15,272 KB | 4/21/2019 12:58 PM |
| 7. Creating a Master Pivot Table The main data source for the FMCG report.mp4 | 22,308 KB | 4/21/2019 1:12 PM |
| 7. Creating a Master Pivot Table The main data source for the FMCG report.vtt | 3 KB | 4/21/2019 1:04 PM |
| 7.1 5. Exercise - Build an FMCG Model_Creating a Pivot Table.xlsx.xlsx | 21,307 KB | 4/21/2019 1:11 PM |
| 8. GetPivotData is great! Extracting data from the Master Pivot Table.mp4 | 55,466 KB | 4/21/2019 1:12 PM |
| 8. GetPivotData is great! Extracting data from the Master Pivot Table.vtt | 7 KB | 4/21/2019 1:09 PM |
| 8.1 6. Exercise - Build an FMCG Model_GETPIVOTDATA.xlsx.xlsx | 21,308 KB | 4/21/2019 1:13 PM |
| 9. GetPivotData fix.mp4 | 13,947 KB | 4/21/2019 1:09 PM |
| 9. GetPivotData fix.vtt | 2 KB | 4/21/2019 12:51 PM |
