Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Microsoft Excel 2016 for Beginners: Learn the Essentials
Introduction
Acquiring Excel 2016 and Information on Installation and Upgrade (12:02)
Exercise Files (2:29)
StreamSkill.com Excel 2016 Beginner Course Exercise Files
StreamSkill.com Excel 2016 Beginner Course Demo Files
What's New
New and Improved Features in Excel 2016 (2:55)
Using Touch
Overview of Principles of Using Touchscreen (5:36)
Getting Started
Creating and Saving a Workbook (15:16)
Opening a Workbook (10:13)
Using Help
Online Help and Contextual Help (6:27)
Excel Options
Personalizing your use of Excel (10:50)
The Ribbon and Toolbars
Basics of using the Ribbon (14:58)
Quick Access Toolbar (5:47)
Tell Me Feature (6:51)
Mini Toolbars and Contextual Menus (3:48)
Status Bar (5:04)
Entering and Editing Data
Basics of Entering and Editing Data in a Workbook (13:31)
Exercise 01 (1:51)
Formatting Dates (12:38)
Formatting Numbers (13:50)
Exercise 02 (1:43)
Backup and Recovery
AutoSave, Recover Unsaved Workbook, and Create a Backup Copy (7:37)
Fill and Series
Working with Fill and Series (9:11)
Flash Fill (4:06)
Viewing and Printing
Workbook Views, Zoom, and Freeze (8:43)
Printing (14:32)
Exercise 03 (2:56)
Cut, Copy, and Paste
Methods of Cutting, Copying, and Pasting (13:34)
Formatting a Worksheet
Delete and Clear (13:47)
Insert, Hide, Column Width and Row Height, and Merge (12:48)
Alignment (12:07)
Themes and Styles (11:21)
Exercise 04 (1:44)
Formulas and Functions
Basics of Fomulas and Functions (11:17)
Complex Examples of Formulas (13:38)
Exercise 05 (3:26)
Managing Worksheets
Rename, Insert, Move, and Reference a Worksheet (8:42)
Working with Multiple Workbooks
Working with Multiple Workbooks (15:50)
Saving Workbooks
Saving in Different File Types (13:01)
Proofing
The Spell Checker (13:13)
Inserting Comments
Inserting Comments (4:56)
Exercise 06 (3:02)
Basic Functions in Excel
The VLOOKUP Function (14:09)
Text Functions (8:19)
Date and Time Functions (6:49)
Logical Functions (15:53)
Graphs and Charts
Creating Graphs and Charts (12:12)
Customizing a Cluster Column Chart (15:44)
Customizing a Pie Chart (13:38)
New Chart Types in Excel 2016 (2:02)
Exercise 7 (2:29)
Sorting and Filtering Data
Managing Data by Sorting (9:41)
Managing Date by Filtering (12:01)
Customizing Tables (13:25)
Shapes and Pictures
Inserting Shapes and Pictures (15:02)
Exercise 08 (0:47)
Formatting Cells Based on Content
Conditional Formatting (15:34)
Protection and Security
Protecting Worksheets (9:38)
Protecting Workbooks (10:23)
Naming Items
Giving Items Names (6:33)
Exercise 09 (0:47)
Finding and Replacing Words
Find and Replace (7:12)
Borders
Adding Borders (10:46)
Workbook Inspection
Inspecting a Workbook (6:10)
Privacy Options
Trust Center Privacy Options (5:48)
Sharing Options
Sharing a Workbook (8:32)
Conclusion
Course Conclusion and Closing (0:57)
Course Quiz and Certificate of Completion
Exercise Files
Download
Complete and Continue