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
Exercise Files
Course exercise files
Course demo files
What's New
New and Improved Features in Excel 2016
Using Touch
Overview of Principles of Using Touchscreen
Getting Started
Creating and Saving a Workbook
Opening a Workbook
Using Help
Online Help and Contextual Help
Excel Options
Personalizing your use of Excel
The Ribbon and Toolbars
Basics of using the Ribbon
Quick Access Toolbar
Tell Me Feature
Mini Toolbars and Contextual Menus
Status Bar
Entering and Editing Data
Basics of Entering and Editing Data in a Workbook
Exercise 01
Formatting Dates
Formatting Numbers
Exercise 02
Backup and Recovery
AutoSave, Recover Unsaved Workbook, and Create a Backup Copy
Fill and Series
Working with Fill and Series
Flash Fill
Viewing and Printing
Workbook Views, Zoom, and Freeze
Printing
Exercise 03
Cut, Copy, and Paste
Methods of Cutting, Copying, and Pasting
Formatting a Worksheet
Delete and Clear
Insert, Hide, Column Width and Row Height, and Merge
Alignment
Themes and Styles
Exercise 04
Formulas and Functions
Basics of Fomulas and Functions
Complex Examples of Formulas
Exercise 05
Managing Worksheets
Rename, Insert, Move, and Reference a Worksheet
Working with Multiple Workbooks
Working with Multiple Workbooks
Saving Workbooks
Saving in Different File Types
Proofing
The Spell Checker
Inserting Comments
Inserting Comments
Exercise 06
Basic Functions in Excel
The VLOOKUP Function
Text Functions
Date and Time Functions
Logical Functions
Graphs and Charts
Creating Graphs and Charts
Customizing a Cluster Column Chart
Customizing a Pie Chart
New Chart Types in Excel 2016
Exercise 7
Sorting and Filtering Data
Managing Data by Sorting
Managing Date by Filtering
Customizing Tables
Shapes and Pictures
Inserting Shapes and Pictures
Exercise 08
Formatting Cells Based on Content
Conditional Formatting
Protection and Security
Protecting Worksheets
Protecting Workbooks
Naming Items
Giving Items Names
Exercise 09
Finding and Replacing Words
Find and Replace
Borders
Adding Borders
Workbook Inspection
Inspecting a Workbook
Privacy Options
Trust Center Privacy Options
Sharing Options
Sharing a Workbook
Conclusion
Course Conclusion and Closing
Course Quiz
Microsoft Excel 2016 Quiz
New and Improved Features in Excel 2016
Complete and Continue