☑️ 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/:f:/g/personal/john_howtoexcel_onmicrosoft_com/EtkHfiV3IOlGi4XI6yJT_zABIx_ZCXLLPYvfcMiB95g1tg?e=0hijwW 👇

Check out my full courses and ebooks here
👉 https://www.howtoexcel.org/courses/

DOWNLOAD the example workbook here
📖 https://www.howtoexcel.org/downloads/

SUBSCRIBE & get my 3 FREE eBooks
📧 https://www.howtoexcel.org/newsletter/

CONNECT with me on social
Facebook: https://www.facebook.com/howtoexcelblog
Twitter: https://twitter.com/howtoexcelblog
LinkedIn: https://www.linkedin.com/in/john-macdougall/

Thanks for all your support!

Видео ☑️ Top 30 Advanced Excel Tips and Tricks канала How To Excel