Top 30 Advanced
Excel Tips and Tricks
Learn the top 30 advanced
Microsoft Excel features you need to know to go from beginner to advanced Excel
user. Table of Contents:
1. Get Data from Folders 0:22
2. Text to Columns 5:34
3. Remove Duplicate Values 7:22
4. AutoFill & Fill Handle 8:28
5. Flash Fill 10:41
6. Custom Lists 12:55
7. Freeze Panes 14:36
8. New Window and Arrange 15:48
9. Tables 17:21
10. Ideas 21:37
11. Rich Data Types 23:00
12. Fuzzy Matching 24:53
13. Data Validation
Dropdown List 29:28
14. Data Validation Cell Message 32:00
15. Create a Named Constant
33:26
16. IF Function 35:03
17. COUNTIFS Function 36:29
18. SUMIFS Function 37:34
19. VLOOKUP Function 38:54
20. INDEX & MATCH
Functions 40:06
21. Dynamic Arrays Functions 42:59
22. Display Formulas 49:14
23. Filters 50:10
24. Advanced Filters 52:55
25. Tables Slicers 56:23
26. PivotTables 57:58
27. Pivot Table Slicers
& Timelines 1:02:09
28. Show Values As
Calculations 1:03:49
29. Data Model Relationships 1:05:17
30. Data Model Advanced DAX Formulas 1:08:48
Get the workbook used in the video to follow along: https://howtoexcel-my.sharepoint.com/... 👇
No comments:
Post a Comment