Excel 2016 Intermediate Tutorial

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

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

  • @djmartinez5054
    @djmartinez5054 4 ปีที่แล้ว +40

    This is the gold standard of How to Teach so that people actually learn. And plus it's free! God bless yo sir!

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

      th-cam.com/video/SfSK45GFYvM/w-d-xo.html

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

      @@teachandtrained3985 the video and the exercise file are not the same

  • @Polydoros66
    @Polydoros66 3 ปีที่แล้ว +9

    "Go ahead and catch up with me" you are just being nice. We can't catch up with you man, you are in a different level

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

    This training answers my "why" and "how" questions - I love it!!!

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

      We are glad you learned so much! Thank you for watching!

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

    Thank you so much for attaching the Excel forms to follow the class. You are a gift from Heaven! I'm watching all the ads as a way to say THANK YOU!

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

      You're very welcome!

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

      Please how did you download the Excel form. I'm a newbie, so I don't really know much about it

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

    I am appreciative of how you are explaining these tools in the simplest and effective way.

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

    Thanks

  • @domnicbollo2708
    @domnicbollo2708 3 ปีที่แล้ว +8

    I love how you particularly simplify the concepts and use recap after explaining every point.

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

      You are welcome Domnic! Thank you for watching!

  • @nickrobinson9486
    @nickrobinson9486 11 หลายเดือนก่อน +2

    Very helpful video! Great teaching style that makes it easy to practice and comprehend.

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

    Thanks very much Sean. All these for free and very clear from u. Now my career in IT is made possible by Learn it and the likes! God bless you and all. Sean ur really appreciated man

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

      Hi Ken! Glad we were able to help and good luck in IT!

  • @maler921
    @maler921 4 ปีที่แล้ว +8

    Great job Sean in teaching even it kind of complicated sometimes but with the way you teach even the beginners can pick it up.Excel need patient, perseverance and attention to details.

  • @Ben-kp1dh
    @Ben-kp1dh 3 ปีที่แล้ว +7

    Huge thanks to this guy. I learned quite a lot from this tutorial. Great teacher with fun little jokes.

  • @sasavienne
    @sasavienne 4 ปีที่แล้ว +8

    After watching the first 5 minutes, I stopped the video to *LIKE* . Thanks a lot. 👍 That is amazing.

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

    Thanks!

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

      Thank you so much Lana! Your support helps us to continue making all these videos!

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

    You are such a good teacher, maybe you should be teaching teachers how to teach. Thank you so much

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

    The best presentation ever. Can not Thank you more.

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

    Watched this before my exam and aced it 100% thanks!!!!

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

    Ah... I should have see a little below... I typed in lots of data... already. Great video!!! Thanks for being very clear without being repetitive.

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

    YOU are an Excellent Trainer... You are funny and your info is easy to follow! Thank you for this video I am work on not allowing Excel to scary me but embrace all it's possibilities! I will be looking into more of your videos👍🏻

  • @kannanaiyar5291
    @kannanaiyar5291 4 ปีที่แล้ว +7

    Thank you. I used to know Excel well, but I have not got into the newer tools that have been introduced in the last 10 years. Your explanation of the Table Tools is an eye-opener. Your style of explaining is the best I have seen.
    I have been trying to find a solution to a problem for a while, so I have been checking out a lot of other tutorials lately. I still have one nagging problem, but I learned a lot from your 3 levels of Excel videos.

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

    Thanks for providing useful information.

  • @fjennewell
    @fjennewell 7 หลายเดือนก่อน

    Aside from the value your bring to the viewers through the topics, I really appreciate your enthusiasm. We can feel it the way you speak. Just like in 00:50:57 :D Thank you so much! Learned a lot!

    • @LearnitTraining
      @LearnitTraining  7 หลายเดือนก่อน

      Sean is a Microsoft super fan! Check out his podcast here - www.youtube.com/@jumpto365

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

    This tutorial is unprecedented and it covers important features in Excel efficiently.

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

    Very nice and well paced tutorial. Thanks a lot.

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

      You are welcome! Also a big thank you for subscribing! It helps us tremendously!

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

    Very useful, well detailed, and easy to understand tutorial to learn excel. It saves a lot of time. Thank you.

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

      Thank you Kushal! We appreciate it!

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

    Yet to watch the lesson, but moved to like the video first...
    Thanks in advance!!!

  • @kaliharris8143
    @kaliharris8143 4 ปีที่แล้ว +5

    This is a fantastic video. Thank you! I will be watching them all multiple times!

  • @DoctorKeo
    @DoctorKeo 3 ปีที่แล้ว +6

    Excellent tutorial - Thanks. So ideal for the lockdown - I've no idea what I will do with these new skills when (if!) Coronavirus is defeated.

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

    Thank you so much for posting this. You're a great teacher! Learning Excel is going to help me be more employable once the pandemic is over!

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

    Excellent tutorial. Interactive nature especially useful.

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

    fantastic tutorial, great presentation, clear, concise, useful, honestly brilliant

  • @irfanshaikh-zz3ov
    @irfanshaikh-zz3ov 4 ปีที่แล้ว +12

    Good work mate.. Appreciate your efforts towards teaching excel in so simpler way.Thanks

  • @faranahmed4762
    @faranahmed4762 4 ปีที่แล้ว +7

    Excellent, quality training. Videos like these are priceless 🙌

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

    Great tutorial. Thank you for the upload

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

    I am completely filling in love for your videos!!!! Thank you so much

  • @saurabhmishra4881
    @saurabhmishra4881 5 หลายเดือนก่อน +1

    The way you taught is awesome

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

    Very detail explanation and very practical. Thank you!

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

    Great Excel Lessons. Thanks a heap. The manuals are also very helpful.

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

    Sir Please upload Excel Expert tutorial . I have learned more things from you thank you!

  • @rossgroves9554
    @rossgroves9554 4 ปีที่แล้ว +5

    Fantastic tutorial, very easy to follow, the exercise files were appreciated. Good Job.

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

    Amazing work and excellence is simply delivered... keep it up

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

    It's really helpful. Thank you very much for every detail.

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

    You are too good. Thanks for the session.

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

    Great way of delivering the material, details are very important. I am very much obliged . Keep safe.

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

    I'm loving these videos thank you so much! where can we find the "Global Wine Sales" file?

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

    Great video and explained in a fun/ interactive way. thank you!

  • @stevehunt525
    @stevehunt525 4 ปีที่แล้ว +18

    It's strange that the screen recording software is not showing any of the sub menus, like the conditional formatting section

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

    Highly enjoyed your training video!!!

  • @JohnS-il1dr
    @JohnS-il1dr 2 ปีที่แล้ว +2

    awesome tutorials and thank you very much! just an observation the sub menus are not showing up especially during the Numbers Filter tutorial where you choose "less than" at 20.18

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

    Awesome 👏 that You provide exercises file as well . Really amazing !😉

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

    Very informative tutorial. Clearly explained and justified.

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

    This is absolute quality. The best Excel course I have seen on the internet. Kudos to you man :)

  • @RohitChouhan-dj7se
    @RohitChouhan-dj7se 4 ปีที่แล้ว +4

    MINE OF INFORMATION
    THANKS FOR THE QUALITY VIDEO

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

    Wow this is awesome video dude. You explain it so easy to understand and this will definitely help me in my daily work. 👌🙏👍 Now I need to create source file with 3 different regions with chart presentation. I going to search in your video for help thanks

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

    Executive Coaching! Good stuff.

  • @mpumiedubesiwela1188
    @mpumiedubesiwela1188 4 หลายเดือนก่อน +1

    Wow! what a tutorial, incredible work thank you. I wanted to know how to i access the excel files and be able to make changes. Currently shows an read-only files on my end. Thanks

    • @LearnitTraining
      @LearnitTraining  4 หลายเดือนก่อน

      Thanks Mpumie! You can download the file and save a copy. You can then edit that copy all you want.

  • @MiguelArevalo
    @MiguelArevalo 4 ปีที่แล้ว +18

    Where can we find the Global Wine Sales file for importing the data exercise?
    The link above leads only to the main workbook.

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

    Thank You kindly for that lecture it was great.

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

    Can you please send another version of the exercise file so that I can practice on it?I'm not able to download it from the description. Extremely helpful video btw!

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

    Awesome Tutorial. Thank you

  • @369-DRK
    @369-DRK 3 ปีที่แล้ว +1

    Very interesting specially Pivot tables, Data validation and Conditional formatting . you made me subscribe this channel. 1,2,3,4 Don't tell anyone 😉

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

    Very helpful video. Thanks

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

    Great tutorial for Excel. Thanks so much!

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

    Good work sir. Your teaching style is awesome.

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

      Thank you Ramraj! A bigger thank you for subscribing as that really helps us!

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

    Thanks for great lesson. So easy to understand.

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

    Elegantly presented........amazing.

  • @deemcghee-piepie3089
    @deemcghee-piepie3089 3 ปีที่แล้ว +1

    I enjoy your voice and you are amazing!

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

    Huge Thanks! Appreciate your efforts.

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

    You are an amazing teacher! I learned so much from this training video and I really enjoyed listening to your calm and pleasant voice. Thank you for sharing!!

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

    Thank you for spending time and post this amazing video. It was very informative and I learn a lot. Great jobs. Thank you again! :-)

  • @t3geek
    @t3geek 5 ปีที่แล้ว +11

    I appreciate the rationale behind the Excel reasoning/logic!

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

      This article is great to know! How to subtract in Excel? > l.linklyhq.com/l/5rOi

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

    Very good tutorial. Excellent job!

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

    Great and Thorough tutorial! Thank you!

  • @Jess-hv6rq
    @Jess-hv6rq 4 ปีที่แล้ว +4

    Thank you for making this video. I really learned a lot! Keep up the good work!

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

    Excellent tutorial - I learned so much. Thank you.

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

    Brilliant! Excellent tutorial.

  • @haneefqaazee3988
    @haneefqaazee3988 4 ปีที่แล้ว +5

    Thank you very much Sean!
    This is a great video.

  • @OmarMohamed-rq8ww
    @OmarMohamed-rq8ww 2 ปีที่แล้ว +1

    Best tutorial bro I appreciated and I thank you for presenting it

  • @chanthathou3274
    @chanthathou3274 4 ปีที่แล้ว +10

    I am so much appreciated to your full details.

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

    Around the 34:00 minute mark you remove duplicates by EMP#, but the one they removed was the one we didn't want removed. Her last name was changed in the system and we wanted to get rid of the row with her maiden name. How would you correct this error?

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

    Great learning experience once again. Looking forward to your teaching methodolies in more excel tutotrials. Regards,

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

    you are a talented teacher

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

    thank you , very good tutoring

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

    Your the best. God bless you

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

    Many thanks for this well presented information.. I have created a count down timer in a worksheet using the command buttons to for start and stop. My problem is when I try to repeat this in other worksheets I keep getting an ambiguity error. Can you explain how I can use command buttons in several worksheets in a workbook?

  • @Teacherman1955
    @Teacherman1955 5 ปีที่แล้ว +4

    Which exercise file covers this video? I like the way you cover the different functions and formulas, giving the viewer time to practice each one before advancing to the next. Also, I like the way you cover each one, explaining them in easy to understand language.

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

    Great tutorial! It helped a lot understand powerful excel functions. Thanks alot.. :)

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

    Great vid! Where’s part 1? Could you share the link? Thanks!

  • @seyitalp7644
    @seyitalp7644 7 หลายเดือนก่อน +1

    lecturer has a great voice btw

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

    I think I love you. Thank you so much.

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

    Amazing tutorials!

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

    Thank you for this tutorial!

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

    Excellent!
    But l would love that with the video, you add to the materials to practice or teach with, so that the teaching becomes simple.

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

      Exercise Files: bit.ly/2HDoEpM

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

      @@LearnitTraining Thanks so much, for sending me materials to practice with, l'm very grateful.
      God bless you.
      😘

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

    When you talk about conditional formatting - thing which you click are not seen on a screen here, it means we cannot se what you are doing...

  • @younissyousif1260
    @younissyousif1260 11 หลายเดือนก่อน

    Abig thanks for teaching in intermediate Level

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

    Man , what a great video , thnx so much for the time u spend doing this it's just great , but i cant find the global wine sales file , did u move it ? thnx in advanced

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

    thank you so much great tutorial

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

    thanks so much for the tutorial. May Allah bless you

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

    This was Fantastic! Thank you!

  • @Mmm.5255
    @Mmm.5255 4 ปีที่แล้ว +1

    Week starts with Monday, not Sunday, and it is DD.MM.YYYY(it's seconds, minutes, hours, days, months, years etc and not the other way around guys). These are logical, universal, and normal, but some people try to be unreasonably different

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

    I just realised that at 34:00, excel deleted any smyth instead of amy tooley. I guess we have no control on what excel should delete from among two data set.