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