Basic

Lesson 1: The Basics

  • Topic A: Getting Started
  • Topic B: Signing In
  • Topic C: Creating a New Workbook
  • Topic D: Parts of a Workbook
  • Topic E: Saving a Workbook
  • Topic F: Opening a Workbook

Lesson 2: Your First Workbook

  • Topic A: Selecting Data
  • Topic B: Entering and Deleting Data
  • Topic C: Using Undo and Redo
  • Topic D: Using Cut, Copy, and Paste

Lesson 3: Working with Data

  • Topic A: Inserting Rows and Columns
  • Topic B: Merging and Splitting Cells
  • Topic C: Moving Cells
  • Topic D: Using Paste Special
  • Topic E: Using Find and Replace
  • Topic F: Hiding and Unhiding Cells

Lesson 4: Using Basic Excel Tools

  • Topic A: Understanding Cell References and Formulas
  • Topic B: Using Basic Formulas
  • Topic C: Using Basic Functions
  • Topic D: Using Advanced Functions
  • Topic E: Using Spell Check
  • Topic F: Using Sort and Filter

Lesson 5: Using Timesaving Tools

  • Topic A: Using AutoFill
  • Topic B: Using Flash Fill
  • Topic C: Using AutoSum
  • Topic D: Using AutoComplete
  • Topic E: Using AutoCalculate

Lesson 6: Formatting Text

  • Topic A: Changing the Font Face, Size, and Color
  • Topic B: Applying Text Effects
  • Topic C: Applying Borders and Fill
  • Topic D: Using the Font Tab of the Format Cells Dialog
  • Topic E: Clearing Formatting

Lesson 7: Formatting Data

  • Topic A: Wrapping Text
  • Topic B: Changing the Size of Rows and Columns
  • Topic C: Adjusting Cell Alignment
  • Topic D: Changing Text Direction
  • Topic E: Changing Number Format

Lesson 8: Formatting the Workbook

  • Topic A: Using Cell Styles
  • Topic B: Formatting Data as a Table
  • Topic C: Changing the Theme
  • Topic D: Inserting Page Breaks
  • Topic E: Adding a Background

Lesson 9: Inserting Art and Objects

  • Topic A: Inserting SmartArt
  • Topic B: Inserting Text Boxes
  • Topic C: Inserting Pictures
  • Topic D: Inserting Equations
  • Topic E: Drawing Shapes

Lesson 10: Charting Data

  • Topic A: Creating Sparklines
  • Topic B: Inserting Charts
  • Topic C: Inserting PivotTables
  • Topic D: Inserting PivotCharts
  • Topic E: Using Slicers
  • Topic F: Creating Timelines

Lesson 11: Viewing, Printing, and Sharing Your Workbook

  • Topic A: Using Views
  • Topic B: Saving a Workbook as PDF or XPS
  • Topic C: Printing a Workbook
  • Topic D: E-Mailing a Workbook
  • Topic E: Sharing Your Workbook on OneDrive

Lesson 12: Customizing the Interface

  • Topic A: Changing Ribbon Display Options
  • Topic B: Customizing the Quick Access Toolbar
  • Topic C: Hiding and Showing Ribbon Tabs
  • Topic D: Creating Custom Ribbon Tabs
  • Topic E: Resetting Interface Changes

Intermediate

Lesson 1: Advanced Formula Tasks

  • Topic A: Understanding Relative and Absolute Cell References
  • Topic B: Using Multiple Cell References
  • Topic C: Using 3D References
  • Topic D: Using Array Formulas

Lesson 2: Working with Named Ranges

  • Topic A: Understanding Named Ranges
  • Topic B: Defining Named Ranges
  • Topic C: Editing Named Ranges
  • Topic D: Deleting Named Ranges
  • Topic E: Using Named Ranges in Formulas

Lesson 3: Using Advanced Functions

  • Topic A: Using the PMT Function
  • Topic B: Using the FV Function
  • Topic C: Using VLOOKUP and HLOOKUP Functions
  • Topic D: Using IF, AND, OR Functions

Lesson 4: Resolving Formula Errors

  • Topic A: Tracing Formula Precedents and Dependents
  • Topic B: Showing Formulas
  • Topic C: Evaluating Formulas
  • Topic D: Setting Error Checking Options
  • Topic E: Using Error Option Buttons
  • Topic F: Running an Error Check

Lesson 5: Managing Data

  • Topic A: Consolidating Information
  • Topic B: Removing Duplicates
  • Topic C: Configuring Data Validation
  • Topic D: Transposing Data
  • Topic E: Converting Text to Columns

Lesson 6: Outlining and Grouping Data

  • Topic A: Outlining Data
  • Topic B: Showing and Hiding Outline Details
  • Topic C: Grouping Data
  • Topic D: Creating Subtotals
  • Topic E: Removing Outlining and Grouping

Lesson 7: Working with Scenarios

  • Topic A: Creating Scenarios
  • Topic B: Loading Scenarios
  • Topic C: Merging Scenarios
  • Topic D: Editing Scenarios
  • Topic E: Creating a Scenario Summary Report
  • Topic F: Deleting Scenarios

Lesson 8: Using Solver

  • Topic A: Setting up the Worksheet
  • Topic B: Running Solver
  • Topic C: Generating Reports and Scenarios with Solver
  • Topic D: Modifying Constraints
  • Topic E: Setting Solver Options

Lesson 9: Analyzing Data

  • Topic A: Enabling the Analysis ToolPak
  • Topic B: Using Data Analysis Tools
  • Topic C: Using Goal Seek
  • Topic D: Using Data Tables

Lesson 10: Advanced PivotTable Features

  • Topic A: Creating a Basic PivotTable
  • Topic B: Creating a Basic PivotChart
  • Topic C: Using the PivotTable Fields Pane
  • Topic D: Adding Calculated Fields
  • Topic E: Sorting Pivoted Data
  • Topic F: Filtering Pivoted Data

Lesson 11: Using Macros

  • Topic A: Recording a Macro
  • Topic B: Writing a Macro using the Visual Basic Editor
  • Topic C: Editing a Macro
  • Topic D: Running a Macro

Advanced

Lesson 1: Using Conditional Formatting

  • Topic A: Applying Conditional Formatting
  • Topic B: Applying Multiple Rule Sets
  • Topic C: Creating Custom Rule Sets
  • Topic D: Viewing and Managing Rules
  • Topic E: Clearing Custom Rules

Lesson 2: Working with Slicers

  • Topic A: Inserting and Using a Slicer
  • Topic B: Renaming the Slicer
  • Topic C: Changing Slicer Settings
  • Topic D: Formatting a Slicer
  • Topic E: Clearing the Slicer

Lesson 3: Using the Inquire Add-In

  • Topic A: Installing Inquire
  • Topic B: Generating a Workbook Analysis Report
  • Topic C: Viewing Workbook and Worksheet Relationships
  • Topic D: Viewing Cell Relationships
  • Topic E: Comparing Two Workbooks

Lesson 4: Working with Tables

  • Topic A: What is a Table?
  • Topic B: Creating Tables
  • Topic C: Resizing the Table
  • Topic D: Choosing a Table Style
  • Topic E: Clearing the Table

Lesson 5: Working with Records and Fields

  • Topic A: What are Records and Fields?
  • Topic B: Adding Fields by Inserting Columns
  • Topic C: Adding Records by Inserting Rows
  • Topic D: Deleting Records or Fields

Lesson 6: Using Excel as a Database

  • Topic A: Filtering with Wildcard Characters
  • Topic B: Validating Your Data
  • Topic C: Data Validation Using Lists
  • Topic D: Data Validation Using Formulas
  • Topic E: Using Database Functions

Lesson 7: Using Custom AutoFill Lists

  • Topic A: Creating a Custom AutoFill List
  • Topic B: Using a Custom AutoFill List
  • Topic C: Modifying a Custom AutoFill List
  • Topic D: Deleting a Custom AutoFill List

Lesson 8: Using Comments

  • Topic A: Inserting Comments
  • Topic B: Editing Comments
  • Topic C: Navigating Through Comments
  • Topic D: Deleting Comments

Lesson 9: Tracking Changes

  • Topic A: Tracking Changes
  • Topic B: Reviewing Changes
  • Topic C: Setting Options for Tracking Changes
  • Topic D: Stopping Tracking Changes

Lesson 10: Linking, Consolidating, and Combining Data

  • Topic A: Linking Workbooks
  • Topic B: Consolidating Workbooks
  • Topic C: Consolidating Worksheets
  • Topic D: Pivoting Consolidated Data