50 Ultimate Excel Tips and Tricks for 2020

Поделиться
HTML-код
  • Опубликовано: 21 авг 2024
  • НаукаНаука

Комментарии • 885

  • @elishevacapobianco-s4731
    @elishevacapobianco-s4731 4 года назад +172

    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  4 года назад +12

      Thanks!

    • @DJMoth03
      @DJMoth03 3 года назад

      lol

    • @Nasigorengwithsambal
      @Nasigorengwithsambal 2 года назад

      I totally agree with you Lisa

    • @patriciarocha1119
      @patriciarocha1119 Год назад +1

      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

  • @the4thmusketeer
    @the4thmusketeer 2 года назад +9

    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.

  • @unsquaredaccounting1914
    @unsquaredaccounting1914 3 года назад +25

    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.

  • @michelleh.5336
    @michelleh.5336 3 года назад +5

    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.

  • @janienreeves2813
    @janienreeves2813 2 года назад +4

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

  • @TheMichman63
    @TheMichman63 2 года назад +5

    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
    @PFunk-kt9gc 10 месяцев назад +2

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

  • @S2100211
    @S2100211 2 года назад +21

    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 RUclips settings to 2X and went through it in 26 minutes!
      So much to learn, so little time…

    • @spoonbendingspacemonkey
      @spoonbendingspacemonkey Год назад

      Same!

  • @rajeshgurung6952
    @rajeshgurung6952 2 года назад +4

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

  • @willieward7419
    @willieward7419 Год назад +2

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

  • @kerimtim
    @kerimtim 5 месяцев назад +1

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

  • @gujjenaut
    @gujjenaut 4 года назад +50

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

    • @SeleTraining
      @SeleTraining  4 года назад +1

      Glad to hear that!

    • @sharriegi
      @sharriegi 3 года назад +4

      @@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.... :)

  • @saurabh199530
    @saurabh199530 3 года назад +1

    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.

  • @Alhusam
    @Alhusam 2 года назад +4

    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.

  • @ruthmelinasilva2441
    @ruthmelinasilva2441 3 года назад +2

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

  • @ramjetriddick5985
    @ramjetriddick5985 Год назад +1

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

  • @glinleyt
    @glinleyt 2 года назад +1

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

  • @AhmedMoatassim
    @AhmedMoatassim 4 года назад +6

    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.

  • @DenG611
    @DenG611 2 года назад +1

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

  • @realvirtualdemand4222
    @realvirtualdemand4222 2 года назад +2

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

  • @z058261
    @z058261 4 года назад +53

    Another Master class orated with News anchor style.

    • @gregbernard7861
      @gregbernard7861 4 года назад +1

      Yes kept waiting for something about China or something

  • @ColfaxLalo
    @ColfaxLalo 2 года назад +1

    The differences between the two lists is insanely easy!

  • @paulvanobberghen
    @paulvanobberghen 4 года назад +2

    Regarding creating series for Months or Days of the weeks, full or abbreviated, this works because Excel "knows" about these predictable series, and you can create your own ones, like letters of the radio alphabet (Alpha, Bravo, Charlie, ... , X-Ray, Zulu) or the US States. This is hidden deep inside Excel's Options > Advanced Options > Scroll way down to General > Edit personalized lists. There are the already recorded lists (months and days of the weeks, normaly) and you can add yours there. You can pick from a list composed in a sheet, or just type what you need. They are saved and available for all documents created on your computer, though it would be nice if it would be saved in our Office 365 account.

  • @macgeraldsuase9574
    @macgeraldsuase9574 3 года назад +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.

  • @kjworland
    @kjworland 3 года назад +4

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

  • @ernstjames4890
    @ernstjames4890 3 года назад +1

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

  • @mohammadaniskhushal6716
    @mohammadaniskhushal6716 4 года назад +11

    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!

  • @jenniekuczynski3873
    @jenniekuczynski3873 3 года назад +1

    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!

  • @user-cu8co1gp7e
    @user-cu8co1gp7e 9 месяцев назад +1

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

  • @hamedhassan9812
    @hamedhassan9812 2 года назад +1

    That's easy and effective, thank you.

  • @bobette4360
    @bobette4360 3 года назад +1

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

  • @Alkheezy
    @Alkheezy 2 года назад +1

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

  • @HeyEveryoneHi
    @HeyEveryoneHi 3 года назад +1

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

  • @johnconlin4608
    @johnconlin4608 4 года назад +11

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

  • @nayoung5111
    @nayoung5111 2 года назад +1

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

  • @electricbutterfly1
    @electricbutterfly1 3 года назад +3

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

    • @SeleTraining
      @SeleTraining  3 года назад +1

      Same here!

    • @W.M.1
      @W.M.1 3 года назад

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

  •  3 года назад +13

    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!

  • @RG-sr4wb
    @RG-sr4wb 4 года назад +6

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

  • @MitkoFitko
    @MitkoFitko 4 года назад +1

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

  • @deathnote5803
    @deathnote5803 2 года назад +2

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

  • @rajpatel2793
    @rajpatel2793 3 года назад +2

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

  • @carolinebwall
    @carolinebwall 3 года назад +4

    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.

  • @joepadlo4337
    @joepadlo4337 3 года назад +1

    All Excel users need this site.

  • @octaviakf
    @octaviakf 2 года назад +1

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

  • @stopdrinkingleftskoolaid6510
    @stopdrinkingleftskoolaid6510 4 года назад +10

    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.

  • @DivakaranKollon
    @DivakaranKollon 2 года назад +1

    Excellent stuff!

  • @ganeshswathi7430
    @ganeshswathi7430 2 года назад +1

    so much of thank you Sir, i owe you a lot

  • @grandmac.168
    @grandmac.168 3 года назад +1

    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 года назад +1

      Thanks! Glad my videos are helpful.

  • @vernabibanco101
    @vernabibanco101 3 года назад +2

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

  • @timon-ullrichmaier2419
    @timon-ullrichmaier2419 3 года назад +1

    Sehr kompetent und vertiefend, dabei kurz und knackig!

  • @kenoguy
    @kenoguy Год назад +1

    Great job, thanks.

  • @adrianawardlow4035
    @adrianawardlow4035 3 года назад +1

    Excellent video. Very useful. Thanks!

  • @lynnettemckinley4636
    @lynnettemckinley4636 3 года назад +2

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

  • @Lana-kk5vh
    @Lana-kk5vh 3 года назад +1

    Wow, that's a lot of tricks & tips to learn. I have to watch your video many times to remember them. Thanks Sele Training.

  • @meecedespalma
    @meecedespalma 2 года назад +1

    Thank you very much for this.

  • @alexandrabujor9863
    @alexandrabujor9863 Год назад +1

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

  • @MS-xd7fd
    @MS-xd7fd 4 года назад +1

    Thank you ..for those tips, clear voice, clear instructions. Subscribed.

  • @JhongskPass
    @JhongskPass Год назад +1

    this excel training videos exactly i want as a beginner

  • @pranaymehta6590
    @pranaymehta6590 4 года назад +1

    Excellent delivery style. Crisp and clear

  • @Metal_seer
    @Metal_seer 5 месяцев назад +1

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

  • @michaellarkin5235
    @michaellarkin5235 3 года назад +1

    Wow - I am no longer afraid of excel ! thank you so much!

  • @amerdecastro8736
    @amerdecastro8736 Год назад +1

    THANKS! Very clear presentation and very informative.

  • @hikki6478
    @hikki6478 Год назад +1

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

  • @user-xw6ko2uw6u
    @user-xw6ko2uw6u 6 месяцев назад +1

    Appreciate it, that was really useful, clear, concise

  • @hassanabdi8510
    @hassanabdi8510 3 года назад +1

    Thanks a lot. This is helpful at work

  • @slartybartfast57
    @slartybartfast57 Год назад +1

    Excellent!

  • @wondimuzufa4010
    @wondimuzufa4010 3 года назад +1

    Thank you for Your Explanation.

  • @andyphillips5162
    @andyphillips5162 4 года назад +1

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

  • @claudehabyarimana3764
    @claudehabyarimana3764 3 года назад +1

    am so excited to have this video

  • @twoplusone_priya
    @twoplusone_priya 2 года назад +1

    Highly informative.. Thank u for the work!

  • @hutster6416
    @hutster6416 2 года назад +1

    You're an excellent teacher! Thanks!

  • @aiditacruzsantoni3489
    @aiditacruzsantoni3489 4 года назад +4

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

  • @wandagreer9144
    @wandagreer9144 2 года назад +3

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

  • @Hellas53
    @Hellas53 3 года назад +1

    The best training tips! Thanks much !

  • @sompm5941
    @sompm5941 3 года назад +8

    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!

  • @moginger8018
    @moginger8018 3 года назад +4

    I have watched so many tutorials and even have paid for some, this one is by far the best, have gained so much knowledge.
    need to start practicing it now.
    Thanks

    • @SeleTraining
      @SeleTraining  3 года назад +1

      Thanks! I find the tips and tricks are the best learning method.

    • @namonam_theyoutuber
      @namonam_theyoutuber 3 года назад +1

      That's great, but just have a look at The Office Lab as well as Excel for Freelancers channel. They are diamonds❣️

  • @MrBlaklip
    @MrBlaklip 3 года назад +1

    Thanks for your simplicity..

  • @sonetmollick4630
    @sonetmollick4630 2 года назад +1

    Thank you so much!!

  • @aldairvilla9055
    @aldairvilla9055 2 года назад +1

    This is the best video on RUclips.

  • @raveensharma6738
    @raveensharma6738 4 года назад +1

    Too good very informative and crisp ...50 mins 50 tricks 👏

  • @tamirose1646
    @tamirose1646 2 года назад +1

    This is spectacular! Thank you for sharing!

  • @sibongubuhletshuma9653
    @sibongubuhletshuma9653 3 года назад +1

    Thanks. Great tips

  • @lauradilaurenzio2098
    @lauradilaurenzio2098 6 месяцев назад +1

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

  • @nishalakula4460
    @nishalakula4460 3 года назад +2

    wow, found good teacher for excel, thanks man

  • @terryhaling7891
    @terryhaling7891 2 года назад +1

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

  • @incman
    @incman 3 года назад +1

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

  • @rohitlakhotia2571
    @rohitlakhotia2571 3 года назад +1

    Brilliant tutorial!

  • @mohammedal-rubayee8667
    @mohammedal-rubayee8667 11 месяцев назад +1

    great info, thanks.

  • @salehal-anazi3987
    @salehal-anazi3987 3 года назад +1

    Well done. A great video

  • @keerthikitijaya-wardena6777
    @keerthikitijaya-wardena6777 Год назад +1

    Excellent! Thank you!

  • @evperez3599
    @evperez3599 3 года назад +1

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

  • @nethrajohn
    @nethrajohn Год назад +1

    First time on your channel and I like it so much

  • @gracemark5995
    @gracemark5995 3 года назад +1

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

  • @brandonspiegel2293
    @brandonspiegel2293 4 года назад +1

    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.

  • @Myconstituency
    @Myconstituency 3 года назад +1

    The presentation is superb,so much enthralling

  • @revingmsto6980
    @revingmsto6980 Год назад +1

    you are amazing sir, thank you so much

  • @navenram5441
    @navenram5441 2 года назад +1

    Great educational video

  • @azimemad6346
    @azimemad6346 2 года назад +1

    Thanks for the 50 tips and tricks this is very useful.

  • @user-vl9ym3vv2g
    @user-vl9ym3vv2g 3 года назад +1

    The best and most useful video for the fun and useful tricks in excel. Thank you!

  • @delorissmith8248
    @delorissmith8248 3 года назад +1

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