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: howtoexcel-my.sharepoint.com/... 👇
Check out my full courses and ebooks here
👉 www.howtoexcel.org/courses/
DOWNLOAD the example workbook here
📖 www.howtoexcel.org/downloads/
SUBSCRIBE & get my 3 FREE eBooks
📧 www.howtoexcel.org/newsletter/
CONNECT with me on social
Facebook: / howtoexcelblog
Twitter: / howtoexcelblog
LinkedIn: / john-macdougall
Thanks for all your support!
29 июн 2024
