Course curriculum

  • 1

    Module One: Getting Started

    • Course Objectives

  • 2

    Module Two: Create and Manage Worksheets and Workbooks

    • Create and Manage Worksheets and Workbooks

    • Create a Workbook

    • Add a Worksheet to An Existing Workbook

    • Search for Data

    • Navigate to a Named Cell

    • Insert and Remove Hyperlinks

    • Hide or Unhide Columns and Rows

    • Hide or Unhide Sheets

    • Modify Worksheets

    • Adjust Row Height and Column Width

    • Insert Headers and Footers

    • Change Worksheet Tab Color

    • Rename Worksheet

    • Copy and Move Worksheets

    • Modify Page Setup

    • Change Workbook Themes

    • Add a Tool to the Quick Access Toolbar

    • Zoom

    • Change Workbook Views

    • Change Window Views

    • Modify Document Properties

    • Show or Hide Formulas

    • Printing

    • Set a Print Area

    • Save in Another File Format

    • Repeat Columns or Rows Across Multiple Pages

    • Inspect a Workbook for Hidden Properties and Personal Information

    • Inspect a Workbook for Accessibility Issues

    • Inspect a Workbook for Compatibility Issues

    • Module Two: Review Questions

  • 3

    Module Three: Manage Data Cells and Ranges

    • Manage Data Cells and Ranges

    • Replace Data

    • Cut, Copy and Paste Data

    • Paste Data Using Paste Options

    • Fill Cells using Autofill

    • Insert and Delete Cells

    • Merge Cells

    • Align and Indent Cell Contents

    • Wrap Text Within Cells

    • Apply Number Formats

    • Apply Cell Styles

    • Apply Cell Formats

    • Apply Conditional Formatting

    • Format Cells using the Format Painter

    • Insert Sparklines

    • Grouping Data

    • Adding Subtotals

    • Outline Data

    • Viewing Grouped and Outlined Data

    • Module Three: Review Questions

  • 4

    Module Four: Create Tables

    • Create Tables

    • Create an Excel Table from a Cell Range

    • Add or Remove Table Rows and Columns

    • Convert a Table to a Cell Range

    • Apply Styles to Tables

    • Configure Table Style Options

    • Insert Total Rows

    • Filter Records

    • Clear Filters

    • Use a Number Filter or Text Filter

    • Change Sort Order

    • Sort Data by Multiple Columns

    • Remove Duplicate Records

    • Module Four: Review Questions

  • 5

    Module Five: Perform Operations with Formulas and Functions

    • Formulas and Functions

    • Understand Math Basics of Excel

    • Build a Formula

    • Edit a Formula

    • Copy a Formula

    • Understand Relative vs. Absolute References

    • Understand Formulas vs. Functions

    • Calculate Using Status Bar

    • Perform Basic Functions

    • AutoComplete a Function

    • Create Functions using Formulas Tab

    • Perform the IF Function

    • Perform the SUMIF Function

    • Perform the COUNTIF Function

    • Format Text Using UPPER, LOWER, and PROPER Functions

    • Format Text Using the CONCAT Function

    • Format Text Using LEFT, RIGHT and MID Functions

    • Module Five: Review Questions

  • 6

    Module Six: Use Quick Analysis, Charts and Objects

    • Use Quick Analysis, Charts and Objects

    • Format with Quick Analysis

    • Create Charts with Quick Analysis

    • Calculate Totals with Quick Analysis

    • Use Recommended Charts

    • Create a New Chart

    • Add Additional Data Series

    • Switch Between Rows and Columns in Source Data

    • Resize Charts

    • Add and Modify Chart Elements

    • Apply Chart Styles and Layouts

    • Move Charts to a Chart Sheet

    • Add Data to Chart on a Chart Sheet

    • Insert Shapes

    • Insert Text Boxes

    • Format Shapes and Text Boxes

    • Insert Pictures

    • Add Alternative Text

    • Module Six: Review Questions