TC4S:\2022_3\The Complete Financial Analyst Course\4. Microsoft Excel - Best Practices That Will Make a Difference |
Up one directory... |
|
1. Initial Formatting Is Key for Creating Professional-looking Spreadsheets.mp4 | 14,174 KB | 4/21/2019 1:12 PM |
1. Initial Formatting Is Key for Creating Professional-looking Spreadsheets.vtt | 3 KB | 4/21/2019 1:12 PM |
1.1 Formatting a worksheet - Solved.xlsx.xlsx | 10 KB | 4/21/2019 1:12 PM |
1.2 Formatting a worksheet – Unsolved.xlsx.xlsx | 9 KB | 4/21/2019 1:12 PM |
1.3 03 17 Formatting a Worksheet Solved.xlsx.xlsx | 11 KB | 4/21/2019 1:12 PM |
1.4 Useful Tips & Tools.pdf.pdf | 3,384 KB | 4/21/2019 1:12 PM |
1.5 03 17 Formatting a Worksheet Exercise & Text.xlsx.xlsx | 11 KB | 4/21/2019 1:04 PM |
10. Find and Select Cells That Meet Specific Conditions.mp4 | 13,769 KB | 4/21/2019 1:11 PM |
10. Find and Select Cells That Meet Specific Conditions.vtt | 2 KB | 4/21/2019 1:01 PM |
10.1 Select Special.xlsx.xlsx | 11 KB | 4/21/2019 1:01 PM |
10.2 03 24 Select Special (F5) Exercise & Text.xlsx.xlsx | 22 KB | 4/21/2019 1:01 PM |
10.3 03 24 Select Special (F5) Solved.xlsx.xlsx | 23 KB | 4/21/2019 1:01 PM |
10.4 Useful Tips & Tools.pdf.pdf | 3,384 KB | 4/21/2019 1:08 PM |
11. Find and Select Cells That Meet Specific Conditions.html | 1 KB | 4/21/2019 1:03 PM |
12. How to Create Dynamic Names in Excel Spreadsheets.mp4 | 15,510 KB | 4/21/2019 1:05 PM |
12. How to Create Dynamic Names in Excel Spreadsheets.vtt | 2 KB | 4/21/2019 1:05 PM |
12.1 Dynamic Naming - Solved.xlsx.xlsx | 14 KB | 4/21/2019 1:05 PM |
12.2 03 25 Assigning Dynamic Names Exercise & Text.xlsx.xlsx | 12 KB | 4/21/2019 1:05 PM |
12.3 03 25 Assigning Dynamic Names Solved.xlsx.xlsx | 12 KB | 4/21/2019 1:05 PM |
12.4 Dynamic Naming – Unsolved.xlsx.xlsx | 14 KB | 4/21/2019 1:05 PM |
12.5 Useful Tips & Tools.pdf.pdf | 3,384 KB | 4/21/2019 1:05 PM |
13. How to Create Dynamic Names in Excel Spreadsheets.html | 1 KB | 4/21/2019 1:00 PM |
14. Using Named Ranges to Make Formulas More Readable.mp4 | 9,326 KB | 4/21/2019 1:06 PM |
14. Using Named Ranges to Make Formulas More Readable.vtt | 2 KB | 4/21/2019 1:06 PM |
14.1 Useful Tips & Tools.pdf.pdf | 3,394 KB | 4/21/2019 1:06 PM |
14.2 Naming ranges - Solved.xlsx.xlsx | 11 KB | 4/21/2019 12:54 PM |
14.3 Naming ranges – Unsolved.xlsx.xlsx | 9 KB | 4/21/2019 12:54 PM |
14.4 03 26 Defining a Named Range Solved.xlsx.xlsx | 12 KB | 4/21/2019 12:54 PM |
14.5 03 26 Defining a Named Range Exercise & Text.xlsx.xlsx | 12 KB | 4/21/2019 12:54 PM |
15. Custom Number Formatting.mp4 | 10,128 KB | 4/21/2019 12:54 PM |
15. Custom Number Formatting.vtt | 2 KB | 4/21/2019 12:53 PM |
15.1 Useful Tips & Tools.pdf.pdf | 3,384 KB | 4/21/2019 12:55 PM |
15.2 03 27 Assigning Custom Formats Solved.xlsx.xlsx | 12 KB | 4/21/2019 12:55 PM |
15.3 03 27 Assigning Custom Formats Exercise & Text.xlsx.xlsx | 12 KB | 4/21/2019 12:55 PM |
16. How to Add a Drop-down List in Excel.mp4 | 16,695 KB | 4/21/2019 1:06 PM |
16. How to Add a Drop-down List in Excel.vtt | 2 KB | 4/21/2019 12:59 PM |
16.1 Useful Tips & Tools.pdf.pdf | 3,384 KB | 4/21/2019 12:59 PM |
16.2 03 29 Drop-down List Exercise & Text.xlsx.xlsx | 12 KB | 4/21/2019 12:59 PM |
16.3 Data Validation – Unsolved.xlsx.xlsx | 11 KB | 4/21/2019 12:59 PM |
16.4 03 29 Drop-down List Solved.xlsx.xlsx | 78 KB | 4/21/2019 12:59 PM |
16.5 Data Validation - Solved.xlsx.xlsx | 11 KB | 4/21/2019 12:59 PM |
17. Using Custom-sort to Sort Multiple Columns Within a Table.mp4 | 13,891 KB | 4/21/2019 1:12 PM |
17. Using Custom-sort to Sort Multiple Columns Within a Table.vtt | 2 KB | 4/21/2019 1:04 PM |
17.1 03 30 Custom Sort Exercise & Text.xlsx.xlsx | 12 KB | 4/21/2019 1:04 PM |
17.2 03 30 Custom Sort Solved.xlsx.xlsx | 12 KB | 4/21/2019 1:04 PM |
17.3 Sort data – Unsolved.xlsx.xlsx | 146 KB | 4/21/2019 1:04 PM |
17.4 Sort data - Solved.xlsx.xlsx | 146 KB | 4/21/2019 1:04 PM |
17.5 Useful Tips & Tools.pdf.pdf | 3,394 KB | 4/21/2019 1:11 PM |
18. Saving Time in Excel and Doing Everything Faster by Using Excel Shortcuts.mp4 | 47,058 KB | 4/21/2019 1:12 PM |
18. Saving Time in Excel and Doing Everything Faster by Using Excel Shortcuts.vtt | 5 KB | 4/21/2019 1:04 PM |
18.1 Microsoft Excel Shortcuts for MAC.pdf.pdf | 770 KB | 4/21/2019 1:04 PM |
18.2 Useful tips and tools - Excel file.xlsx.xlsx | 2,292 KB | 4/21/2019 12:49 PM |
18.3 Useful Tips & Tools.pdf.pdf | 3,384 KB | 4/21/2019 12:55 PM |
18.4 Microsoft Excel Shortcuts for PC.pdf.pdf | 1,292 KB | 4/21/2019 12:55 PM |
19. Multiply by 1.mp4 | 15,188 KB | 4/21/2019 1:08 PM |
19.1 1. Multiply by 1_before.xlsx.xlsx | 17 KB | 4/21/2019 1:06 PM |
19.2 1. Multiply by 1_after.xlsx.xlsx | 18 KB | 4/21/2019 1:06 PM |
2. Macros Are a Great Timesaver! Here's Why.mp4 | 21,910 KB | 4/21/2019 1:08 PM |
2. Macros Are a Great Timesaver! Here's Why.vtt | 3 KB | 4/21/2019 12:57 PM |
2.1 Useful Tips & Tools.pdf.pdf | 3,384 KB | 4/21/2019 12:57 PM |
2.2 03 28 Macros Solved.xlsx.xlsx | 146 KB | 4/21/2019 12:51 PM |
2.3 Creating a Macro - Solved.xlsx.xlsx | 12 KB | 4/21/2019 12:51 PM |
2.4 Creating a Macro - Unsolved.xlsx.xlsx | 10 KB | 4/21/2019 12:51 PM |
2.5 03 28 Macros Exercise & Text.xlsx.xlsx | 11 KB | 4/21/2019 12:51 PM |
20. Find and Replace - References.mp4 | 24,626 KB | 4/21/2019 1:12 PM |
20.1 4. Find and Replace references_after.xlsx.xlsx | 38 KB | 4/21/2019 12:54 PM |
20.2 4. Find and Replace references_before.xlsx.xlsx | 39 KB | 4/21/2019 12:54 PM |
21. Find and Replace - Formatting.mp4 | 14,114 KB | 4/21/2019 1:08 PM |
21.1 5. Find replace_after.xlsx.xlsx | 18 KB | 4/21/2019 12:48 PM |
21.2 5. Find replace_before.xlsx.xlsx | 18 KB | 4/21/2019 12:48 PM |
22. Green References.mp4 | 12,905 KB | 4/21/2019 1:05 PM |
22.1 6. Green references.xlsx.xlsx | 12 KB | 4/21/2019 12:57 PM |
23. Beauty Saving - The Professional Way of Saving Files.mp4 | 14,370 KB | 4/21/2019 1:03 PM |
23.1 7. Beauty saving_before.xlsx.xlsx | 18 KB | 4/21/2019 1:03 PM |
23.2 7. Beauty saving_after.xlsx.xlsx | 18 KB | 4/21/2019 1:03 PM |
24. The Power of F2.mp4 | 18,171 KB | 4/21/2019 1:10 PM |
24.1 8. F2.xlsm.xlsm | 51 KB | 4/21/2019 12:48 PM |
25. Conditional Formatting.mp4 | 60,114 KB | 4/21/2019 1:11 PM |
25.1 14. Clarification - conditional formatting.xlsx.xlsx | 42 KB | 4/21/2019 12:53 PM |
26. Quiz Number 1.html | 1 KB | 4/21/2019 12:53 PM |
3. How to Use the Same Macro On Multiple Workbooks.mp4 | 13,062 KB | 4/21/2019 1:08 PM |
3.1 How to save macros_before.xlsx.xlsx | 7 KB | 4/21/2019 12:59 PM |
3.2 Another file.xlsx.xlsx | 9 KB | 4/21/2019 12:59 PM |
3.3 How to save macros_after.xlsm.xlsm | 13 KB | 4/21/2019 12:59 PM |
4. Macros Are a Great Timesaver! Here's Why.html | 1 KB | 4/21/2019 12:59 PM |
5. The Secret to Faster Scrolling in Excel.mp4 | 21,337 KB | 4/21/2019 1:05 PM |
5. The Secret to Faster Scrolling in Excel.vtt | 2 KB | 4/21/2019 12:49 PM |
5.1 03 18 Fast Scrolling Solved.xlsx.xlsx | 45 KB | 4/21/2019 12:49 PM |
5.2 Useful Tips & Tools.pdf.pdf | 3,384 KB | 4/21/2019 1:02 PM |
5.3 Fast scrolling – Unsolved.xlsx.xlsx | 11 KB | 4/21/2019 1:02 PM |
5.4 03 18 Fast Scrolling Exercise & Text.xlsx.xlsx | 44 KB | 4/21/2019 1:02 PM |
5.5 Fast scrolling - Solved.xlsx.xlsx | 11 KB | 4/21/2019 1:02 PM |
6. Be even quicker F5 + Enter.mp4 | 20,266 KB | 4/21/2019 1:08 PM |
6.1 F5 go to.xlsm.xlsm | 51 KB | 4/21/2019 12:51 PM |
7. The Secret to Faster Scrolling in Excel.html | 1 KB | 4/21/2019 12:51 PM |
8. Using Absolute and Relative Cell References.mp4 | 27,684 KB | 4/21/2019 1:03 PM |
8. Using Absolute and Relative Cell References.vtt | 3 KB | 4/21/2019 12:52 PM |
8.1 Fixing references – Unsolved.xlsx.xlsx | 644 KB | 4/21/2019 12:52 PM |
8.2 Fixing references - Solved.xlsx.xlsx | 646 KB | 4/21/2019 12:52 PM |
8.3 Useful Tips & Tools.pdf.pdf | 3,394 KB | 4/21/2019 12:52 PM |
8.4 03 19 Fixing Cells Exercise & Text.xlsx.xlsx | 11 KB | 4/21/2019 12:49 PM |
8.5 03 19 Fixing Cells Solved.xlsx.xlsx | 11 KB | 4/21/2019 12:49 PM |
9. Using Absolute and Relative Cell References.html | 1 KB | 4/21/2019 12:49 PM |