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.
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
    @elishevacapobianco-s47313 жыл бұрын

    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

    @SeleTraining

    3 жыл бұрын

    Thanks!

  • @DJMoth03

    @DJMoth03

    3 жыл бұрын

    lol

  • @chickenfriedrice1980

    @chickenfriedrice1980

    2 жыл бұрын

    I totally agree with you Lisa

  • @patriciarocha1119

    @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!

  • @unsquaredaccounting1914
    @unsquaredaccounting19142 жыл бұрын

    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

    @SeleTraining

    2 жыл бұрын

    Glad it helped!

  • @TheMichman63
    @TheMichman632 жыл бұрын

    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!

  • @mohammadaniskhushal6716
    @mohammadaniskhushal67163 жыл бұрын

    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
    @kjworland3 жыл бұрын

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

  • @Alhusam
    @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.

  • @Jowamana
    @Jowamana4 жыл бұрын

    wow impressed thank you, may God Bless You!

  • @janienreeves2813
    @janienreeves28132 жыл бұрын

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

  • @z058261
    @z0582614 жыл бұрын

    Another Master class orated with News anchor style.

  • @gregbernard7861

    @gregbernard7861

    3 жыл бұрын

    Yes kept waiting for something about China or something

  • @johnconlin4608
    @johnconlin46083 жыл бұрын

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

  • @SeleTraining

    @SeleTraining

    3 жыл бұрын

    Happy to help!

  • @machaian
    @machaian3 жыл бұрын

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

  • @gujjenaut
    @gujjenaut4 жыл бұрын

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

  • @SeleTraining

    @SeleTraining

    4 жыл бұрын

    Glad to hear that!

  • @sharriegi

    @sharriegi

    3 жыл бұрын

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

  • @trommelbiel

    @trommelbiel

    3 жыл бұрын

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

  • @dushyant_luckmakesurlife

    @dushyant_luckmakesurlife

    2 жыл бұрын

    @@sharriegi same here.... :)

  • @carolinebwall
    @carolinebwall3 жыл бұрын

    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

    @SeleTraining

    3 жыл бұрын

    Great to hear!

  • @ruthmelinasilva2441
    @ruthmelinasilva24413 жыл бұрын

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

  • @ColfaxLalo
    @ColfaxLalo2 жыл бұрын

    The differences between the two lists is insanely easy!

  • @tgeeus1406
    @tgeeus14064 жыл бұрын

    Great lessons, very helpful! Love it.

  • @S2100211
    @S21002112 жыл бұрын

    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

    @CraigYOW

    Жыл бұрын

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

  • @spoonbendingspacemonkey

    @spoonbendingspacemonkey

    Жыл бұрын

    Same!

  • @macgeraldsuase9574
    @macgeraldsuase95743 жыл бұрын

    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.

  • @rajeshgurung6952
    @rajeshgurung6952 Жыл бұрын

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

  • @the4thmusketeer
    @the4thmusketeer Жыл бұрын

    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.

  • @PFunk-kt9gc
    @PFunk-kt9gc7 ай бұрын

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

  • @kerimtim
    @kerimtim2 ай бұрын

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

  • @sompm5941
    @sompm59413 жыл бұрын

    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!

  • @wandagreer9144
    @wandagreer91442 жыл бұрын

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

  • @michelleh.5336
    @michelleh.53363 жыл бұрын

    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

    @SeleTraining

    3 жыл бұрын

    Excellent!

  • @willieward7419
    @willieward7419 Жыл бұрын

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

  • @abidrockx
    @abidrockx3 жыл бұрын

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

  • @aiditacruzsantoni3489
    @aiditacruzsantoni34894 жыл бұрын

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

  • @christopherdobney1636

    @christopherdobney1636

    4 жыл бұрын

    This is really great

  • @Albert00310
    @Albert003104 жыл бұрын

    Thank you, still contains new info!!

  • @benrecan5511
    @benrecan55112 жыл бұрын

    Drop down lists are POG

  • @SeleTraining

    @SeleTraining

    2 жыл бұрын

    Check out this video on drop down lists: kzread.info/dash/bejne/o3uhybprZ6eXobA.html

  • @rogerfderose9406
    @rogerfderose94063 жыл бұрын

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

  • @brandonspiegel2293
    @brandonspiegel22934 жыл бұрын

    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

    @SeleTraining

    4 жыл бұрын

    Great to hear!

  • @pawanamarnani3011
    @pawanamarnani30114 жыл бұрын

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

  • @SeleTraining

    @SeleTraining

    4 жыл бұрын

    Glad it helped

  • @realvirtualdemand4222
    @realvirtualdemand4222 Жыл бұрын

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

  • @onyerekene7586
    @onyerekene75864 жыл бұрын

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

  • @SeleTraining

    @SeleTraining

    4 жыл бұрын

    You're very welcome!

  • @rajpatel2793
    @rajpatel27933 жыл бұрын

    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

    @SeleTraining

    3 жыл бұрын

    Thank you so much 😀

  • @grandmac.168
    @grandmac.1683 жыл бұрын

    Your Excel videos have been great fun! I'm retired and past "working age" and I've learned a lot I wish I had know before now! I still use Excel for a lot of things - household, travel, etc. but my knowledge is basic. I want to try so many of these Tips and Tricks! Right now I'm preparing spreadsheets for 2020 tax purposes and I'm trying hard to match what I have to what you show and how I might use them. EOY is always such fun.....🙄 Thanks for having a great learning site to go to for the best learning experiences!

  • @SeleTraining

    @SeleTraining

    3 жыл бұрын

    Thanks! Glad my videos are helpful.

  • @johnhogan6775
    @johnhogan67754 жыл бұрын

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

  • @SeleTraining

    @SeleTraining

    4 жыл бұрын

    Thanks. Glad it is useful!

  • @mohanreddy8472
    @mohanreddy84723 жыл бұрын

    Very useful content with lots of new things learned even though I thought I’m good at excel

  • @wayneedmondson1065
    @wayneedmondson10654 жыл бұрын

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

  • @RG-sr4wb
    @RG-sr4wb4 жыл бұрын

    I have been working on Excel for many years but didn't know there is so much inside it. Thanks for awesome tips.

  • @SeleTraining

    @SeleTraining

    4 жыл бұрын

    Glad it was helpful!

  • @jenniekuczynski3873
    @jenniekuczynski38733 жыл бұрын

    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

    @SeleTraining

    3 жыл бұрын

    Great to hear!

  • @storytime5108
    @storytime51083 жыл бұрын

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

  • @deathnote5803
    @deathnote58032 жыл бұрын

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

  • @MitkoFitko
    @MitkoFitko3 жыл бұрын

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

  • @SeleTraining

    @SeleTraining

    3 жыл бұрын

    Wonderful!

  • @markhunter7165
    @markhunter71653 жыл бұрын

    just watched this video, im starting a new job and i will using excel more so this is brill ,,, learned alot!

  • @stopdrinkingleftskoolaid6510
    @stopdrinkingleftskoolaid65104 жыл бұрын

    Hello, thanks for the great tips. I wanted to mention that you can also use flash fill to arrange names in a different order as well as add commas etc. For instance, | joe smith | can be turned into: | smith, joe | by typing it that way. When you go to start typing the next name, flash fill recognizes you want the last name first, a comma, a space and then the first name last.

  • @SeleTraining

    @SeleTraining

    4 жыл бұрын

    Good tip!

  • @ibrahimbakheet6864
    @ibrahimbakheet68644 жыл бұрын

    From Sudan 🇸🇩 thank you so so much

  • @AhmedMoatassim
    @AhmedMoatassim3 жыл бұрын

    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

    @SeleTraining

    3 жыл бұрын

    Wow, thanks!

  • @blaiseanne708
    @blaiseanne7084 жыл бұрын

    I haven't started yet but I know I have so much to learn.. i am a bit late tho for this update... THANK YOU SO MUCH!!!

  • @SeleTraining

    @SeleTraining

    4 жыл бұрын

    You're so welcome!

  • @lynnettemckinley4636
    @lynnettemckinley46363 жыл бұрын

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

  • @abdidekmuhumed4510
    @abdidekmuhumed45104 жыл бұрын

    I found what i have been searching for! Many thanks

  • @tomjun8945
    @tomjun89453 жыл бұрын

    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

    @SeleTraining

    3 жыл бұрын

    You're very welcome!

  • @Jordmate
    @Jordmate3 жыл бұрын

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

  • @SeleTraining

    @SeleTraining

    3 жыл бұрын

    My pleasure!

  • @ramjetriddick5985
    @ramjetriddick5985 Жыл бұрын

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

  • @ckmajumdar1
    @ckmajumdar14 жыл бұрын

    Sir, Your training methodology is very well paced & comprehensive; MS Excel is probably an ocean of information combined with possibilities but you have helped me to get an advanced understanding of the same! Do help us with your research & applied knowledge in future as well! Wish you very well! CK

  • @SeleTraining

    @SeleTraining

    4 жыл бұрын

    Glad it is helpful!

  • @theresial9959
    @theresial99594 жыл бұрын

    Thank you for this tutorial.

  • @saurabh199530
    @saurabh1995302 жыл бұрын

    This video is a million times better than anything I have come across on Coursera, udemy, etc. This is great. A very big thank you to you for creating this video.

  • @SeleTraining

    @SeleTraining

    2 жыл бұрын

    Thanks!

  • @walidnouh766
    @walidnouh7664 жыл бұрын

    So helpful, thank you very much.

  • @wandaathomas4798
    @wandaathomas47983 жыл бұрын

    Thank you so much, this is very informative all I can say is WOW

  • @HeyEveryoneHi
    @HeyEveryoneHi3 жыл бұрын

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

  • @SeleTraining

    @SeleTraining

    3 жыл бұрын

    Thanks and welcome

  • @OREC-Capsules
    @OREC-Capsules4 жыл бұрын

    #8 will save me hours of work !

  • @DenG611
    @DenG611 Жыл бұрын

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

  • @marketingkoul8160
    @marketingkoul81604 жыл бұрын

    Thank you so much . Very simple way of explanation. Learned some effective tricks

  • @SeleTraining

    @SeleTraining

    4 жыл бұрын

    Happy to help

  • @user-cu8co1gp7e
    @user-cu8co1gp7e6 ай бұрын

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

  • @sachinghorpade6030
    @sachinghorpade60303 жыл бұрын

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

  • @SeleTraining

    @SeleTraining

    3 жыл бұрын

    Glad it was helpful!

  • @sandeep86t1
    @sandeep86t13 жыл бұрын

    Hello Sele Training, you are doing a fantastic job! You just made my new complex job so easy for me. Million thanks to you from your Student in India, lots of love for you. I recommended your videos to tons of people I know. Appreciate the calmness and confidence in your voice which keeps the learners always on track. God bless you and keep up the awesome work :) Cheers

  • @SeleTraining

    @SeleTraining

    3 жыл бұрын

    Thanks!

  • @theearnestsylvia3777
    @theearnestsylvia37774 жыл бұрын

    8:05 dropdown list is so useful!

  • @Cruz0e

    @Cruz0e

    3 жыл бұрын

    and u can make it dynamic... by making a named range for example RangeName then and use =indirect(RangeName) for the source of the dropdown list (or just use a row that u generate dinamically) so for example u can make a dropdown list to select a continent, then in an other cell u can do a dynamic validating of the countries from that continent, cool isnt it :)

  • @ahmadmohamed2361

    @ahmadmohamed2361

    3 жыл бұрын

    @@Cruz0e if i put =today() or =now() formula in a cell today, if i open the spreadsheet tomorrow i want yesterday's date to be displayed in that cell

  • @Cruz0e

    @Cruz0e

    3 жыл бұрын

    @@ahmadmohamed2361 if you want that then don't put a function there that recalculates stuff every time the sheet is loaded

  • @bill6387
    @bill63874 жыл бұрын

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

  • @SeleTraining

    @SeleTraining

    4 жыл бұрын

    You're so welcome!

  • @umeshmishra2010
    @umeshmishra20104 жыл бұрын

    You explained very nicely sir. Thanks a lot for unique ideas for being expert in excell.

  • @deepk82
    @deepk823 жыл бұрын

    The best video on excel after a long time!

  • @joepadlo4337
    @joepadlo43373 жыл бұрын

    All Excel users need this site.

  • @SeleTraining

    @SeleTraining

    3 жыл бұрын

    Thanks!

  • @youcefmeb8487
    @youcefmeb84873 жыл бұрын

    Merci, pour cette vidéo on apprend plein de choses.

  • @jagmeetsond6075
    @jagmeetsond60754 жыл бұрын

    Great,very enjoyable and easy to understand video ,thanks to the way you have explained,would love to watch more videos of yours

  • @SeleTraining

    @SeleTraining

    4 жыл бұрын

    So nice of you

  • @ziadshami9424
    @ziadshami94243 жыл бұрын

    Straight forward and amazing. thank you

  • @electricbutterfly1
    @electricbutterfly13 жыл бұрын

    Wow! Love the Xlookup! I've been using index match.

  • @SeleTraining

    @SeleTraining

    3 жыл бұрын

    Same here!

  • @W.M.1

    @W.M.1

    2 жыл бұрын

    New to me too. In previous versions, we only had index match and v/hlookup.

  • @Metal_seer
    @Metal_seer2 ай бұрын

    Thanks. There's always something I didn't know.

  • @andyphillips5162
    @andyphillips51623 жыл бұрын

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

  • @SeleTraining

    @SeleTraining

    3 жыл бұрын

    Great to hear!

  • @Inspector6037
    @Inspector60374 жыл бұрын

    Great Video, thank you so much

  • @ADfamily81
    @ADfamily814 жыл бұрын

    Keep em coming luv your channel!!

  • @SeleTraining

    @SeleTraining

    4 жыл бұрын

    Thanks

  • @AlexRuiztonche
    @AlexRuiztonche2 жыл бұрын

    Excellent, great teacher, makes it look super easy.

  • @salemsalim7128
    @salemsalim7128 Жыл бұрын

    Thank you very much for your informative video. I was hoping for an Excel sheet to accompany it, but anyway still useful.

  • @rockyakpere3599
    @rockyakpere35994 жыл бұрын

    Excellent section, thanks for increase my proficiency in Excel package

  • @SeleTraining

    @SeleTraining

    4 жыл бұрын

    Happy to help

  • @nicofusca4923
    @nicofusca49234 жыл бұрын

    Thanks a lot! Very informative!

  • @glinleyt
    @glinleyt2 жыл бұрын

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

  • @6toolbaseball
    @6toolbaseball3 жыл бұрын

    Love the People Graphs tip!

  • @JhongskPass
    @JhongskPass Жыл бұрын

    this excel training videos exactly i want as a beginner

  • @EricaDyson
    @EricaDyson4 жыл бұрын

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

  • @funnybones6131
    @funnybones61314 жыл бұрын

    Very useful content with lots of new things learned even though I thought I’m good at excel 😁

  • @SeleTraining

    @SeleTraining

    4 жыл бұрын

    Great to hear!

  • @Nishkween
    @Nishkween4 жыл бұрын

    Wow, Excel sure has gotten much smarter! :D Love it!!!

  • @SeleTraining

    @SeleTraining

    4 жыл бұрын

    I think so too!

  • @akperfumes
    @akperfumes4 жыл бұрын

    Your Really Brilliant and Legend. thank You a lot soo much stuff to Absorb!!!!

  • @SeleTraining

    @SeleTraining

    4 жыл бұрын

    You're very welcome!

  • @incman
    @incman2 жыл бұрын

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

  • @SeleTraining

    @SeleTraining

    2 жыл бұрын

    You are welcome!

  • @khushiibhaggnari1138
    @khushiibhaggnari11382 жыл бұрын

    very helpful to sum up all recent excel do's ..One class fits all category

  • @ernstjames4890
    @ernstjames48903 жыл бұрын

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

  • @SeleTraining

    @SeleTraining

    3 жыл бұрын

    Great to hear!

  • @lauradilaurenzio2098
    @lauradilaurenzio20983 ай бұрын

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

  • @bobette4360
    @bobette43603 жыл бұрын

    You are a very good teacher. I wish I had you as a teacher when I was in school. Keep Up the Good Work!!!!!!

  • @SeleTraining

    @SeleTraining

    3 жыл бұрын

    Thank you! 😃

  • @renalarson1626
    @renalarson16264 жыл бұрын

    Thank you for putting this together!

  • @SeleTraining

    @SeleTraining

    4 жыл бұрын

    My pleasure!

  • @sjoerija
    @sjoerija4 жыл бұрын

    VERY helpful and the manor the instruction delivers the information makes it easy to comprehend.

  • @SeleTraining

    @SeleTraining

    4 жыл бұрын

    Great to hear!

  • @tanleefang4591
    @tanleefang45914 жыл бұрын

    thank you for the detailed explanations. learnt a lot from your videos.

  • @SeleTraining

    @SeleTraining

    4 жыл бұрын

    Glad to hear that!

Келесі