Microsoft Excel 2016 - Learn Excel 2016 Beginners Tutorial Video

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

For ad free training and certificates please join Learnit Anytime:

For Private Group Trainings please visit:

#Excel

(C) 2021 Learnit, Inc.
Any illegal reproduction of this content will result in immediate legal action.

[musiklover]

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

[doryolson]

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

[desireejohnson]

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 :)

[datalab]

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.

[simonkozak]

I recommend you to play this video at 1.5x speed. Really saves time :)

[merjones]

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.

[d.m.]

Very clear and detailed tutorial. I'm a slow learner and had no problem understanding everything.

[aishwaryabadhe]

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

[techsavy]

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🙏

[MS-vzep]

This is what i call a real teacher. Many thanks to you for the time and energy.

[mrCetus]

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

[thomasritchie]

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.

[danielvalle]

Thank you very much Mr. Sean Bugler for dedicating time to help a lot people. Blessings from El Salvador in Central America.

[Sportsperformanceanalysis]

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

[mohamedkamara]

Great tutorial, I have to trace this video after watching it from a colleague just to come and say "Thanks" for this amazing video.

[andrewowen]

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

[chrisraman]

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.

[hannieo]

You are a true Teacher. Thank you for using your talent.

[FaysalEasyExcel]

This is a another great beginners tutorial as I've seen. Thanks a lot.

[mkass]

You are indeed a very good teacher... Thank you for what you do!