50 Ultimate Excel Tips and Tricks for 2020

The ultimate compilation of Excel tips and tricks to enhance your productivity using Excel. Updated for 2020! I've combined long-established tips and tricks with new ones Microsoft added in 2019 and 2020. You'll find solutions to the most common challenges you face in Excel.

Contents 0:00
1. Move Data 0:35
2. XLOOKUP() 1:04
3. Filter List 2:24
4. Ideas 3:04
5. Remove Blanks 3:54
6. Quick Analysis Tool 4:28
7. AutoFit Column Width 5:27
8. Absolute Cell Reference 5:57
9. Paste Special Values 7:19
10. Drop-Down List 8:05
11. FILTER() 9:15
12. Remove Duplicates 10:43
13. Difference Between Lists 11:31
14. Flash Fill 12:15
15. AutoFill 13:06
16. Data Types 13:53
17. Transpose 15:11
18. Freeze Panes 15:37
19. Text to Columns 16:27
20. Recommended Pivot table 17:25
21. Slicers 18:04
22. Conditional Formatting 19:01
23. IF() 20:29
24. 3D References 21:12
25. Forecast Sheet 22:45
26. SUMIFS() 24:00
27. IFERROR() 25:15
28. Ctrl-Arrow Keys 26:03
29. Filled Maps 26:26
30. PMT() 27:13
31. Show Formulas 28:20
32. Advanced Select 29:10
33. Named Range Shortcut 29:56
34. Hide Cells 30:47
35. COUNTBLANK() 31:30
36. Natural Language Query 31:59
37. Goal Seek 33:08
38. Insert Screenshot 34:30
39. Power Pivot 35:14
40. 3D Maps 36:16
41. ISBLANK() 39:08
42. Analysis ToolPak 39:45
43. CONVERT() 40:48
44. Get Data from Web 41:24
45. People Graph 42:59
46. SORT() 44:18
47. Status Bar Info 45:36
48. Insert Multiple Rows 46:22
49. CHOOSE() 46:53
50. UNIQUE() 48:50

#seletraining #excel #tipsandtricks

[elishevacapobianco-s]

Permit me to say I find your voice calm, soothing, and informative without the least bit of arrogance detected. Maybe it is because I am 59 years of age and familiar with the degree of professionalism displayed from all of my years of employment back home in NYC, but I must commend you not for these useful tips alone but the manner in which they are presented, clear, precise and encompassed by a voice that makes the lessons easy to comprehend and far less intimidating than other turorials. Thank you...

[thethmusketeer]

I recently moved from the service industry into an office environment, and watching your videos has made me feel significantly more confident in my role. Thank you for how patient and detailed your trainings are.

[unsquaredaccounting]

All Excel training videos should be like this! So clear, concise and easy to understand. Thanks for helping me step up my Excel knowledge to a new level.

Superb presentation, great to see many of things improved in the latest versions. Much tedious VBA work can be now done directly in the cells. Thanks for the tutorial!

[TheMichman]

I have watched a few of these videos from other trainers, and you take the time to explain and demostrate. Where others go so fast that you don't learn anything. Thank you!

[mohammadaniskhushal]

This is so helpful! I learned so much from it! Thanks Sele Training! I also enjoyed the 30 Outlook Tips & Tricks! I'm recommending these videos to colleagues!

[kjworland]

Best "straight forward" presentation I've seen! Great info! Thanks so much

[tgeeus]

Great lessons, very helpful! Love it.

[Jowamana]

wow impressed thank you, may God Bless You!

[z]

Another Master class orated with News anchor style.

[ruthmelinasilva]

FINALLY!!! I found an excellent step-by-step tutorial about Excel 2020; Thanks a Million.

[machaian]

Greatly appreciate this video. It's simply so valuable and helpful!

[johnconlin]

Thanks for all the help, this will help me GREATLY when I go to engineering college!

[janienreeves]

I just got a new job and we use Excel. This is amazing that I found someone that helps me comprehend this information. Thanks!

[gujjenaut]

You have taught me a lot in excel. Your teaching makes excel more fun, logical & interesting. Thanks

[PFunk-ktgc]

One of the most helpful videos I have watched. No rambling...Clear and right to the point. Thank You!

[S]

I have learnt a lot from this video. I know that this video was only 50 minutes long but took me the best part of a day to go through it as I was making notes and doing the same thing on my PC in an attempt to remember everything. Very useful things on here with good explanations on how to use them.

Thanks for taking the time to do this and help us simple people.

[Alhusam]

Thanks Jason. Perhaps this is the most comprehensive and informative video on Microsoft Excel tips and tricks, I have ever seen. You did a great job and I look forward to seeing more from you like this. I repeat my thanks to you.

[kerimtim]

THE BEST EXCEL GUIDE I'VE COME ACROSS SO FAR. THANK YOU!

[rajeshgurung]

Amazing. I passed one interview few years back and have another one tomorrow. Thank you for the lessons 👍