TC4S:\2022_3\The Complete Financial Analyst Course\7. Microsoft Excel - Practical Exercise Build a P&L From Scratch |
 Up one directory... |
|
|
 1. Introduction to the Case Study.mp4 | 10,054 KB | 4/21/2019 1:03 PM |
| 10. The Mapping Exercise.mp4 | 22,139 KB | 4/21/2019 1:12 PM |
| 10.1 10a. Mapping_before.xlsm.xlsm | 52 KB | 4/21/2019 1:04 PM |
| 10.2 10a. Mapping.xlsm.xlsm | 52 KB | 4/21/2019 1:04 PM |
| 11. Mapping the Rows in the Database Sheet.mp4 | 33,381 KB | 4/21/2019 1:06 PM |
| 11.1 10. Mapping_before.xlsm.xlsm | 50 KB | 4/21/2019 12:51 PM |
| 11.2 10. Mapping_after.xlsm.xlsm | 51 KB | 4/21/2019 12:51 PM |
| 12. Building the Structure of the P&L Sheet.mp4 | 21,372 KB | 4/21/2019 1:11 PM |
| 12.1 11. Building a P&L_before.xlsm.xlsm | 51 KB | 4/21/2019 12:49 PM |
| 12.2 11. Building a P&L_after.xlsm.xlsm | 52 KB | 4/21/2019 12:49 PM |
| 13. A Practical Example of Professional Formatting in Excel.mp4 | 26,029 KB | 4/21/2019 1:09 PM |
| 13.1 12. Formatting a P&L_before.xlsm.xlsm | 52 KB | 4/21/2019 12:55 PM |
| 13.2 12. Formatting the P&L_after.xlsm.xlsm | 52 KB | 4/21/2019 12:55 PM |
| 14. Populate the P&L Sheet with Sumif.mp4 | 30,959 KB | 4/21/2019 1:13 PM |
| 14.1 13. Formatting the P&L_before.xlsm.xlsm | 52 KB | 4/21/2019 12:53 PM |
| 14.2 13. Formatting the P&L_after.xlsm.xlsm | 54 KB | 4/21/2019 12:53 PM |
| 15. Learn How to Find Mistakes with Countif.mp4 | 28,514 KB | 4/21/2019 1:13 PM |
| 15.1 14. Countif_after.xlsm.xlsm | 55 KB | 4/21/2019 12:43 PM |
| 15.2 14. Countif_before.xlsm.xlsm | 54 KB | 4/21/2019 12:43 PM |
| 16. Calculating Growth Rates in Excel.mp4 | 30,701 KB | 4/21/2019 1:09 PM |
| 16.1 Y-o-Y Function explanation.pdf.pdf | 165 KB | 4/21/2019 12:51 PM |
| 16.2 15. Adding % variations_before.xlsm.xlsm | 55 KB | 4/21/2019 12:51 PM |
| 16.3 15. Adding % variations_after.xlsm.xlsm | 57 KB | 4/21/2019 12:51 PM |
| 17. Quiz Number 3.html | 1 KB | 4/21/2019 12:51 PM |
| 2. What You Will See Next.mp4 | 10,453 KB | 4/21/2019 12:55 PM |
| 3. Understand Your Data Source Before You Start Working on It.mp4 | 28,790 KB | 4/21/2019 1:08 PM |
| 3.1 3. Get to know the data source.xlsm.xlsm | 44 KB | 4/21/2019 1:01 PM |
| 4. Ordering the Source Worksheet.mp4 | 27,204 KB | 4/21/2019 1:10 PM |
| 4.1 4. Order a worksheet_after.xlsm.xlsm | 42 KB | 4/21/2019 12:58 PM |
| 4.2 4. Order a worksheet_before.xlsm.xlsm | 44 KB | 4/21/2019 12:58 PM |
| 5. Create a Code The Best Way to Organize Your Data and Work Efficiently with It.mp4 | 25,097 KB | 4/21/2019 1:00 PM |
| 5.1 5. Creating a code_before.xlsm.xlsm | 42 KB | 4/21/2019 1:00 PM |
| 5.2 5. Creating a code_after.xlsm.xlsm | 42 KB | 4/21/2019 1:00 PM |
| 6. Learn How to Create a Database.mp4 | 21,238 KB | 4/21/2019 1:10 PM |
| 6.1 6. Creating a database_before.xlsm.xlsm | 42 KB | 4/21/2019 1:00 PM |
| 6.2 6. Creating a database_after.xlsm.xlsm | 40 KB | 4/21/2019 1:00 PM |
| 7. Using Lookup Functions (Vlookup) to Fill the Database Sheet.mp4 | 63,017 KB | 4/21/2019 1:13 PM |
| 7.1 7. Vlookup_after.xlsm.xlsm | 45 KB | 4/21/2019 1:01 PM |
| 7.2 7. Vlookup_before.xlsm.xlsm | 40 KB | 4/21/2019 1:01 PM |
| 8. Use Sumif to Complete the Database Sheet.mp4 | 49,085 KB | 4/21/2019 1:13 PM |
| 8.1 8. Sumif_before.xlsm.xlsm | 45 KB | 4/21/2019 1:00 PM |
| 8.2 8. Sumif_after.xlsm.xlsm | 50 KB | 4/21/2019 1:00 PM |
| 9. Using Index & Match as a Substitute for Vlookup.mp4 | 50,837 KB | 4/21/2019 1:10 PM |
| 9.1 9. Index Match_after.xlsm.xlsm | 14,181 KB | 4/21/2019 1:08 PM |
| 9.2 9. Index Match_before.xlsm.xlsm | 42 KB | 4/21/2019 1:02 PM |
