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