50 Ultimate Excel Tips and Tricks for 2020

แชร์
ฝัง
  • เผยแพร่เมื่อ 21 ธ.ค. 2024

ความคิดเห็น • 890

  • @elishevacapobianco-s1960
    @elishevacapobianco-s1960 4 ปีที่แล้ว +174

    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 2 ปีที่แล้ว +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

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

  • @janienreeves2813
    @janienreeves2813 2 ปีที่แล้ว +5

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

  • @PFunk-kt9gc
    @PFunk-kt9gc ปีที่แล้ว +2

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

  • @kerimtim
    @kerimtim 9 หลายเดือนก่อน +2

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

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

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

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

  • @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 2 ปีที่แล้ว

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

    • @spoonbendingspacemonkey
      @spoonbendingspacemonkey 2 ปีที่แล้ว

      Same!

  • @glinleyt
    @glinleyt 3 ปีที่แล้ว +1

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

  • @realvirtualdemand4222
    @realvirtualdemand4222 2 ปีที่แล้ว +2

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

  • @rajeshgurung6952
    @rajeshgurung6952 2 ปีที่แล้ว +4

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

  • @ColfaxLalo
    @ColfaxLalo 3 ปีที่แล้ว +1

    The differences between the two lists is insanely easy!

  • @willieward7419
    @willieward7419 ปีที่แล้ว +2

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

  • @gujjenaut
    @gujjenaut 4 ปีที่แล้ว +49

    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 3 ปีที่แล้ว

      @@sharriegi same here.... :)

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

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

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

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

  • @HeyEveryoneHi
    @HeyEveryoneHi 3 ปีที่แล้ว +2

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

  • @ramjetriddick5985
    @ramjetriddick5985 2 ปีที่แล้ว +1

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

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

  • @DenG611
    @DenG611 2 ปีที่แล้ว +1

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

  • @salemsalim7128
    @salemsalim7128 2 ปีที่แล้ว +2

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

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

  • @TonyaShoults-Moroz
    @TonyaShoults-Moroz ปีที่แล้ว +1

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

  • @ganeshswathi7430
    @ganeshswathi7430 2 ปีที่แล้ว +1

    Respected Sir, the techniques of excel shortcuts explanation was very nice, these are very useful to learners to improve their skills and so much of thanks you to making this video of 50 techniques.

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

  • @UK_lover.muzaki
    @UK_lover.muzaki 3 ปีที่แล้ว +1

    Hi sir,
    You are so awsome i have learnt lots in excel from you. Please keep it up.
    Best way of teaching any one can understand

  • @hannahanna-q9w
    @hannahanna-q9w 2 ปีที่แล้ว +1

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

  • @ruthmelinasilva2441
    @ruthmelinasilva2441 3 ปีที่แล้ว +2

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

  • @deathnote5803
    @deathnote5803 2 ปีที่แล้ว +2

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

  • @timon-ullrichmaier2419
    @timon-ullrichmaier2419 4 ปีที่แล้ว +1

    Sehr kompetent und vertiefend, dabei kurz und knackig!

  • @lauradilaurenzio2098
    @lauradilaurenzio2098 10 หลายเดือนก่อน +1

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

  • @nadim161
    @nadim161 4 ปีที่แล้ว +1

    This is the best excel tutoring tips I've seen so far, you covered 50 very useful function in about 50 minutes, you have a God gifted voice and calmness for teaching, Thank you! , the only one function i'm still struggling is pivot table, any suggestion?

    • @SeleTraining
      @SeleTraining  4 ปีที่แล้ว

      Take a look at my Pivto table in 30 seconds video: th-cam.com/video/05vXappumt8/w-d-xo.html

  • @kapil4757
    @kapil4757 ปีที่แล้ว +1

    This is so amazing.
    Your voice is soothing too. Keep up the great work.
    Would you mind sharing the file used in video? It would be great if you could include the link in the description for the benefit of all.
    Thanks in advance.

    • @SeleTraining
      @SeleTraining  ปีที่แล้ว

      There is no file for this video. I figured most of the examples are simple to create. I do have a couple other files available at www.seletraining.com though.

  • @abhishekpal1405
    @abhishekpal1405 4 ปีที่แล้ว +1

    Thanks for sharing your knowledge. Your way of teaching is very easy to understand.

  • @hikki6478
    @hikki6478 2 ปีที่แล้ว +1

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

  • @Alkheezy
    @Alkheezy 3 ปีที่แล้ว +1

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

  • @nancybronzini5976
    @nancybronzini5976 3 ปีที่แล้ว +1

    Excellent and VERY well presented. Now if we can just upgrade our Excel at work.

    • @SeleTraining
      @SeleTraining  3 ปีที่แล้ว

      That's always a challenge!

  • @aldairvilla9055
    @aldairvilla9055 2 ปีที่แล้ว +1

    This is the best video on TH-cam.

  • @JayKrishna-n6t
    @JayKrishna-n6t 3 หลายเดือนก่อน +2

    Amazing explantion Sir. One of the best videos on excel. Amazing @sele training Sir. I had one request Sir. can you please share the files used in the above videos please. It would be of a great help. Only for education and practise sir. Would really appreciate and be obliged sir

    • @SeleTraining
      @SeleTraining  2 หลายเดือนก่อน

      There is no sample file for this one. It has some basic data elements so I did not create a file.

  • @octaviakf
    @octaviakf 2 ปีที่แล้ว +1

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

  • @ernstjames4890
    @ernstjames4890 4 ปีที่แล้ว +1

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

  • @macgeraldsuase9574
    @macgeraldsuase9574 4 ปีที่แล้ว +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.

  • @MS-xd7fd
    @MS-xd7fd 4 ปีที่แล้ว +1

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

  • @ShahbazAhmad-rr3we
    @ShahbazAhmad-rr3we 3 หลายเดือนก่อน +1

    THANK YOU! This is very precise and comprehensive .

  • @ΜατίναΜπλάτζιου
    @ΜατίναΜπλάτζιου 3 ปีที่แล้ว +1

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

  • @marbetu5394
    @marbetu5394 ปีที่แล้ว +1

    I love your videos, thank you. I just want your advice now. I don't have an "IDEAS" button on my Home ribbon. Have you any idea how I can get it? I have looked through the options to add to ribbon (right click on ribbon), but there is no "IDEAS". I recently bought the new version of MS office 365 - so it is definitely up to date. Thanks in advance

    • @SeleTraining
      @SeleTraining  ปีที่แล้ว +1

      They changed the name Ideas to Analyze Data. You should see that on the far right of the Home tab. It still has the same options.

    • @marbetu5394
      @marbetu5394 ปีที่แล้ว

      @@SeleTraining thank you

  • @elizabethsenhouse7822
    @elizabethsenhouse7822 2 ปีที่แล้ว

    Thank you for your informative tutorials. I will like to know about read only, how to turn on and off.

  • @vernabibanco101
    @vernabibanco101 3 ปีที่แล้ว +2

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

  • @joepadlo4337
    @joepadlo4337 3 ปีที่แล้ว +1

    All Excel users need this site.

  • @amerdecastro8736
    @amerdecastro8736 2 ปีที่แล้ว +1

    THANKS! Very clear presentation and very informative.

  • @electricbutterfly1
    @electricbutterfly1 4 ปีที่แล้ว +3

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

    • @SeleTraining
      @SeleTraining  4 ปีที่แล้ว +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.

  • @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❣️

  • @yangyangskinie5494
    @yangyangskinie5494 3 ปีที่แล้ว +1

    Thank you for sharing your knowledge Sir. I learn more and understand the use of those functions. It is so useful for me. Hope to watch more videos in future.. And also you are so cool.

  • @pranaymehta6590
    @pranaymehta6590 4 ปีที่แล้ว +1

    Excellent delivery style. Crisp and clear

  • @chipcahoon1965
    @chipcahoon1965 2 ปีที่แล้ว +1

    this was very informative. I'm in the process of developing a database capturing golfers scores, net scores, handicaps and provide points above or below course handicap. Like what the the FedX cup does.

  • @gracemark5995
    @gracemark5995 4 ปีที่แล้ว +1

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

  • @raveensharma6738
    @raveensharma6738 4 ปีที่แล้ว +1

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

  • @Dhiyaneshwar_Vlogger_12
    @Dhiyaneshwar_Vlogger_12 2 ปีที่แล้ว +1

    Wow, I'm a pro learner of Excel! But you are teaching very pretty much! Make more Useful Tips and Tricks!

  • @evperez3599
    @evperez3599 3 ปีที่แล้ว +1

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

  • @mindywert
    @mindywert 3 ปีที่แล้ว +1

    Thank you for this excellent compilation of excel tips and tricks. This was very helpful!

  • @michaellarkin5235
    @michaellarkin5235 3 ปีที่แล้ว +1

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

  • @MitkoFitko
    @MitkoFitko 4 ปีที่แล้ว +1

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

  • @Myconstituency
    @Myconstituency 3 ปีที่แล้ว +1

    The presentation is superb,so much enthralling

  • @delorissmith8248
    @delorissmith8248 3 ปีที่แล้ว +1

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

  • @maheshsanghani6380
    @maheshsanghani6380 3 ปีที่แล้ว

    Your video has many new things to learn .
    If you have more videos , please share link.
    Thanks for teaching .

    • @SeleTraining
      @SeleTraining  3 ปีที่แล้ว

      Make sure you check out the entire playlist: th-cam.com/play/PLLXmgYx8DeQz2NcgozR78wA3T7a1B31Cr.html

  • @getfanmedia
    @getfanmedia 2 ปีที่แล้ว +1

    I'm a follower of your videos they are all interesting thanks for sharing your knowledge.

  • @JhongskPass
    @JhongskPass ปีที่แล้ว +1

    this excel training videos exactly i want as a beginner

  • @tomjun8945
    @tomjun8945 4 ปีที่แล้ว +1

    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.

  • @nadim161
    @nadim161 4 ปีที่แล้ว +1

    All these functions are very handy to use everyday, most of them are new to me, is there a way i can create a list of all these function to keep them handy?

    • @SeleTraining
      @SeleTraining  4 ปีที่แล้ว +1

      In all of my videos I create a contents list in the description of the video with links to each tip. You could copy that to any other location for reference too.

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

  • @sps627
    @sps627 2 ปีที่แล้ว +1

    This is mind blowing..you just made me an expert..love you😘😘

  • @azimemad6346
    @azimemad6346 2 ปีที่แล้ว +1

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

  • @kjworland
    @kjworland 3 ปีที่แล้ว +4

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

  • @sizomdluli2988
    @sizomdluli2988 2 ปีที่แล้ว +1

    wow this is so great, wonderful lessons learned today, Thank you sir

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

  • @gargijain8553
    @gargijain8553 2 ปีที่แล้ว +1

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

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

  • @adrianawardlow4035
    @adrianawardlow4035 4 ปีที่แล้ว +1

    Excellent video. Very useful. Thanks!

  • @anmeetkaur1109
    @anmeetkaur1109 3 หลายเดือนก่อน +1

    Thanx for the cool tips. It helped me lot in my interview preparation

  • @r.lurdumaryn.rayappan7511
    @r.lurdumaryn.rayappan7511 3 ปีที่แล้ว +1

    Very good teaching sir. Just learning excel

  • @terryhaling7891
    @terryhaling7891 2 ปีที่แล้ว +1

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

  • @kenishi8781
    @kenishi8781 3 ปีที่แล้ว +1

    You sir are a life changer, thank you!

  • @pramodupadhyay9646
    @pramodupadhyay9646 3 ปีที่แล้ว +1

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

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

  • @dating_life350
    @dating_life350 ปีที่แล้ว +1

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

  • @markhunter7165
    @markhunter7165 3 ปีที่แล้ว +1

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

  • @Hellas53
    @Hellas53 3 ปีที่แล้ว +1

    The best training tips! Thanks much !

  • @ckmajumdar1
    @ckmajumdar1 4 ปีที่แล้ว +2

    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

  • @andyphillips5162
    @andyphillips5162 4 ปีที่แล้ว +1

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

  • @yvonnechrist820
    @yvonnechrist820 3 ปีที่แล้ว +1

    Hi sir thankyou so much for updating the excal sheet can you please update water ever you speak written bellow with words

  • @tamirose1646
    @tamirose1646 2 ปีที่แล้ว +1

    This is spectacular! Thank you for sharing!

  • @tomphelan7396
    @tomphelan7396 3 ปีที่แล้ว +1

    Great presentation. Useful items presented concisely. Thanks.

  • @Impedancenetwork
    @Impedancenetwork 4 ปีที่แล้ว +1

    @6:46 you don't need to select the cell. Just put your cursor on reference to the cell location "C1" and hit F4.

  • @hutster6416
    @hutster6416 2 ปีที่แล้ว +1

    You're an excellent teacher! Thanks!

  • @umeshmishra2010
    @umeshmishra2010 4 ปีที่แล้ว +1

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

  • @lynnettemckinley4636
    @lynnettemckinley4636 3 ปีที่แล้ว +2

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

  • @grandmac.168
    @grandmac.168 4 ปีที่แล้ว +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  4 ปีที่แล้ว +1

      Thanks! Glad my videos are helpful.