Excel 2016

Basic

Lesson 1: Getting Started with Microsoft Excel 2016

Topic A: Identify the Elements of the Excel Interface

Topic B: Create a Basic Worksheet

Topic C: Use the Help System

Lesson 2: Performing Calculations

Topic A: Create Formulas in a Worksheet

Topic B: Insert Functions in a Worksheet

Topic C: Reuse Formulas

Lesson 3: Modifying a Worksheet

Topic A: Manipulate Data

Topic B: Insert, Manipulate, and Delete Cells, Columns, and Rows

Topic C: Search For and Replace Data

Topic D: Spell Check a Worksheet

Lesson 4: Formatting a Worksheet

Topic A: Modify Fonts

Topic B: Add Borders and Colors to Cells

Topic C: Apply Number Formats

Topic D: Align Cell Contents

Topic E: Apply Cell Styles

Lesson 5: Printing Workbook Contents

Topic A: Define the Basic Page Layout for a Workbook

Topic B: Refine the Page Layout and Apply Print Options

Lesson 6: Managing Large Workbooks

Topic A: Format Worksheet Tabs

Topic B: Manage Worksheets

Topic C: Manage the View of Worksheets and Workbooks

Lesson 7: Customizing the Excel Environment

Topic A: Customize General and Language Options

Topic B: Customize Formula Options

Topic C: Customize Proofing and Save Options

Topic D: Customize the Ribbon and Quick Access Toolbar

Topic E: Customize the Functionality of Excel by Enabling Add-Ins

Topic F: Customize Advanced and Trust Center Options

Intermediate

Lesson 1: Creating Advanced Formulas

Topic A: Apply Range Names

Topic B: Use Specialized Functions

Lesson 2: Analyzing Data with Logical and Lookup Functions

Topic A: Use Text Functions

Topic B: Use Logical Functions

Topic C: Use Lookup Functions

Topic D: Use Date Functions

Topic E: Use Financial Functions

Lesson 3: Organizing Worksheet Data with Tables

Topic A: Create and Modify Tables

Topic B: Sort and Filter Data

Topic C: Use Subtotal and Database Functions to Calculate Data

Lesson 4: Visualizing Data with Charts

Topic A: Create Charts

Topic B: Modify and Format Charts

Topic C: Create a Trendline

Topic D: Create Advanced Charts

Lesson 5: Analyzing Data with PivotTables, Slicers, and PivotCharts

Topic A: Create a PivotTable

Topic B: Filter Data by Using Slicers

Topic C: Analyze Data with PivotCharts

Lesson 6: Inserting Graphics

Topic A: Insert and Modify Graphic Objects

Topic B: Layer and Group Graphic Objects

Topic C: Incorporate SmartArt

Lesson 7: Enhancing Workbooks

Topic A: Customize Workbooks

Topic B: Manage Themes

Topic C: Create and Use Templates

Topic D: Protect Files

Topic E: Preparing a Workbook for Multiple Audiences

Advanced

Lesson 1: Automating Worksheet Functionality

Topic A: Update Workbook Properties

Topic B: Create and Edit a Macro

Topic C: Apply Conditional Formatting

Topic D: Add Data Validation Criteria

Lesson 2: Auditing Worksheets

Topic A: Trace Cells

Topic B: Troubleshoot Invalid Data and Formula Errors

Topic C: Watch and Evaluate Formulas

Topic D: Create a Data List Outline

Lesson 3: Analyzing and Presenting Data

Topic A: Create Sparklines

Topic B: Create Scenarios

Topic C: Perform a What-If Analysis

Topic D: Perform a Statistical Analysis with the Analysis ToolPak

Topic E: Create Interactive Data with Power View

Lesson 4: Working with Multiple Workbooks

Topic A: Consolidate Data

Topic B: Link Cells in Different Workbooks

Topic C: Merge Workbooks

Lesson 5: Exporting Excel Data

Topic A: Export Excel Data

Topic B: Import a Delimited Text File

Topic C: Integrate Excel Data with the Web

Topic D: Create a Web Query

Lesson 6: Importing and Exporting XML Data

Topic A: Import and Export XML Data