TC4S:\.@DOWNLOAD\22b - CTV\T\The Complete Financial Analyst Course 2019\5. Microsoft Excel - Beginner, Intermediate & Advanced Functions

Up one directory...
NameSizeDate Modified
1. Key Excel Functions If.mp417,061 KB9/26/2020 6:46 AM
1.1 IF function_before.xlsm.xlsm18 KB9/26/2020 6:46 AM
1.2 IF function_after.xlsm.xlsm18 KB9/26/2020 6:46 AM
10. = and + are interchangeable when you start typing a formula.mp45,931 KB9/26/2020 6:46 AM
10.1 Show that = and + are interchangeable_before.xlsm.xlsm18 KB9/26/2020 6:46 AM
10.2 Show that = and + are interchangeable_after.xlsm.xlsm18 KB9/26/2020 6:46 AM
11. Use Round in Your Financial Models.mp45,348 KB9/26/2020 6:46 AM
11. Use Round in Your Financial Models.vtt2 KB9/26/2020 6:46 AM
11.1 05 42 Round Exercise & Text.xlsx.xlsx12 KB9/26/2020 6:46 AM
11.2 05 42 Round Solved.xlsx.xlsx12 KB9/26/2020 6:46 AM
11.3 Excel functions.xlsx.xlsx972 KB9/26/2020 6:46 AM
11.4 Excel Functions.pdf.pdf3,254 KB9/26/2020 6:46 AM
12. Excel's Lookup Functions Vlookup & Hlookup Made Easy.mp461,712 KB9/26/2020 6:46 AM
12. Excel's Lookup Functions Vlookup & Hlookup Made Easy.vtt8 KB9/26/2020 6:46 AM
12.1 Vlookup, Hlookup - Unsolved.xlsx.xlsx11 KB9/26/2020 6:46 AM
12.2 Excel Functions.pdf.pdf3,254 KB9/26/2020 6:46 AM
12.3 05 43 Vlookup, Hlookup Exercise & Text.xlsx.xlsx12 KB9/26/2020 6:46 AM
12.4 Vlookup, Hlookup – Solved.xlsx.xlsx12 KB9/26/2020 6:46 AM
12.5 05 43 Vlookup, Hlookup Solved.xlsx.xlsx15 KB9/26/2020 6:46 AM
13. Index, Match, and Their Combination - The Perfect Substitute for Vlookup.mp463,247 KB9/26/2020 6:46 AM
13. Index, Match, and Their Combination - The Perfect Substitute for Vlookup.vtt8 KB9/26/2020 6:46 AM
13.1 05 44 Index, Match Solved.xlsx.xlsx13 KB9/26/2020 6:46 AM
13.2 05 44 Index, Match Exercise & Text.xlsx.xlsx12 KB9/26/2020 6:46 AM
13.3 Index & Match - Unsolved.xlsx.xlsx12 KB9/26/2020 6:46 AM
13.4 Index & Match – Solved.xlsx.xlsx12 KB9/26/2020 6:46 AM
13.5 Excel Functions.pdf.pdf3,254 KB9/26/2020 6:46 AM
14. Index, Match, and Their Combination - The Perfect Substitute for Vlookup.html1 KB9/26/2020 6:46 AM
15. Using Excel's Iferror Function to Trap Spreadsheet Errors.mp412,021 KB9/26/2020 6:46 AM
15. Using Excel's Iferror Function to Trap Spreadsheet Errors.vtt2 KB9/26/2020 6:46 AM
15.1 Excel Functions.pdf.pdf3,254 KB9/26/2020 6:46 AM
15.2 05 45 IFERROR Exercise & Text.xlsx.xlsx15 KB9/26/2020 6:46 AM
15.3 Iferror.xlsx.xlsx10 KB9/26/2020 6:46 AM
15.4 Iferror – Unsolved.xlsx.xlsx10 KB9/26/2020 6:46 AM
15.5 05 45 IFERROR Solved.xlsx.xlsx16 KB9/26/2020 6:46 AM
16. A Useful Tool for Financial Analysis - The Rank Function.mp423,802 KB9/26/2020 6:46 AM
16.1 RANK function_before.xlsx.xlsx13 KB9/26/2020 6:46 AM
16.2 RANK function_after.xlsx.xlsx13 KB9/26/2020 6:46 AM
17. Create Flexible Financial Models with Choose.mp420,322 KB9/26/2020 6:46 AM
17. Create Flexible Financial Models with Choose.vtt3 KB9/26/2020 6:46 AM
17.1 05 46 Choose Solved.xlsx.xlsx12 KB9/26/2020 6:46 AM
17.2 Choose - Solved.xlsx.xlsx10 KB9/26/2020 6:46 AM
17.3 Excel Functions.pdf.pdf3,264 KB9/26/2020 6:46 AM
17.4 05 46 Choose Exercise & Text.xlsx.xlsx12 KB9/26/2020 6:46 AM
17.5 Choose – Unsolved.xlsx.xlsx10 KB9/26/2020 6:46 AM
18. Goal Seek Will Help You Find the Result You Are Looking For.mp416,404 KB9/26/2020 6:46 AM
18. Goal Seek Will Help You Find the Result You Are Looking For.vtt3 KB9/26/2020 6:46 AM
18.1 Excel Functions.pdf.pdf3,254 KB9/26/2020 6:46 AM
18.2 Goal Seek – Unsolved.xlsx.xlsx9 KB9/26/2020 6:46 AM
18.3 05 47 Goal Seek Solved.xlsx.xlsx17 KB9/26/2020 6:46 AM
18.4 05 47 Goal Seek Exercise & Text.xlsx.xlsx17 KB9/26/2020 6:46 AM
18.5 Goal Seek - Solved.xlsx.xlsx9 KB9/26/2020 6:46 AM
19. Goal Seek Will Help You Find the Result You Are Looking For.html1 KB9/26/2020 6:46 AM
2. Enlarge the formula bar.mp46,401 KB9/26/2020 6:46 AM
2.1 3. Enlarge the formula bar.xlsm.xlsm47 KB9/26/2020 6:46 AM
20. Perform Sensitivity Analysis with Excel's Data Tables Functionality.mp426,862 KB9/26/2020 6:46 AM
20. Perform Sensitivity Analysis with Excel's Data Tables Functionality.vtt5 KB9/26/2020 6:46 AM
20.1 Data Tables – Unsolved.xlsx.xlsx10 KB9/26/2020 6:46 AM
20.2 Data Tables - Solved.xlsx.xlsx10 KB9/26/2020 6:46 AM
20.3 05 48 Sensitivity Analysis Solved.xlsx.xlsx14 KB9/26/2020 6:46 AM
20.4 05 48 Sensitivity Analysis Exercise & Text.xlsx.xlsx13 KB9/26/2020 6:46 AM
21. Perform Sensitivity Analysis with Excel's Data Tables Functionality.html1 KB9/26/2020 6:46 AM
22. Quiz Number 2.html1 KB9/26/2020 6:46 AM
3. Key Excel Functions Sum, Sumif, Sumifs.mp431,426 KB9/26/2020 6:46 AM
3. Key Excel Functions Sum, Sumif, Sumifs.vtt5 KB9/26/2020 6:46 AM
3.1 Sum, Sumif, Sumifs – Solved.xlsx.xlsx14 KB9/26/2020 6:46 AM
3.2 05 37 Sum, Sumif, Sumifs Solved.xlsx.xlsx15 KB9/26/2020 6:46 AM
3.3 Sum, Sumif, Sumifs - Unsolved.xlsx.xlsx13 KB9/26/2020 6:46 AM
3.4 Excel Functions.pdf.pdf3,254 KB9/26/2020 6:46 AM
3.5 05 37 Sum, Sumif, Sumifs Exercise & Text.xlsx.xlsx15 KB9/26/2020 6:46 AM
4. Key Excel Functions Count, Counta, Countif, Countifs.mp431,960 KB9/26/2020 6:46 AM
4. Key Excel Functions Count, Counta, Countif, Countifs.vtt5 KB9/26/2020 6:46 AM
4.1 Excel Functions.pdf.pdf3,254 KB9/26/2020 6:46 AM
4.2 05-38-Counts-Solved.xlsx.xlsx17 KB9/26/2020 6:46 AM
4.3 Count, Countif, Countifs – Unsolved.xlsx.xlsx12 KB9/26/2020 6:46 AM
4.4 05 38 Counts Exercise & Text.xlsx.xlsx16 KB9/26/2020 6:46 AM
5. Key Excel Functions Average & Averageif.mp415,485 KB9/26/2020 6:46 AM
5. Key Excel Functions Average & Averageif.vtt3 KB9/26/2020 6:46 AM
5.1 05 39 Average, AverageIF Solution.xlsx.xlsx16 KB9/26/2020 6:46 AM
5.2 Excel Functions.pdf.pdf3,254 KB9/26/2020 6:46 AM
5.3 05 39 Average, AverageIF Exercise & Text.xlsx.xlsx15 KB9/26/2020 6:46 AM
5.4 Average, Averageif – Unsolved.xlsx.xlsx10 KB9/26/2020 6:46 AM
5.5 Average, Averageif - Solved.xlsx.xlsx10 KB9/26/2020 6:46 AM
6. Key Excel Functions Left, Right, Mid, Upper, Lower, Proper, Concatenate, &.mp431,149 KB9/26/2020 6:46 AM
6. Key Excel Functions Left, Right, Mid, Upper, Lower, Proper, Concatenate, &.vtt6 KB9/26/2020 6:46 AM
6.1 Text Functions - Solved.xlsx.xlsx12 KB9/26/2020 6:46 AM
6.2 05 40 2 Left, Right etc Exercise & Text.xlsx.xlsx12 KB9/26/2020 6:46 AM
6.3 Text Functions - Unsolved.xlsx.xlsx11 KB9/26/2020 6:46 AM
6.4 05 40 2 Left, Right etc Solved.xlsx.xlsx13 KB9/26/2020 6:46 AM
7. Key Excel Functions Left, Right, Mid, Upper, Lower, Proper, Concatenate, &.html1 KB9/26/2020 6:46 AM
8. Working with text in Excel.mp416,390 KB9/26/2020 6:46 AM
8.1 Work with text_after.xlsx.xlsx11 KB9/26/2020 6:46 AM
8.2 Work with text_before.xlsx.xlsx11 KB9/26/2020 6:46 AM
9. Find the Highest and Lowest Values in a Range Max & Min.mp47,730 KB9/26/2020 6:46 AM
9. Find the Highest and Lowest Values in a Range Max & Min.vtt2 KB9/26/2020 6:46 AM
9.1 05 41 MIN MAX Solved.xlsx.xlsx15 KB9/26/2020 6:46 AM
9.2 Max, min - Unsolved.xlsx.xlsx9 KB9/26/2020 6:46 AM
9.3 Excel Functions.pdf.pdf3,254 KB9/26/2020 6:46 AM
9.4 05 41 MIN MAX Exercise & Text.xlsx.xlsx15 KB9/26/2020 6:46 AM
9.5 Max, min – Solved.xlsx.xlsx10 KB9/26/2020 6:46 AM