o
Introduction & File Management Basics
o Introducing Excel 2016
o Introducing the Backstage View
o Customizing the Interface
o Managing Excel Files
Working with Data
o Identifying Data Types
o Copying & Moving Data
o Finding & Replacing Data
o Formatting Numbers
o Formatting Text
o Formatting Cells
o Copying & Clearing Formats
o Sorting & Filtering Data Lists
o Excel & Database Programs
Working with Functions
o Functions Overview
o Relative & Absolute References
o 3-D References
o Statistical Functions
o Logical Functions
o Text Functions
Visualizing Data
o Creating Excel Tables
o Formatting Excel Tables
o Editing Excel Tables
o Calculating Values in Excel Tables
o Creating Charts
o Formatting Chart Elements
o Customizing Chart Elements
o Creating Sparklines
o Customizing Sparklines
Managing Worksheets
o Navigating Worksheets
o Changing the Worksheet View
o Customizing the Workspace
o Linking Data to Different Worksheets
o Inserting Hyperlinks
o Freezing Panes
o Splitting Windows
o Arranging & Hiding Windows
Printing
o Preparing Worksheets for Printing
o Previewing & Printing Data
