TC4S:\2022_3\The Complete Financial Analyst Course\4. Microsoft Excel - Best Practices That Will Make a Difference

Up one directory...
NameSizeDate Modified
1. Initial Formatting Is Key for Creating Professional-looking Spreadsheets.mp414,174 KB4/21/2019 1:12 PM
1. Initial Formatting Is Key for Creating Professional-looking Spreadsheets.vtt3 KB4/21/2019 1:12 PM
1.1 Formatting a worksheet - Solved.xlsx.xlsx10 KB4/21/2019 1:12 PM
1.2 Formatting a worksheet – Unsolved.xlsx.xlsx9 KB4/21/2019 1:12 PM
1.3 03 17 Formatting a Worksheet Solved.xlsx.xlsx11 KB4/21/2019 1:12 PM
1.4 Useful Tips & Tools.pdf.pdf3,384 KB4/21/2019 1:12 PM
1.5 03 17 Formatting a Worksheet Exercise & Text.xlsx.xlsx11 KB4/21/2019 1:04 PM
10. Find and Select Cells That Meet Specific Conditions.mp413,769 KB4/21/2019 1:11 PM
10. Find and Select Cells That Meet Specific Conditions.vtt2 KB4/21/2019 1:01 PM
10.1 Select Special.xlsx.xlsx11 KB4/21/2019 1:01 PM
10.2 03 24 Select Special (F5) Exercise & Text.xlsx.xlsx22 KB4/21/2019 1:01 PM
10.3 03 24 Select Special (F5) Solved.xlsx.xlsx23 KB4/21/2019 1:01 PM
10.4 Useful Tips & Tools.pdf.pdf3,384 KB4/21/2019 1:08 PM
11. Find and Select Cells That Meet Specific Conditions.html1 KB4/21/2019 1:03 PM
12. How to Create Dynamic Names in Excel Spreadsheets.mp415,510 KB4/21/2019 1:05 PM
12. How to Create Dynamic Names in Excel Spreadsheets.vtt2 KB4/21/2019 1:05 PM
12.1 Dynamic Naming - Solved.xlsx.xlsx14 KB4/21/2019 1:05 PM
12.2 03 25 Assigning Dynamic Names Exercise & Text.xlsx.xlsx12 KB4/21/2019 1:05 PM
12.3 03 25 Assigning Dynamic Names Solved.xlsx.xlsx12 KB4/21/2019 1:05 PM
12.4 Dynamic Naming – Unsolved.xlsx.xlsx14 KB4/21/2019 1:05 PM
12.5 Useful Tips & Tools.pdf.pdf3,384 KB4/21/2019 1:05 PM
13. How to Create Dynamic Names in Excel Spreadsheets.html1 KB4/21/2019 1:00 PM
14. Using Named Ranges to Make Formulas More Readable.mp49,326 KB4/21/2019 1:06 PM
14. Using Named Ranges to Make Formulas More Readable.vtt2 KB4/21/2019 1:06 PM
14.1 Useful Tips & Tools.pdf.pdf3,394 KB4/21/2019 1:06 PM
14.2 Naming ranges - Solved.xlsx.xlsx11 KB4/21/2019 12:54 PM
14.3 Naming ranges – Unsolved.xlsx.xlsx9 KB4/21/2019 12:54 PM
14.4 03 26 Defining a Named Range Solved.xlsx.xlsx12 KB4/21/2019 12:54 PM
14.5 03 26 Defining a Named Range Exercise & Text.xlsx.xlsx12 KB4/21/2019 12:54 PM
15. Custom Number Formatting.mp410,128 KB4/21/2019 12:54 PM
15. Custom Number Formatting.vtt2 KB4/21/2019 12:53 PM
15.1 Useful Tips & Tools.pdf.pdf3,384 KB4/21/2019 12:55 PM
15.2 03 27 Assigning Custom Formats Solved.xlsx.xlsx12 KB4/21/2019 12:55 PM
15.3 03 27 Assigning Custom Formats Exercise & Text.xlsx.xlsx12 KB4/21/2019 12:55 PM
16. How to Add a Drop-down List in Excel.mp416,695 KB4/21/2019 1:06 PM
16. How to Add a Drop-down List in Excel.vtt2 KB4/21/2019 12:59 PM
16.1 Useful Tips & Tools.pdf.pdf3,384 KB4/21/2019 12:59 PM
16.2 03 29 Drop-down List Exercise & Text.xlsx.xlsx12 KB4/21/2019 12:59 PM
16.3 Data Validation – Unsolved.xlsx.xlsx11 KB4/21/2019 12:59 PM
16.4 03 29 Drop-down List Solved.xlsx.xlsx78 KB4/21/2019 12:59 PM
16.5 Data Validation - Solved.xlsx.xlsx11 KB4/21/2019 12:59 PM
17. Using Custom-sort to Sort Multiple Columns Within a Table.mp413,891 KB4/21/2019 1:12 PM
17. Using Custom-sort to Sort Multiple Columns Within a Table.vtt2 KB4/21/2019 1:04 PM
17.1 03 30 Custom Sort Exercise & Text.xlsx.xlsx12 KB4/21/2019 1:04 PM
17.2 03 30 Custom Sort Solved.xlsx.xlsx12 KB4/21/2019 1:04 PM
17.3 Sort data – Unsolved.xlsx.xlsx146 KB4/21/2019 1:04 PM
17.4 Sort data - Solved.xlsx.xlsx146 KB4/21/2019 1:04 PM
17.5 Useful Tips & Tools.pdf.pdf3,394 KB4/21/2019 1:11 PM
18. Saving Time in Excel and Doing Everything Faster by Using Excel Shortcuts.mp447,058 KB4/21/2019 1:12 PM
18. Saving Time in Excel and Doing Everything Faster by Using Excel Shortcuts.vtt5 KB4/21/2019 1:04 PM
18.1 Microsoft Excel Shortcuts for MAC.pdf.pdf770 KB4/21/2019 1:04 PM
18.2 Useful tips and tools - Excel file.xlsx.xlsx2,292 KB4/21/2019 12:49 PM
18.3 Useful Tips & Tools.pdf.pdf3,384 KB4/21/2019 12:55 PM
18.4 Microsoft Excel Shortcuts for PC.pdf.pdf1,292 KB4/21/2019 12:55 PM
19. Multiply by 1.mp415,188 KB4/21/2019 1:08 PM
19.1 1. Multiply by 1_before.xlsx.xlsx17 KB4/21/2019 1:06 PM
19.2 1. Multiply by 1_after.xlsx.xlsx18 KB4/21/2019 1:06 PM
2. Macros Are a Great Timesaver! Here's Why.mp421,910 KB4/21/2019 1:08 PM
2. Macros Are a Great Timesaver! Here's Why.vtt3 KB4/21/2019 12:57 PM
2.1 Useful Tips & Tools.pdf.pdf3,384 KB4/21/2019 12:57 PM
2.2 03 28 Macros Solved.xlsx.xlsx146 KB4/21/2019 12:51 PM
2.3 Creating a Macro - Solved.xlsx.xlsx12 KB4/21/2019 12:51 PM
2.4 Creating a Macro - Unsolved.xlsx.xlsx10 KB4/21/2019 12:51 PM
2.5 03 28 Macros Exercise & Text.xlsx.xlsx11 KB4/21/2019 12:51 PM
20. Find and Replace - References.mp424,626 KB4/21/2019 1:12 PM
20.1 4. Find and Replace references_after.xlsx.xlsx38 KB4/21/2019 12:54 PM
20.2 4. Find and Replace references_before.xlsx.xlsx39 KB4/21/2019 12:54 PM
21. Find and Replace - Formatting.mp414,114 KB4/21/2019 1:08 PM
21.1 5. Find replace_after.xlsx.xlsx18 KB4/21/2019 12:48 PM
21.2 5. Find replace_before.xlsx.xlsx18 KB4/21/2019 12:48 PM
22. Green References.mp412,905 KB4/21/2019 1:05 PM
22.1 6. Green references.xlsx.xlsx12 KB4/21/2019 12:57 PM
23. Beauty Saving - The Professional Way of Saving Files.mp414,370 KB4/21/2019 1:03 PM
23.1 7. Beauty saving_before.xlsx.xlsx18 KB4/21/2019 1:03 PM
23.2 7. Beauty saving_after.xlsx.xlsx18 KB4/21/2019 1:03 PM
24. The Power of F2.mp418,171 KB4/21/2019 1:10 PM
24.1 8. F2.xlsm.xlsm51 KB4/21/2019 12:48 PM
25. Conditional Formatting.mp460,114 KB4/21/2019 1:11 PM
25.1 14. Clarification - conditional formatting.xlsx.xlsx42 KB4/21/2019 12:53 PM
26. Quiz Number 1.html1 KB4/21/2019 12:53 PM
3. How to Use the Same Macro On Multiple Workbooks.mp413,062 KB4/21/2019 1:08 PM
3.1 How to save macros_before.xlsx.xlsx7 KB4/21/2019 12:59 PM
3.2 Another file.xlsx.xlsx9 KB4/21/2019 12:59 PM
3.3 How to save macros_after.xlsm.xlsm13 KB4/21/2019 12:59 PM
4. Macros Are a Great Timesaver! Here's Why.html1 KB4/21/2019 12:59 PM
5. The Secret to Faster Scrolling in Excel.mp421,337 KB4/21/2019 1:05 PM
5. The Secret to Faster Scrolling in Excel.vtt2 KB4/21/2019 12:49 PM
5.1 03 18 Fast Scrolling Solved.xlsx.xlsx45 KB4/21/2019 12:49 PM
5.2 Useful Tips & Tools.pdf.pdf3,384 KB4/21/2019 1:02 PM
5.3 Fast scrolling – Unsolved.xlsx.xlsx11 KB4/21/2019 1:02 PM
5.4 03 18 Fast Scrolling Exercise & Text.xlsx.xlsx44 KB4/21/2019 1:02 PM
5.5 Fast scrolling - Solved.xlsx.xlsx11 KB4/21/2019 1:02 PM
6. Be even quicker F5 + Enter.mp420,266 KB4/21/2019 1:08 PM
6.1 F5 go to.xlsm.xlsm51 KB4/21/2019 12:51 PM
7. The Secret to Faster Scrolling in Excel.html1 KB4/21/2019 12:51 PM
8. Using Absolute and Relative Cell References.mp427,684 KB4/21/2019 1:03 PM
8. Using Absolute and Relative Cell References.vtt3 KB4/21/2019 12:52 PM
8.1 Fixing references – Unsolved.xlsx.xlsx644 KB4/21/2019 12:52 PM
8.2 Fixing references - Solved.xlsx.xlsx646 KB4/21/2019 12:52 PM
8.3 Useful Tips & Tools.pdf.pdf3,394 KB4/21/2019 12:52 PM
8.4 03 19 Fixing Cells Exercise & Text.xlsx.xlsx11 KB4/21/2019 12:49 PM
8.5 03 19 Fixing Cells Solved.xlsx.xlsx11 KB4/21/2019 12:49 PM
9. Using Absolute and Relative Cell References.html1 KB4/21/2019 12:49 PM