☑️ 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:

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

Check out my full courses and ebooks here

DOWNLOAD the example workbook here

SUBSCRIBE & get my 3 FREE eBooks

CONNECT with me on social

Thanks for all your support!

[HowToExcelBlog]

Check out my full courses and ebooks here

[nancyporter]

Have watched at minimum 20 Excel videos and this one is by far the best! Thank you

[nkululekonzimande]

I discovered your channel yesterday and am loving it. As an advanced Excel and Power BI user, your channel is amazing for incremental learning.

[Snowtu]

Wow! I spent half the night watching your channel. Highly recommend that even advanced users watch your tutorials. I've been using Excel for 25 years and love it. I knew many of your tips already but it was so worth watching anyway. The new functions I learnt will save me many hours.

[mustangfan]

I had a quick view, paused your video, and have referenced it 4 times today in practical work, thanks!

[patrickwong]

Short and to the point. Thank you, John.

[lisaamante]

Las Vegas, NV, USA: This was so awesome! Thorough, clear, concise, fast-moving but really easy to follow. Outstanding! Thank you so much!

[aqibshah]

Excellent tutorial! Definitely recommended for learning Advanced Excel.

[JustOkko]

Wow, as someone who is quite advanced already I can definitely say that this contains almost all advanced tips I would like people to know, plus a few more I didn't completely know yet. Well done!

[leslie]

Hands down the best excel video I've seen so far.

[lfqme]

Thanks John for this useful compilation of knowledge 👍

[wintermorillo]

Great content, some I knew, some I did not, but it's always great to see things from another perspective. Watching this tutotial was totally worth it. Thank you!

[darrylmorgan]

Some Really Helpful Tips And Tricks Happy Days!Thank You John :):):)

[FadiSaid]

Awesome. Very clear and straight to the point.

[yolindabaquero]

Awesome! Thank you for putting this together! 👍

[AkomAwareness]

Thank you so much for doing these videos, you are a legend.

[simpleexcelexamples]

Love the content of this video and your way of teaching! Thanks for the video which gave me inspiration for my own classes (I give basic Excel training to students) 😊

[jacobwilliamson]

This is just great! Thank you so much! It'll really help me unpack Power Query which is just a bit dense for the new initiate :)

[Luciano_mp]

Valuable tips, thanks for the spreadsheet provided. Thank you John.

[kevinj]

Wow! What a great summary of features. At 2x speed, you have to pay attention to what's happening! Thank you!