Excel 2016 Intermediate Tutorial

Excel 2016 Intermediate Tutorial
Get Ad-Free Training by becoming a member today!
/ @learnittraining
Exercise Files: bit.ly/2HDoEpM
Who it's For: Anyone currently using Microsoft Excel, or anyone who wants to learn how!
What it is: Excel is a popular Microsoft application that organizes and analyzes data.
What You'll Learn: Our beginner videos start with simple tasks like selecting cells and entering data, then quickly move to calculating data with basic formulas and functions. The intermediate portion shows you how simple it is to sort and filter and then moves to one of Excel’s most popular features, Pivot Tables. Our advanced videos start with functions like IF and VLOOKUP and finish up with Macros.
For ad free training and certificates please join Learnit Anytime:
www.learnitanytime.com
For Private Group Trainings please visit:
www.learnit.com/private-group...
Exercise Files: bit.ly/2HDoEpM
Manuals: bit.ly/30xZb59
Username: manuals
Password: password
Start 0:00
Flash Fill 0:03
List Design & Single Level Sorting 2:28
Multi-Level Sorting 4:52
Custom Sorting 8:20
Filtering 11:33
Multi-Level Filtering 15:40
Search Filtering 17:34
Format as Table 21:47
Table Style Options 25:13
Remove Duplicates 29:12
Convert to Range 34:07
Subtotal 34:51
Multi-Level Subtotaling 40:32
Remove Subtotals 42:59
Quick Analysis Charts 43:29
Inserting Data Charts 46:53
Formatting Data Charts 51:46
Chart Templates 57:21
Sparklines 1:01:28
Printing Charts 1:06:18
Importing From Web 1:08:18
MS Query 1:14:33
Exporting Overview 1:21:12
Pivot Tables 1:22:50
Multiple-Field Pivot Tables 1:31:03
Drill Down Reports 1:36:10
Pivot Charts & Grouping Fields 1:38:52
Slicer Tool 1:47:18
Data Validation 1:54:28
Additional Data Validation 2:03:12
Cell & Sheet Protection 2:09:30
File Encryption 2:14:58
Conditional Formatting 2:17:28
Linking Data 2:25:34
Inserting Comments 2:32:25
#Excel
(C) 2021 Learnit, Inc.
Any illegal reproduction of this content will result in immediate legal action.

Пікірлер: 398

  • @djmartinez5054
    @djmartinez50544 жыл бұрын

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

    kzread.info/dash/bejne/hZqHrZZud6m_prA.html

  • @jamajama7159

    @jamajama7159

    3 жыл бұрын

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

  • @Polydoros66
    @Polydoros663 жыл бұрын

    "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

  • @irfanshaikh-zz3ov
    @irfanshaikh-zz3ov4 жыл бұрын

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

  • @kaliharris8143
    @kaliharris81433 жыл бұрын

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

  • @faranahmed4762
    @faranahmed47624 жыл бұрын

    Excellent, quality training. Videos like these are priceless 🙌

  • @rossgroves9554
    @rossgroves95544 жыл бұрын

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

  • @dayanajonsongoncalvesgener6005
    @dayanajonsongoncalvesgener60054 жыл бұрын

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

  • @Paulus_Wachu
    @Paulus_Wachu2 жыл бұрын

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

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

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

  • @LearnitTraining

    @LearnitTraining

    Жыл бұрын

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

  • @chanthathou3274
    @chanthathou32744 жыл бұрын

    I am so much appreciated to your full details.

  • @Jess-hv6rq
    @Jess-hv6rq4 жыл бұрын

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

  • @sasavienne
    @sasavienne4 жыл бұрын

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

  • @maler921
    @maler9213 жыл бұрын

    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.

  • @LearnitTraining

    @LearnitTraining

    3 жыл бұрын

    Thank you Lerma!

  • @HOTTBUTTERLUV
    @HOTTBUTTERLUV4 жыл бұрын

    I am truly loving these videos.

  • @amysu4465
    @amysu44654 жыл бұрын

    Very detail explanation and very practical. Thank you!

  • @veronicaromero8642
    @veronicaromero86424 жыл бұрын

    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👍🏻

  • @earth7451
    @earth74513 жыл бұрын

    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

    Жыл бұрын

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

  • @turboromy
    @turboromy4 жыл бұрын

    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.

  • @eleanorastaphan2302
    @eleanorastaphan23024 жыл бұрын

    Excellent tutorial. Interactive nature especially useful.

  • @pushpalatasinha5877
    @pushpalatasinha58773 жыл бұрын

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

  • @Valhalaal
    @Valhalaal4 жыл бұрын

    Very informative tutorial. Clearly explained and justified.

  • @coolangelhouse
    @coolangelhouse4 жыл бұрын

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

  • @domnicbollo2708
    @domnicbollo27083 жыл бұрын

    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!

  • @babuumakantvuppala9598
    @babuumakantvuppala95984 жыл бұрын

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

  • @frag_out1500
    @frag_out15004 жыл бұрын

    Huge Thanks! Appreciate your efforts.

  • @kannanaiyar5291
    @kannanaiyar52913 жыл бұрын

    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.

  • @LearnitTraining

    @LearnitTraining

    3 жыл бұрын

    Glad it was helpful!

  • @thefamouseugenekrabs
    @thefamouseugenekrabs3 жыл бұрын

    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!

  • @LearnitTraining

    @LearnitTraining

    3 жыл бұрын

    You're very welcome! Good luck!

  • @chantellenorman4714
    @chantellenorman47144 жыл бұрын

    Highly enjoyed your training video!!!

  • @rosecanjura9799
    @rosecanjura97994 жыл бұрын

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

  • @shzb1
    @shzb14 жыл бұрын

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

  • @Ben-kp1dh
    @Ben-kp1dh3 жыл бұрын

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

  • @LearnitTraining

    @LearnitTraining

    3 жыл бұрын

    Glad you enjoyed it!

  • @dannnnnnnnnnnnnnn595
    @dannnnnnnnnnnnnnn5954 жыл бұрын

    Thanks for providing useful information.

  • @karianderson5912
    @karianderson59124 жыл бұрын

    Brilliant! Excellent tutorial.

  • @Drakkle
    @Drakkle4 жыл бұрын

    Thanks for the video! There's some useful stuff in here, I didn't know about quick filtering - I always clicked and dragged the top column manually. I do have an unrelated question though - what did you use to present this? I liked the click and drag boxes/arrows that you were able to make on the fly. It looked like it overlayed as you went along and that would be handy

  • @FelixArdLykke
    @FelixArdLykke4 жыл бұрын

    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

  • @joe21lester
    @joe21lester4 жыл бұрын

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

  • @kushalkirti4123
    @kushalkirti41233 жыл бұрын

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

  • @LearnitTraining

    @LearnitTraining

    3 жыл бұрын

    Thank you Kushal! We appreciate it!

  • @kensimba7868
    @kensimba78683 жыл бұрын

    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

    3 жыл бұрын

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

  • @lanhrefons2029
    @lanhrefons20294 жыл бұрын

    Executive Coaching! Good stuff.

  • @saurabhmishra4881
    @saurabhmishra48819 күн бұрын

    The way you taught is awesome

  • @LearnitTraining

    @LearnitTraining

    9 күн бұрын

    Thanks!

  • @jijojose2574
    @jijojose25743 жыл бұрын

    You are too good. Thanks for the session.

  • @amaruf2008
    @amaruf20083 жыл бұрын

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

  • @LearnitTraining

    @LearnitTraining

    3 жыл бұрын

    You are welcome!

  • @chriswattson2476
    @chriswattson24764 жыл бұрын

    Excellent tutorial - I learned so much. Thank you.

  • @teachandtrained3985

    @teachandtrained3985

    4 жыл бұрын

    kzread.info/dash/bejne/hZqHrZZud6m_prA.html

  • @nickrobinson9486
    @nickrobinson94867 ай бұрын

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

  • @LearnitTraining

    @LearnitTraining

    6 ай бұрын

    Glad it was helpful!

  • @fjennewell
    @fjennewell2 ай бұрын

    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

    2 ай бұрын

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

  • @sasavienne
    @sasavienne4 жыл бұрын

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

  • @haneefqaazee3988
    @haneefqaazee39884 жыл бұрын

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

  • @LearnitTraining

    @LearnitTraining

    3 жыл бұрын

    My pleasure!

  • @LightRibbon
    @LightRibbon2 жыл бұрын

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

  • @LearnitTraining

    @LearnitTraining

    2 жыл бұрын

    Glad you enjoyed it!

  • @stevehunt525
    @stevehunt5254 жыл бұрын

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

  • @fleckyb71
    @fleckyb714 жыл бұрын

    Awesome tutorials.

  • @MiguelArevalo
    @MiguelArevalo4 жыл бұрын

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

  • @hazemali382
    @hazemali3824 жыл бұрын

    Many Thanks Learnit Taring

  • @huijiang4532
    @huijiang45322 жыл бұрын

    The best presentation ever. Can not Thank you more.

  • @LearnitTraining

    @LearnitTraining

    2 жыл бұрын

    You're very welcome!

  • @sammitchell7310
    @sammitchell73103 жыл бұрын

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

  • @LearnitTraining

    @LearnitTraining

    3 жыл бұрын

    Excellent!

  • @ricro880
    @ricro8804 жыл бұрын

    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?

  • @usmanabdullahi3560
    @usmanabdullahi35602 жыл бұрын

    Awesome Tutorial. Thank you

  • @LearnitTraining

    @LearnitTraining

    2 жыл бұрын

    You're welcome!

  • @javiqbal637
    @javiqbal6373 жыл бұрын

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

  • @LearnitTraining

    @LearnitTraining

    3 жыл бұрын

    Thank you for watching Jav!

  • @janege8
    @janege84 жыл бұрын

    thank you , very good tutoring

  • @RohitChouhan-dj7se
    @RohitChouhan-dj7se4 жыл бұрын

    MINE OF INFORMATION THANKS FOR THE QUALITY VIDEO

  • @theoptimist6252
    @theoptimist62522 жыл бұрын

    Great tutorial. Thank you for the upload

  • @LearnitTraining

    @LearnitTraining

    2 жыл бұрын

    Glad it was helpful!

  • @TheFrancisChowdhury
    @TheFrancisChowdhury2 жыл бұрын

    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!

  • @DoctorKeo
    @DoctorKeo3 жыл бұрын

    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.

  • @LearnitTraining

    @LearnitTraining

    3 жыл бұрын

    You're very welcome!

  • @JohnS-il1dr
    @JohnS-il1dr2 жыл бұрын

    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

  • @nghiepdam2061
    @nghiepdam20614 жыл бұрын

    Great tutorial for Excel. Thanks so much!

  • @LearnitTraining

    @LearnitTraining

    4 жыл бұрын

    You're very welcome!

  • @vivienzhang4457
    @vivienzhang44572 жыл бұрын

    Great and Thorough tutorial! Thank you!

  • @LearnitTraining

    @LearnitTraining

    2 жыл бұрын

    You're very welcome!

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

    Thanks for great lesson. So easy to understand.

  • @LearnitTraining

    @LearnitTraining

    Жыл бұрын

    You're very welcome!

  • @ebenezertanwani4011
    @ebenezertanwani401111 ай бұрын

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

  • @LearnitTraining

    @LearnitTraining

    11 ай бұрын

    You are very welcome!

  • @feralcanadian3947
    @feralcanadian39472 жыл бұрын

    Very helpful video. Thanks

  • @LearnitTraining

    @LearnitTraining

    2 жыл бұрын

    You're welcome

  • @droopy_911
    @droopy_9113 жыл бұрын

    This is gold 🙏😍💜💜💜💜

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

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

  • @joe21lester
    @joe21lester4 жыл бұрын

    Thank you very very much.

  • @ErickHelena
    @ErickHelena4 жыл бұрын

    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

  • @marka565
    @marka5652 жыл бұрын

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

  • @LearnitTraining

    @LearnitTraining

    2 жыл бұрын

    Thank you for watching!

  • @cherylfountain5348
    @cherylfountain53482 жыл бұрын

    This was Fantastic! Thank you!

  • @LearnitTraining

    @LearnitTraining

    2 жыл бұрын

    You're so welcome!

  • @ToXiCdArT5796
    @ToXiCdArT57962 жыл бұрын

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

  • @LearnitTraining

    @LearnitTraining

    2 жыл бұрын

    You are welcome!

  • @excelsquad8518
    @excelsquad85184 жыл бұрын

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

  • @monicachau4416
    @monicachau44163 жыл бұрын

    Thank you for this tutorial!

  • @LearnitTraining

    @LearnitTraining

    3 жыл бұрын

    You are so welcome!

  • @abinashkarmakar360
    @abinashkarmakar3603 жыл бұрын

    Thank learnit for this..

  • @LearnitTraining

    @LearnitTraining

    3 жыл бұрын

    Thank you for watching!

  • @qimipa3316
    @qimipa33163 жыл бұрын

    Very good tutorial. Excellent job!

  • @LearnitTraining

    @LearnitTraining

    3 жыл бұрын

    Thank you! Cheers!

  • @gautheny
    @gautheny4 жыл бұрын

    Amazing sir.

  • @t3geek
    @t3geek4 жыл бұрын

    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

  • @chauvo9013
    @chauvo90133 жыл бұрын

    Excellent! Thank you!

  • @LearnitTraining

    @LearnitTraining

    3 жыл бұрын

    Glad you enjoyed it!

  • @jessicapfeifer723
    @jessicapfeifer7233 жыл бұрын

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

  • @LearnitTraining

    @LearnitTraining

    3 жыл бұрын

    You are very welcome Jessica!

  • @CuliCongSo
    @CuliCongSo3 жыл бұрын

    I ❤️ this video.

  • @andreealungu213
    @andreealungu2133 жыл бұрын

    Thank you so so so much!!!

  • @LearnitTraining

    @LearnitTraining

    3 жыл бұрын

    You are welcome!

  • @MJ-be7ob
    @MJ-be7ob2 жыл бұрын

    Great, Thanks

  • @LearnitTraining

    @LearnitTraining

    2 жыл бұрын

    You are welcome!

  • @lechkoper5378
    @lechkoper53783 жыл бұрын

    Thank You kindly for that lecture it was great.

  • @LearnitTraining

    @LearnitTraining

    3 жыл бұрын

    You are very welcome Lech!

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

    Thanks

  • @easymatheducationalandictc1376
    @easymatheducationalandictc13763 жыл бұрын

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

  • @LearnitTraining

    @LearnitTraining

    3 жыл бұрын

    Hope you like it!

  • @saeedyousefi2755
    @saeedyousefi27552 жыл бұрын

    It was amazing . Thank you .

  • @LearnitTraining

    @LearnitTraining

    2 жыл бұрын

    You're welcome 😊

  • @younissyousif1260
    @younissyousif12606 ай бұрын

    Abig thanks for teaching in intermediate Level

  • @micheledachille8130
    @micheledachille81304 жыл бұрын

    Truly awesome tutorial, thanks a ton. Just one thing though: when I downloaded the exercise files from the link in your description I didn't get the Global Wine Sales file, where do I find it?

  • @tarekalsherif57
    @tarekalsherif573 жыл бұрын

    Your are amazing! Thank you very much

  • @LearnitTraining

    @LearnitTraining

    3 жыл бұрын

    You're very welcome!

  • @vanycdtd08
    @vanycdtd084 жыл бұрын

    thanks!

  • @rizk852003
    @rizk8520033 жыл бұрын

    thank you so much great tutorial

  • @LearnitTraining

    @LearnitTraining

    3 жыл бұрын

    You're very welcome!

  • @elizabethbremmer3757
    @elizabethbremmer37572 жыл бұрын

    Amazing tutorials!

  • @LearnitTraining

    @LearnitTraining

    2 жыл бұрын

    Glad you like them!

  • @wiser1147
    @wiser11473 жыл бұрын

    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!

  • @aigulzhaparova7578
    @aigulzhaparova75784 жыл бұрын

    Thank you

  • @joseeduardotschen9186
    @joseeduardotschen91864 жыл бұрын

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

  • @vicvic553
    @vicvic5533 жыл бұрын

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