50 Ultimate Excel Tips and Tricks for 2020

Рет қаралды 1,813,522

Күн бұрын

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.
Support me with your Amazon purchases, click here: amzn.to/2Kxp533
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

Пікірлер: 888

@elishevacapobianco-s4731 4 жыл бұрын

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...

@SeleTraining 4 жыл бұрын

Thanks!

@DJMoth03 3 жыл бұрын

lol

@chickenfriedrice1980 2 жыл бұрын

I totally agree with you Lisa

@patriciarocha1119 Жыл бұрын

Agree. Some tutors are a way too fast and make simple things to sound much more complex. Intonation, speed of the explanation, and a lot of other details make a huge difference! Thanks

3 жыл бұрын

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!

@kjworland 3 жыл бұрын

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

@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 2 ай бұрын

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

@mohammadaniskhushal6716 3 жыл бұрын

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!

@TheMichman63 2 жыл бұрын

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!

@PFunk-kt9gc 7 ай бұрын

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

@unsquaredaccounting1914 2 жыл бұрын

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.

@SeleTraining 2 жыл бұрын

Glad it helped!

@user-cu8co1gp7e 6 ай бұрын

Great tips and very informative. Still very up to date in 2023. Thanks!!

@ruthmelinasilva2441 3 жыл бұрын

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

@machaian 3 жыл бұрын

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

@the4thmusketeer 2 жыл бұрын

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.

@willieward7419 Жыл бұрын

This should be the standard. This is so clear. Thank you.

@sompm5941 3 жыл бұрын

Definitely saving this video! Its so incredibly useful and direct to the point. It answered 4 or more questions I've had for a while now. thank you!

@ramjetriddick5985 Жыл бұрын

Just THANKS been looking for a help video like this for 15 years

@z058261 4 жыл бұрын

Another Master class orated with News anchor style.

@gregbernard7861 3 жыл бұрын

Yes kept waiting for something about China or something

@wandagreer9144 2 жыл бұрын

Excellent teacher! Thanks for some outstanding help! I learned a lot and will review often!

@janienreeves2813 2 жыл бұрын

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

@rajpatel2793 3 жыл бұрын

I am still looking for 151 person who has disclike this video. Great work.. Keep it up and keep posted this kind of videos

@SeleTraining 3 жыл бұрын

Thank you so much 😀

@realvirtualdemand4222 Жыл бұрын

thank you so much for these functions, this will truly help me as a Virtual Assistant

@tgeeus1406 4 жыл бұрын

Great lessons, very helpful! Love it.

@carolinebwall 3 жыл бұрын

This has been absolutely brilliant. Thank you so much.I have learned a lot from this. Its quick, easy and you can go over and over until you understand it.

@SeleTraining 3 жыл бұрын

Great to hear!

@lynnettemckinley4636 3 жыл бұрын

Concise and well-spoken..... Thank you!

@gujjenaut 4 жыл бұрын

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

@SeleTraining 4 жыл бұрын

Glad to hear that!

@sharriegi 3 жыл бұрын

@@SeleTraining Me too - i always avoided excel but now its exciting

@trommelbiel 3 жыл бұрын

@@sharriegi I am glad I was not the only one who hated excel.

@dushyant_luckmakesurlife 2 жыл бұрын

@@sharriegi same here.... :)

@wayneedmondson1065 4 жыл бұрын

Hi Jason.. excellent. Thanks for this super compilation of Excel Tips and Tricks. Some real good ones in there. Thumbs up and stay safe!!

@ColfaxLalo 2 жыл бұрын

The differences between the two lists is insanely easy!

@deathnote5803 2 жыл бұрын

Thanks for teaching us in a simplest way. Good Job Sir. More power to you.

@macgeraldsuase9574 3 жыл бұрын

watching all the ads is all i can help you sir, thank you for the knowledge sir deeply appreciated all love and support from philippines.

@gargijain8553 2 жыл бұрын

You are simply awesome.. thanks a ton for this wonderful video..

@johnconlin4608 3 жыл бұрын

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

@SeleTraining 3 жыл бұрын

Happy to help!

@aiditacruzsantoni3489 4 жыл бұрын

Excellent! thorough but easy to follow. I recommend this and others made by this professor.

@christopherdobney1636 4 жыл бұрын

This is really great

@rajeshgurung6952 Жыл бұрын

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

@delorissmith8248 2 жыл бұрын

Awesome video. So clear and helpful. Thanks so much for posting these videos.

@S2100211 2 жыл бұрын

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.

@CraigYOW Жыл бұрын

Haha. I set the playback speed in KZfaq settings to 2X and went through it in 26 minutes! So much to learn, so little time…

@spoonbendingspacemonkey Жыл бұрын

Same!

@nethrajohn Жыл бұрын

First time on your channel and I like it so much

@glinleyt 2 жыл бұрын

The most relaxing American accent I have ever heard... Great style with these man. Keep it up!

@Jowamana 4 жыл бұрын

wow impressed thank you, may God Bless You!

@deepk82 3 жыл бұрын

The best video on excel after a long time!

@DenG611 Жыл бұрын

Wow I felt so empowered after watching this video. thanks!

@Alkheezy 2 жыл бұрын

This is the best rundown of tips... Thank you for this.

@AlexRuiztonche 2 жыл бұрын

Excellent, great teacher, makes it look super easy.

@keerthikitijaya-wardena6777 Жыл бұрын

Excellent! Thank you!

@abdidekmuhumed4510 4 жыл бұрын

I found what i have been searching for! Many thanks

@user-yb3fq4ev1r Жыл бұрын

thank you for helping i hope u have a great day

@amerdecastro8736 Жыл бұрын

THANKS! Very clear presentation and very informative.

@hutster6416 2 жыл бұрын

You're an excellent teacher! Thanks!

@EricaDyson 4 жыл бұрын

Very nice. Always something new to learn. Many many thanks. Really useful

@andyphillips5162 3 жыл бұрын

REALLY good quality tips. Clear. Concise. Easy to follow. Thanks!

@SeleTraining 3 жыл бұрын

Great to hear!

@alexandrabujor9863 Жыл бұрын

Thank you so much for all these valuable tips! They are really helpful.

@adrianawardlow4035 3 жыл бұрын

Excellent video. Very useful. Thanks!

@HeyEveryoneHi 3 жыл бұрын

Sir thank you for your work. Remember many people are thankful for you

@SeleTraining 3 жыл бұрын

Thanks and welcome

@abidrockx 3 жыл бұрын

Very Informative, really appreciate the time and effort that has gone into this masterpiece.

@duonghuyen4725 2 жыл бұрын

It's useful. Thank you very much!

@tamirose1646 2 жыл бұрын

This is spectacular! Thank you for sharing!

@onyerekene7586 4 жыл бұрын

The video is so comprehensive and easy to understand. Thank you so much for this tutorial :)

@SeleTraining 4 жыл бұрын

You're very welcome!

@vernabibanco101 2 жыл бұрын

Thank you for explaining it clearly. I gain more knowledge, so GREAT👍😊🤞

@ziadshami9424 3 жыл бұрын

Straight forward and amazing. thank you

@jenniekuczynski3873 3 жыл бұрын

This video makes me more excited to learn the different tricks of Excel. It has me more curious to watch more and explore all that it can do. Thanks!

@SeleTraining 3 жыл бұрын

Great to hear!

@rogerfderose9406 3 жыл бұрын

Very well done, enjoyed your presentation, and look forward to using them as I work with excel. Thanks

@ernstjames4890 3 жыл бұрын

Best Excel tutorial by far. Extremely helpful. Second to none.

@SeleTraining 3 жыл бұрын

Great to hear!

@nayoung5111 Жыл бұрын

This is the best video I ever watched about excel. Thank you!

@tomphelan7396 2 жыл бұрын

Great presentation. Useful items presented concisely. Thanks.

@octaviakf 2 жыл бұрын

This is wonderful I'm going to watch many times to continue to learn

@darlenebradley5827 3 жыл бұрын

Love the tips...very helpful tools! thanks you

@sachinghorpade6030 3 жыл бұрын

Great...!The video is so comprehensive and easy to understand. Thank you so much for this tutorials.

@SeleTraining 3 жыл бұрын

Glad it was helpful!

@storytime5108 3 жыл бұрын

This is so helpful! I learned so much from it.

@MitkoFitko 3 жыл бұрын

As soon as I saw those time stamps I was sold! Thank You!

@SeleTraining 3 жыл бұрын

Wonderful!

@hikki6478 Жыл бұрын

Amazing video will definitely use the filter and SORT(), unique functions

@johnhogan6775 4 жыл бұрын

Lots of good stuff!! I am going to have to re-watch and review as needed as I incorporate it into my business!!

@SeleTraining 4 жыл бұрын

Thanks. Glad it is useful!

@spoonbendingspacemonkey Жыл бұрын

This is awesome! Thank you!

@mariateresmorales-lopez5442 3 жыл бұрын

Awesome! I have learned lots of new information, thanks!

@Hellas53 2 жыл бұрын

The best training tips! Thanks much !

@Myconstituency 3 жыл бұрын

The presentation is superb,so much enthralling

@benrecan5511 2 жыл бұрын

Drop down lists are POG

@SeleTraining 2 жыл бұрын

Check out this video on drop down lists: kzfaq.info/get/bejne/p62dmrtjnKqVoYE.html

@nicofusca4923 4 жыл бұрын

Thanks a lot! Very informative!

@AhmedMoatassim 3 жыл бұрын

the best tutor ever on youtube. you did a miracle summarizing all these features on one video only. this is helpful for beginners and advanced people.

@SeleTraining 3 жыл бұрын

Wow, thanks!

@user-xw6ko2uw6u 3 ай бұрын

Appreciate it, that was really useful, clear, concise

@michelleh.5336 3 жыл бұрын

I've spent weeks trying to figure out how to hide cells with information, then I happened to find this video. Kindly permit me to say, your voice was clean and you used words that were clear and precise. Thank you for teaching me these tricks in just one video, which will help with making my work easier, because of you, I'm super excited to learn more about excel.

@SeleTraining 3 жыл бұрын

Excellent!

@tomjun8945 3 жыл бұрын

Thank you for all your amazing videos. It helps me out a lot in school and at my job. I told a lot of my friends and coworkers about you channel and how educational your videos are. Keep up the good work and I look forward to your next video. Take care.

@SeleTraining 3 жыл бұрын

You're very welcome!

@evperez3599 3 жыл бұрын

Excellent video ! Captures much of what I was looking for and more. Thanks

@SeleTraining 3 жыл бұрын

Great!

@pramodupadhyay9646 3 жыл бұрын

Really Awesome way to explain tips !! Thanks a lot sharing knowledge . Great work Sir !

@terryhaling7891 2 жыл бұрын

There are some great tips, and reminders, in your tutorials.

@Jordmate 3 жыл бұрын

Thanks, Jason for excellent work on showing us how to become better on Excel ☺

@SeleTraining 3 жыл бұрын

My pleasure!

@dating_life350 Жыл бұрын

Great! Thank you for sharing with us such valuable tips :)

@Albert00310 4 жыл бұрын

Thank you, still contains new info!!

@lauradilaurenzio2098 3 ай бұрын

This is a great video, I am new to Excel and found this to be very informative. Thanks again

@piarchanddogra1659 4 жыл бұрын

Very Helpful 👍👍.. Thanks for sharing

@pawanamarnani3011 4 жыл бұрын

Thank You Sir, This video helped me to learn new things in Excel.

@SeleTraining 4 жыл бұрын

Glad it helped

@gracemark5995 3 жыл бұрын

this is all i want . about tips and tricks in excel . thank you👍👍

@bill6387 4 жыл бұрын

This video was great!! All of them are. Thank you!!

@SeleTraining 4 жыл бұрын

You're so welcome!

@incman 2 жыл бұрын

I learned so much from your video. Thanks a lot.

@SeleTraining 2 жыл бұрын

You are welcome!

@melfleming6675 2 жыл бұрын

This is great! Thank you for sharing.

@brandonspiegel2293 4 жыл бұрын

The sort function though. These tips and tricks are really going to help provide me with a competitive edge while interning. I greatly appreciate the knowledge.

@SeleTraining 4 жыл бұрын

Great to hear!