Microsoft Excel 2016 - Learn Excel 2016 Beginners Tutorial Video
Exercise Files: bit.ly/4a5OMBO
Learn Microsoft 2016 from the pro's. In this FREE beginners tutorial for Microsoft 2016 you will learn the basics of Excel 2016, and Tips and Tricks so that you can get the most out of your Excel experience. 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.
Some of the other topics in the Microsoft Excel 2016 tutorial include:
Start Screen & Templates, Ribbon & QA Toolbar - Part 1, Ribbon & QA Toolbar - Part 2, Backstage View, Interface, Share Pane, Tell Me, Smart Lookup, Navigating, Keyboard Shortcuts, Entering Text
Formatting Numbers, Deleting & Formatting, AutoSum, Simple Formulas, Simple Functions, Absolute Referencing, Inserting Rows
Inserting Columns, Moving & Copying Data, Autofill, Cell Styles, Worksheet Themes, Excel Templates, Grouping Worksheets, Freeze Panes, Custom Views, Spell Check, Printing, Flash Fill, List Design & Single Level Sorting, Multi-Level Sorting, Custom Sorting, Filtering, Multi-Level Filtering, Search Filtering, Format as Table, Table Style Options, Remove Duplicates, Convert to Range, Subtotal, Multi-Level, Subtotaling, Remove Subtotals, Quick Analysis Charts, Inserting Data Charts, Formatting Data Charts, Chart, Templates, Spark lines, Printing Charts, Importing From Web, MS Query, Exporting Overview, Pivot Tables, Multiple-Field Pivot Tables, Drill Down Reports, Pivot Charts & Grouping Fields, Slicer Tool, Data Validation - Part 1, Data Validation - Part 2, Cell & Sheet Protection, File Encryption, Conditional Formatting, Linking Data, Inserting Comments.. and more
Please subscribe to Learn iT! and check out our website (learnit.com) to browse other Microsoft Courses, Project Management, and IT Training courses.
For ad free training and certificates please join Learnit Anytime:
www.learnitanytime.com
For Private Group Trainings please visit:
www.learnit.com/private-group...
#Excel
(C) 2021 Learnit, Inc.
Any illegal reproduction of this content will result in immediate legal action.
Пікірлер: 462
2:44 the Ribbon 3:07 Command groups 4:38 Quick access toolbar 6:36 how to add hidden commands to the quick access toolbar 12:15 File tab 16:40 Account 16:46 Office theme - to change the ribbon's color 19:30 Cell map field - active cell 21:00 21:11 collapse the ribbon 22:18 share tool 24:42 tell me what you want me to do bar 27:00 - Smart Lookup - very cool features that allow you to look up something you don't know without using google. 33:28 Formula bar 34:10 view field 34:22 Zoom field 34:50 scroll bar 36:23 see the furthest row 36:46 See the furthest columns 38:30 Keyboard shortcuts 41:10 Save as shortcut - F12 key 44:55 Enter Key 45:06 Tab key 45:22 Shift+Enter key 45:39 Shift+Tab key 46:15 F2 key 48:16 and 50:17 fixing numbers 52:52 to stay on the cell 54:18 resizing a column and/or row 56:40 Calculating the total (sum) 1:00:38 Calculating the subtotal 1:07:26 Calculating the Average 1:09:20 Calculating tax charges 1:10:20 Autofill to copy a formula 1:13:38 Using absolute value to lock one particular cell's value 1:17:16 Inserting a row 1:20:26 Inserting a column 1:22:12 Cut and Paste cells 1:24:04 Autofilling days of the week 1:24:30 Autofilling dates 1:28:14 Cell Styles 1:34:30 Page Layout - Color theme 1:37:28 Saving your personal theme 1:38:50 Saving a pre-formatted Sheet - Template 1:41:23 Opening up your template 1:45:10 Creating a duplicate worksheet (Ctrl Key + drag to the right) 1:46:10 Renaming worksheets 1:47:10 Changing a Cell and reflect it on all the worksheets (Ctrl + select all worksheet) 1:51:10 Using the freeze panes 1:55:44 Using Custom views 1:56:54 Hiding rows and columns 2:02:06 Using the Spellcheck (F7 Key) 2:03:40 & 2:04:20 Printing the worksheet
@guunsie9727
6 жыл бұрын
but why
@MrSushant3
6 жыл бұрын
*R E S P E C T* 👏
@varuncharavanan9169
6 жыл бұрын
Give this person a medal 👏🏻👏🏻👏🏻
@adriankasa4339
6 жыл бұрын
God bless you
@jamesperry3837
6 жыл бұрын
Tx. You just saved me 2:08:30. I could just look it up if i wanted to. Tx again.
I just want to say I am so grateful for this video. I just recently retired and the young people where I had worked for years would help me just get through some of the aspects of Excel as some of the things we had to do were done on Excel spreadsheets and sent to us. Even after they would show me I had no clue what happened just was happy they were there to help. By watching this video I was able to build my own template with formulas in certain cells (and to my surprise they worked!). I even edited my template because after I had saved it I decided I wanted some additional information. I also did 12mo's of sheets as well. I am beyond excited that at my age I could actually do this!! THANK YOU SEAN!! I have partially watched some of the videos made by others but just couldn't find one that was for a true, non-techy beginner until I came across your video. Thanks again!!
THANKS! This was the best hands on tutorial ever. Passed my excel 2016 assessment with a 91% and got the job. I HAVE NEVER used this application and was a for real beginner. Thanks again, Sean :)
This is where I started my excel career, I can never forget the background you gave me. Today I have a channel just like this (Data with Decision channel) You are great.
@LearnitTraining
3 жыл бұрын
Thank you and good luck with your channel!
Hi Sean! Thank you so much! You are a great teacher. You know how to relay information to people in a clear accessible way. You can see the information through the students eyes without rushing them thru it, or making them feel like idiots! Thank you again. I am glad I stumbled upon this course! It is the best I have found and will recommend. .
My small community in the desert was looking for some basic tutorials on Excel and I did not have the time to start a small class. I have given them this link and they are so excited about using your video for the basics. You are a good teacher. Keep up the good work.
Your tutorial is excellent Sean! I have tried many others but your are precise, patient, and very clear. I am taking this as a refresher and a long time Excel user but you still showed me some new tools and functions. Appreciate your sharing and professionalism. Please keep up the great work!!!
Thank you, Sean! This tutorial is absolutely the best!! You make Excel fun to learn - a top-notch teacher for sure.
Best tutorial for Excel i've found so far. Thank you !
This is what i call a real teacher. Many thanks to you for the time and energy.
Very clear and detailed tutorial. I'm a slow learner and had no problem understanding everything.
@indiabliss
7 жыл бұрын
Diana Marco
Wow! It was a very scintillating tutorial. Keep this tremendous work glowing Mr. Sean. I am a beginner but I have more now from this tutorial that I feel like I have got the whole thing.Thank you.
Thank you so much for doing such an excellent training. It was at a great pace and easy to understand format! You're the real deal!
Thank you Sean..I am new to excel. I have watched a lot of tutorials but so far this is the best one. I learned more from this tutorial than all the other ones combined. Keep up the good work.
This is very comprehensive quality tutorial thank yo
For once, my heart popped out because of those paranormal activity of cell styles. Excellent tutorial maestro. :D
Amazing, well paced, easy to follow, well spoken, great visuals learned lots! Thank you! :)
The best excel on youtube. This instructor has alot of insight in excel and delivers what he knows in excellent manner. I appreciate this guys🙏
@LearnitTraining
Жыл бұрын
You're very welcome!
This is a very good tutorial. I really learnt a lot even though I have been using Excel for some time, I must admit there were many things I didn't know of. Keep it up.
Very clear tutorial! Love it! Thank you!
Sean, you are a great teacher!! I hardly learnt anything the entire year from my college IT Professors but after learning from you , it really feels like I have learnt something FAR WAY PRODUCTIVE!! Thank you so much, this tutorial is epic!!
@ganesh5041
4 жыл бұрын
hey is this full course and in the playlist can i learn full excel and get job in mis department.
@aishwaryabadhe6865
4 жыл бұрын
@@ganesh5041 it includes almost all the formulas n shortcuts required for a job. But u can always look for some more videos by this channel.
Such a GREAT tutorial. If you can spear the 2 hours, watch it. I really needed a refresher/beginner tutorial on Excel for a new job and this one was super great for that. I've watched other tutorials that are not nearly as good. Sean's voice sounds nice instead of sharp or fuzzy and he wasn't boring either. The tutorial is for Excel 2016 but I watched while working on my Excel 2010 and it still worked great. I learned a lot. Only a few differences between the 2010 and 2016 versions. The 2016 version sounds amazing though and I want to change over. haha. THANKS!!!
Thank you Sean, a very informative video and straightforward. I know have a better understanding. Nice one
Excellent tutorial. Clear, articulate voice. Used as a refresher and picked up quite a few new tips. Thank you very much. Look forward to more videos.
thank you for all your help. i really like how you break it all down
You are an amazing instructor! Thank you for this video :)
Great teaching video. This is my first attempt at using Excel. The video covers the basics in easy to understand format. I needed to view it over several sessions and the video restarted where I left off. I had to repeat parts several times and the time scale worked well to slide back where I needed. The only negative was that when navigating backwards, the slides where blurred making it difficult to know exactly where I was. I recommend taking notes of the timeline and subject when new sections are started, then going back to review is much easier.
You are the best instructor I 've ever seen. Your method is extraordinary. Merci beaucoup !
Thank You Sean. This was an excellent tutorial to a first time Excel user and you are a great teacher. Please keep up the good work. Chris raman Australia.
@rahulfrancis673
7 жыл бұрын
Learn how to become a writer
@samsejkk
6 жыл бұрын
Chris Raman lwlwwlwlwlslsllewlwp
@duncanonguta4227
6 жыл бұрын
He is an excellent teacher you have covered so many areas in excel good job Sean
@shaikhmohammad692
6 жыл бұрын
Amanda Claus Thank you so much From Dubai
This is a another great beginners tutorial as I've seen. Thanks a lot.
@LearnitTraining
2 жыл бұрын
Glad it was helpful!
You are indeed a very good teacher... Thank you for what you do!
Thank you so much ❤I had no idea what excel is but with this, I have concept about "excel" once again thank you so much 😍best teacher always!
Bonjour Sean, your tutorial is one of the best. I really enjoyed it. Thank you for all the great tips and exercises. Have a great day.
great Teaching Many thanks !
Thank you very much Mr. Sean Bugler for dedicating time to help a lot people. Blessings from El Salvador in Central America.
Thank you Sean!!!! Excellent Tutorial!!
Thank you so much for posting these videos! Massive Blessings
Just what I was looking for. Thanks.
What an excellent tutorial, demystifying the unfamous Excel. Much appreciated. Which one would be the next to watch ?
You are a true Teacher. Thank you for using your talent.
Thank you so much! Excellent tutorial and easy to understand!
I recommend you to play this video at 1.5x speed. Really saves time :)
Hi Sean this was a great tutorial I learned a lot my first time really working on hands with excel. Keep up the great work!
@ganesh5041
4 жыл бұрын
hey is this full course, after learn from this playlist can i get job in mis department
@RamSingh-ol5xz
3 жыл бұрын
Hi sir can help me
@kimberlychavis3379
3 жыл бұрын
Addresses Good Tutorial
Fantastic tutorial.
Sean thank you for making it interesting to watch and learn. It boost my confidence after and I feel I can do the job now with the fresh knowledge in microsoft exceI I gain in your channel.I learn already a lot with this beginners tutorial video. Keep up the good job. This is a good refresher. I like and subscribe.
@LearnitTraining
3 жыл бұрын
Thank you for your support Lerma!
Hi Sean thank you so much for this great tutorial and l am looking for the second one
Great tutorial, I have to trace this video after watching it from a colleague just to come and say "Thanks" for this amazing video.
@LearnitTraining
3 жыл бұрын
Thank you for watching Mohamed!
@mohamedkamara2152
3 жыл бұрын
@@LearnitTraining Thank you too for your great and educating contents.
Very informative and useful video! I strongly recommend this video among all of excel tutorials.
So far so good. Thank you so much for the help.
So helpful thank you Sean!!!
Thank you Sean! I simply learn by following you. You are the best tutor on the internet.
Thank you! Excellent tutorial.
You have a new faithful subscriber here. You are such a great teacher.
Really well done! Thanks!
thank you this has helped alot!!!!
So far so good ! Clear voice.
This got me a upgraded job at work thank you.
THANKS FOR TAKING THE TIME TO PUT THIS TUTORIAL. MUCH EASIER TO FOLLOW THAN THE BOOK
Excellent!! You made excel easy for me
Thanks for the great vid. Wish there was a part 2
Excellent very organized work with very clear English. Hope to see one from you on Power Point. Thanks for the tremendous effort
Thank you! and i am type of person who need those pause!
Excellent!!.. Thank you so much for this video. I learnt a lot of things which I was unaware of! I have subscribed too :)
Hats off to you! What a valuable video indeed. I have learnt a lot from your tutorial. Thank you.
You teach us very efficiently! Thanks for your hard on us, sir.
The best training video I have seen. Thank You
Sean, thank you for this tutorial. Your teaching skills Rock...I just installed the MS-Office 365 and decided to tackle the new Excel features. You are making it a breeze. I million thanks to you sir.
This is a wonderful tutorial. I loved the clarity and the friendly tone. You explained things really well. Thank you for helping those of us out there that needed this. Keep up the good work.
Thank you Sean for the great tutorial, it is very clear and easy to follow I've learned a lot.
1:03:27 the sense of humour though 😂😂😂😂dancing ants around it lol
Thanks A lot... Learns......more
Hey Sean, Thanks so much very informative video presentation easy to follow looking forward to finishing watching tomorrow and looking forward to learning other office software. Hopefully will enable me to re-enter workforce. Thanks again.
you are an outstanding teacher. Thank you
Well explained. Thank you.
I just loved it.this is the best video for beginners.all the beginners must start with this amazing tutorial .Thank You.
Many Thanks Sean this video was very helpful.
Great Tutorial. big tip for people is stick with tutorial, DO NOT skip parts as he goes over things. You will pick up the basics very quickly
GREAT COURSE ! THANK U
Great Teaching.......Nice Tricks
Really amazing.Thank you
thank you so much such a wonderful presentation very helpful
Thankyou so much a very neat explaination.
God bless you for all your help… Your reward can’t stand both earth and sky. Thank you
@LearnitTraining
Жыл бұрын
You are very welcome!
very great job . exelent teacher.
Thanks alot
thank you, I did all the examples did very well thanks for your tuturial sir 👍
Thank You soo much for this Awesome Tutorial I love the way you explain everything your training technique is Fabulous!
Thank you so much for your time and energy. you made me a better person today, god bless you sir.
Thanks for these very detailed videos. Much appreciated. The ending was weird though.
Excellent tutorial video. It brings you through all the basic stuff of Excel by building a workbook. You will not fall asleep or get bored. It keeps you looking at the screen and taking notes until its end. Well done! Tomorrow I am going to watch the Intermediate video.
@LearnitTraining
3 жыл бұрын
Glad you enjoyed it!
You are simply the best so far I found on youtube. Keep up the good work!
@LearnitTraining
3 жыл бұрын
Thanks, will do!
Great tutorials. Although I used excel for 10 years but just re-fresh with this tutorial some of the basics. Good stuff.
@LearnitTraining
2 жыл бұрын
Thank you for watching BestCPA2014! There is always something new to learn with Excel!
Your tutorial is great. It does not teach objectively like most of the tutorials. It takes me into a journey and i learn the stuff effortlessly. Thanks a ton! Btw do you have any sequel to this Tutorial? Would be great......
I really enjoyed your tutorial, Keep it up.
You are an Awesome Teacher!
@LearnitTraining
3 жыл бұрын
Thank you! 😃
Thank you so much for great job. It was very useful.
awesome teaching may GOD bless you bro.
what a tutorial!!! superb....great work done by u
Thanks for starting from scratch. God bless you
@LearnitTraining
2 жыл бұрын
You are very welcome!
Great tutorial, Thanks, Sean. Nick . Los Angeles