TC4S:\.@DOWNLOAD\22b - CTV\T\The Complete Financial Analyst Course 2019\7. Microsoft Excel - Practical Exercise Build a P&L From Scratch

Up one directory...
NameSizeDate Modified
9.2 9. Index Match_before.xlsm.xlsm42 KB9/26/2020 6:46 AM
9.1 9. Index Match_after.xlsm.xlsm14,181 KB9/26/2020 6:46 AM
9. Using Index & Match as a Substitute for Vlookup.mp450,837 KB9/26/2020 6:46 AM
8.2 8. Sumif_after.xlsm.xlsm50 KB9/26/2020 6:46 AM
8.1 8. Sumif_before.xlsm.xlsm45 KB9/26/2020 6:46 AM
8. Use Sumif to Complete the Database Sheet.mp449,085 KB9/26/2020 6:46 AM
7.2 7. Vlookup_before.xlsm.xlsm40 KB9/26/2020 6:46 AM
7.1 7. Vlookup_after.xlsm.xlsm45 KB9/26/2020 6:46 AM
7. Using Lookup Functions (Vlookup) to Fill the Database Sheet.mp463,017 KB9/26/2020 6:46 AM
6.2 6. Creating a database_after.xlsm.xlsm40 KB9/26/2020 6:46 AM
6.1 6. Creating a database_before.xlsm.xlsm42 KB9/26/2020 6:46 AM
6. Learn How to Create a Database.mp421,238 KB9/26/2020 6:46 AM
5.2 5. Creating a code_after.xlsm.xlsm42 KB9/26/2020 6:46 AM
5.1 5. Creating a code_before.xlsm.xlsm42 KB9/26/2020 6:46 AM
5. Create a Code The Best Way to Organize Your Data and Work Efficiently with It.mp425,097 KB9/26/2020 6:46 AM
4.2 4. Order a worksheet_before.xlsm.xlsm44 KB9/26/2020 6:46 AM
4.1 4. Order a worksheet_after.xlsm.xlsm42 KB9/26/2020 6:46 AM
4. Ordering the Source Worksheet.mp427,204 KB9/26/2020 6:46 AM
3.1 3. Get to know the data source.xlsm.xlsm44 KB9/26/2020 6:46 AM
3. Understand Your Data Source Before You Start Working on It.mp428,790 KB9/26/2020 6:46 AM
2. What You Will See Next.mp410,453 KB9/26/2020 6:46 AM
17. Quiz Number 3.html1 KB9/26/2020 6:46 AM
16.3 15. Adding % variations_after.xlsm.xlsm57 KB9/26/2020 6:46 AM
16.2 15. Adding % variations_before.xlsm.xlsm55 KB9/26/2020 6:46 AM
16.1 Y-o-Y Function explanation.pdf.pdf165 KB9/26/2020 6:46 AM
16. Calculating Growth Rates in Excel.mp430,701 KB9/26/2020 6:46 AM
15.2 14. Countif_before.xlsm.xlsm54 KB9/26/2020 6:46 AM
15.1 14. Countif_after.xlsm.xlsm55 KB9/26/2020 6:46 AM
15. Learn How to Find Mistakes with Countif.mp428,514 KB9/26/2020 6:46 AM
14.2 13. Formatting the P&L_after.xlsm.xlsm54 KB9/26/2020 6:46 AM
14.1 13. Formatting the P&L_before.xlsm.xlsm52 KB9/26/2020 6:46 AM
14. Populate the P&L Sheet with Sumif.mp430,959 KB9/26/2020 6:46 AM
13.2 12. Formatting the P&L_after.xlsm.xlsm52 KB9/26/2020 6:46 AM
13.1 12. Formatting a P&L_before.xlsm.xlsm52 KB9/26/2020 6:46 AM
13. A Practical Example of Professional Formatting in Excel.mp426,029 KB9/26/2020 6:46 AM
12.2 11. Building a P&L_after.xlsm.xlsm52 KB9/26/2020 6:46 AM
12.1 11. Building a P&L_before.xlsm.xlsm51 KB9/26/2020 6:46 AM
12. Building the Structure of the P&L Sheet.mp421,372 KB9/26/2020 6:46 AM
11.2 10. Mapping_after.xlsm.xlsm51 KB9/26/2020 6:46 AM
11.1 10. Mapping_before.xlsm.xlsm50 KB9/26/2020 6:46 AM
11. Mapping the Rows in the Database Sheet.mp433,381 KB9/26/2020 6:46 AM
10.2 10a. Mapping.xlsm.xlsm52 KB9/26/2020 6:46 AM
10.1 10a. Mapping_before.xlsm.xlsm52 KB9/26/2020 6:46 AM
10. The Mapping Exercise.mp422,139 KB9/26/2020 6:46 AM
1. Introduction to the Case Study.mp410,054 KB9/26/2020 6:46 AM