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
Acquiring Excel 2016 and Information on Installation and Upgrade
Complete and Continue
Lesson Content Locked
Your session expired. Please sign in again to continue.
Login