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.

[@kaliharris8143]

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

[@rossgroves9554]

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

[@irfanshaikh-zz3ov]

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

[@dayanajonsongoncalvesgener6005]

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

[@faranahmed4762]

Excellent, quality training. Videos like these are priceless 🙌

[@Paulus_Wachu]

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

[@Jess-hv6rq]

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

[@veronicaromero8642]

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

[@amysu4465]

Very detail explanation and very practical. Thank you!

[@maler921]

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]

Thank you Lerma!

[@pushpalatasinha5877]

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

[@abhishekroy8125]

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

[@HOTTBUTTERLUV]

I am truly loving these videos.

[@kannanaiyar5291]

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]

Glad it was helpful!

[@chanthathou3274]

I am so much appreciated to your full details.

[@sasavienne]

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

[@eleanorastaphan2302]

Excellent tutorial. Interactive nature especially useful.

[@turboromy]

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.

[@djmartinez5054]

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

[@teachandtrained3985]

kzbin.info/www/bejne/iZe2fGdrfKuMrK8

[@jamajama7159]

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

[@coolangelhouse]

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

[@rosecanjura9799]

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

[@Polydoros66]

"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

[@thefamouseugenekrabs]

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]

You're very welcome! Good luck!

[@babuumakantvuppala9598]

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

[@shzb1]

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

[@domnicbollo2708]

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

[@LearnitTraining]

You are welcome Domnic! Thank you for watching!

[@stevehunt525]

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

[@MiguelArevalo]

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

[@Valhalaal]

Very informative tutorial. Clearly explained and justified.

[@sasavienne]

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

[@donnaw555]

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

[@LearnitTraining]

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

[@frag_out1500]

Huge Thanks! Appreciate your efforts.

[@FelixArdLykke]

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

[@nickrobinson9486]

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

[@LearnitTraining]

Glad it was helpful!

[@earth7451]

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]

You're very welcome!

[@akaghaprosper]

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

[@kushalkirti4123]

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

[@LearnitTraining]

Thank you Kushal! We appreciate it!

[@kensimba7868]

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]

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

[@chantellenorman4714]

Highly enjoyed your training video!!!

[@Drakkle]

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

[@Ben-kp1dh]

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

[@LearnitTraining]

Glad you enjoyed it!

[@dannnnnnnnnnnnnnn595]

Thanks for providing useful information.

[@jessicapfeifer723]

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]

You are very welcome Jessica!

[@ricro880]

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?

[@LightRibbon]

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

[@LearnitTraining]

Glad you enjoyed it!

[@JohnS-il1dr]

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

[@chriswattson2476]

Excellent tutorial - I learned so much. Thank you.

[@teachandtrained3985]

kzbin.info/www/bejne/iZe2fGdrfKuMrK8

[@karianderson5912]

Brilliant! Excellent tutorial.

[@marka565]

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]

Thank you for watching!

[@fjennewell]

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]

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

[@DoctorKeo]

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]

You're very welcome!

[@TheFrancisChowdhury]

Very nice and well paced tutorial. Thanks a lot.

[@LearnitTraining]

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

[@joe21lester]

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

[@haneefqaazee3988]

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

[@LearnitTraining]

My pleasure!

[@javiqbal637]

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

[@LearnitTraining]

Thank you for watching Jav!

[@jijojose2574]

You are too good. Thanks for the session.

[@amaruf2008]

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

[@LearnitTraining]

You are welcome!

[@excelsquad8518]

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

[@nghiepdam2061]

Great tutorial for Excel. Thanks so much!

[@LearnitTraining]

You're very welcome!

[@vivienzhang4457]

Great and Thorough tutorial! Thank you!

[@LearnitTraining]

You're very welcome!

[@nishanthk8314]

i was trying to create one printable form Can you help me 1. One Excel sheet to Create a form . Once i fill this form it should be print . next will be on the same form 2 print with different data. LIKE Print 1 data should save in excel table like wise print 2 below like that print 3 so on

[@huijiang4532]

The best presentation ever. Can not Thank you more.

[@LearnitTraining]

You're very welcome!

[@ToXiCdArT5796]

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

[@LearnitTraining]

You are welcome!

[@theoptimist6252]

Great tutorial. Thank you for the upload

[@LearnitTraining]

Glad it was helpful!

[@ErickHelena]

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

[@fleckyb71]

Awesome tutorials.

[@hazemali382]

Many Thanks Learnit Taring

[@t3geek]

I appreciate the rationale behind the Excel reasoning/logic!

[@kwrer6087]

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

[@janege8]

thank you , very good tutoring

[@lanhrefons2029]

Executive Coaching! Good stuff.

[@TheBHanif]

How do you import data from the web or even another workbook on mac? I can't seem to follow the method as here it only allows 'from html' which opens a finder window for local files.

[@Teacherman1955]

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.

[@nky9548]

Why when i click download the file is for vba not the file that covered for this vid?

[@micheledachille8130]

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?

[@jsphwckd]

about the remove duplicate, what if it removes the change data instead of the unchanged? does it occur?

[@AestheticLinesUrdu]

Thanks for great lesson. So easy to understand.

[@LearnitTraining]

You're very welcome!

[@wiser1147]

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!

[@MrTNVolsFan]

When you click on some tools like Conditional Formatting, the drop downs do not show in the video!

[@vicvic553]

1:02:52 - how did you chage the format, in my case I only see a quick analysis, to fill with format?

[@ebenezertanwani4011]

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

[@LearnitTraining]

You are very welcome!

[@sammitchell7310]

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

[@LearnitTraining]

Excellent!

[@usmanabdullahi3560]

Awesome Tutorial. Thank you

[@LearnitTraining]

You're welcome!

[@joseeduardotschen9186]

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

[@RohitChouhan-dj7se]

MINE OF INFORMATION THANKS FOR THE QUALITY VIDEO

[@qimipa3316]

Very good tutorial. Excellent job!

[@LearnitTraining]

Thank you! Cheers!

[@lechkoper5378]

Thank You kindly for that lecture it was great.

[@LearnitTraining]

You are very welcome Lech!

[@fritzlingako7179]

Is there a way to show the image in the cell using the url link? (without downloading the iamge in my computer)

[@droopy_911]

This is gold 🙏😍💜💜💜💜

[@SleepEatWorkRepeat]

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?

[@videojesco89]

Hi stimated teacher, I don´t find the glogal wine sales files! where is it?

[@2902967]

Thanks a lot Sean, you are amazing. I would like to tell you I learnt a lot from this video.

[@LearnitTraining]

Glad you liked it!

[@cherylfountain5348]

This was Fantastic! Thank you!

[@LearnitTraining]

You're so welcome!

[@feralcanadian3947]

Very helpful video. Thanks

[@LearnitTraining]

You're welcome

[@curlymosquito2089]

When you removed the duplicate, you removed the new row you just added with Amy's new last name. Is there a way to choose which duplicate to remove?

[@monicachau4416]

Thank you for this tutorial!

[@LearnitTraining]

You are so welcome!

[@joe21lester]

Thank you very very much.

[@deemcghee-piepie3089]

I enjoy your voice and you are amazing!

[@LearnitTraining]

Thank you so much!

[@saurabhmishra4881]

The way you taught is awesome

[@LearnitTraining]

Thanks!

[@aaronrambo1996]

I watched the beginers tutorial and came to this but it seems like a huge jump. Im very new to excell. Is there an order to rhe videos i need to watch?

[@hemaanthsivakumar2118]

This video is not the follow up to the one you watched - its from a different course This is the link to the video to the video you want to watch: kzbin.info/www/bejne/g5aufZKka7icj7s

[@gautheny]

Amazing sir.

[@OmarMohamed-rq8ww]

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

[@LearnitTraining]

Our pleasure!