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 ( to browse other Microsoft Courses, Project Management, and IT Training courses.
Nguồn: bgtnation.net
Xem thêm bài viết khác: https://bgtnation.net/cong-nghe/
Xem thêm Bài Viết:
- ĐÁNH GIÁ: ASUS PROART Z490 CREATOR 10G
- Truyền đạt kinh nghiệm cách xác định đầu dây motor 3 pha siêu đơn giản
- Giải quyết vấn đề mật khẩu tài khoản trong Windows 8 và 8.1
- Khóa học Excel: Hàm IF, Sao chép Công thức
- Tư Vấn Mic Thu Âm Cho Người Mới Bắt Đầu – Mua Micro nào là hợp lí – LH 0372472870 Truyền Hữu
thank you sooooooooooo much amazing video
Excellent Explanation. Please explain how the border Red line comes when you select a cell or a range of cells.
I really enjoyed your tutorial, Keep it up.
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.
Thanks for a new great knowledge
Thanks for a new great knowledge
Thanks for a new great knowledge
wow really really Amazing explanation! thank you thank you…………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………..
Hey Shawn THANKS I have done it
It's VERY Helpful THANK you so much
Now I am moving forward to intermediate
😇😇😇🤗
Microsoft Excel is just a basic software application that is used in PC and we often have to use it… but many of the people don't know the deatiled features of this great app… i have read some reviews and features in https://torrent-mac.com/microsoft-excel-for-mac-free-download/ and now here i am …..
Any reason why my custom view is not active pls ? After using the freeze panes, my custom views was inactive . Pls help !
Please sir provide exercise file
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.
Please add link of day 1 workbook
Excellent !!!
Birch & Doughters, LOL. Nice, you've appeased the overlords…for now.
But on a serious note, great course, thank you.
Nice information…
I don't have a tell me bar! help!
thanks!
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
SZAR
ALL CLEAR VERY WELL EXPLAINED BUT I WOULD LIKE TO KNOW FROM WHERE AND HOW YOU ARE USING THE ARROW TO EXPLAIN THE THINGS.
more that great
You r such an angel bro….
Thank you so much….. U deserve to be paid for such a great work….