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:28)
Course exercise files
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:56)
Quick Access Toolbar (5:45)
Tell Me Feature (6:49)
Mini Toolbars and Contextual Menus (3:47)
Status Bar (5:02)
Entering and Editing Data
Basics of Entering and Editing Data in a Workbook (13:29)
Exercise 01 (1:50)
Formatting Dates (12:36)
Formatting Numbers (13:48)
Exercise 02 (1:43)
Backup and Recovery
AutoSave, Recover Unsaved Workbook, and Create a Backup Copy (7:35)
Fill and Series
Working with Fill and Series (9:09)
Flash Fill (4:04)
Viewing and Printing
Workbook Views, Zoom, and Freeze (8:41)
Printing (14:30)
Exercise 03 (2:56)
Cut, Copy, and Paste
Methods of Cutting, Copying, and Pasting (13:32)
Formatting a Worksheet
Delete and Clear (13:45)
Insert, Hide, Column Width and Row Height, and Merge (12:46)
Alignment (12:05)
Themes and Styles (11:19)
Exercise 04 (1:44)
Formulas and Functions
Basics of Fomulas and Functions (11:15)
Complex Examples of Formulas (13:36)
Exercise 05 (3:26)
Managing Worksheets
Rename, Insert, Move, and Reference a Worksheet (8:40)
Working with Multiple Workbooks
Working with Multiple Workbooks (15:48)
Saving Workbooks
Saving in Different File Types (12:59)
Proofing
The Spell Checker (13:11)
Inserting Comments
Inserting Comments (4:54)
Exercise 06 (3:02)
Basic Functions in Excel
The VLOOKUP Function (14:07)
Text Functions (8:17)
Date and Time Functions (6:47)
Logical Functions (15:51)
Graphs and Charts
Creating Graphs and Charts (12:10)
Customizing a Cluster Column Chart (15:42)
Customizing a Pie Chart (13:36)
New Chart Types in Excel 2016 (2:01)
Exercise 7 (2:28)
Sorting and Filtering Data
Managing Data by Sorting (9:39)
Managing Date by Filtering (11:59)
Customizing Tables (13:23)
Shapes and Pictures
Inserting Shapes and Pictures (15:00)
Exercise 08 (0:47)
Formatting Cells Based on Content
Conditional Formatting (15:32)
Protection and Security
Protecting Worksheets (9:36)
Protecting Workbooks (10:21)
Naming Items
Giving Items Names (6:31)
Exercise 09 (0:47)
Finding and Replacing Words
Find and Replace (7:10)
Borders
Adding Borders (10:44)
Workbook Inspection
Inspecting a Workbook (6:08)
Privacy Options
Trust Center Privacy Options (5:46)
Sharing Options
Sharing a Workbook (8:30)
Conclusion
Course Conclusion and Closing (0:56)
Course Quiz
Microsoft Excel 2016 Quiz
Exercise 02
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock