TC4S:\2022_3\The Complete Financial Analyst Course\5. Microsoft Excel - Beginner, Intermediate & Advanced Functions

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