Chat with us, powered by LiveChat

Microsoft Excel Training

Learn by doing, not watching, with interactive Excel simulations.

freetrial

Proven Learning Method

  • Measure existing skills with simulation-based assessments.
  • Improve skills gaps with bite-sized interactive tutorials.
  • Verify learning with post assessments.
  • Endorse skills with certificates.

Excel Training Features

  • Interactive-training Interactive; learn by doing, instead of passively watching long, boring videos.
  • Customizable-content Customizable, select only the skills you want and the learning method you need.
  • Scorm-compatible SCORM-compliant; and will work great in your LMS.

Courses are available for multiple versions: Office 365, Excel 2019, Excel 2016, Excel 2016 for Mac, and Excel 2013; Spanish editions also available.

Average Improvement Results

Collapse All Assess Learn Verify Improvement
Excel Training

Excel Basic Training

49%
98%
48%

Excel Fundamentals demo

54%
99%
45%

Understand the Excel Screen

Click to try Not Started Not Started Not Started

Create Workbooks

Not Started Not Started Not Started

Navigate Worksheets

Not Started Not Started Not Started

Open Workbooks

Not Started Not Started Not Started

Save Workbooks

Not Started Not Started Not Started

AutoRecover

Not Started Not Started Not Started

The Quick Access Toolbar

Not Started Not Started Not Started

Print

Not Started Not Started Not Started

Help

Not Started Not Started Not Started

Close and Exit

Not Started Not Started Not Started

Edit a Workbook lock Subscribe to unlock

54%
99%
45%

Select Cells and Ranges

Edit Cell Data

Cut, Copy, and Paste

Undo, Redo, Repeat

More Pasting Options

Insert and Move Cells

Delete Cells

Check Spelling

Find and Replace Text

Hide Columns and Rows

Document Properties

Basic Formulas lock Subscribe to unlock

52%
99%
46%

Formula Basics

AutoFill

Sums and Averages

MIN and MAX

COUNT

Basic Formatting lock Subscribe to unlock

47%
99%
52%

Format Text

Align and Merge Cells

Format Numbers and Dates

Borders and Background Colors

Copy Formatting

Row Heights and Column Widths

Insert Objects lock Subscribe to unlock

43%
98%
54%

Images

Shapes

Hyperlinks

Object Properties and Alt Text

Manage Worksheets lock Subscribe to unlock

37%
99%
62%

View Worksheets

Multiple Windows

Move and Copy Worksheets

Insert, Rename, and Delete Worksheets

Freeze Rows and Columns

Hide Worksheets and Gridlines

Excel Training

Excel Intermediate Training

38%
97%
58%

Charts lock Subscribe to unlock

30%
96%
66%

Create Charts

Move and Resize

Chart Types

Layout and Style

Titles and Legends

Gridlines, Labels, and Data Tables

Chart Elements

Modify Chart Data

Filter Charts

Trendlines

Dual-Axis Charts

Chart Templates

Sparklines

Print and Distribute lock Subscribe to unlock

53%
98%
45%

Page Size and Scale

Print Area and Page Breaks

Print Titles, Gridlines, and Headings

Headers and Footers

Margins and Orientation

Inspect for Issues

Intermediate Formulas lock Subscribe to unlock

34%
100%
66%

Reference External Worksheets

Absolute and Relative References

Order of Operations

Cell and Range Names

Insert Functions

CONCAT Function

PMT Function

Display Formulas

Date Formulas

Manage Data lock Subscribe to unlock

34%
99%
65%

Quick Analysis

Outline and Subtotal

Data Validation

Flash Fill

Import and Export Data

Tables lock Subscribe to unlock

52%
100%
48%

Insert a Table

Sort Data

Filter Data

Add Rows and Columns

Table Styles

Remove Duplicates

Slicers

Structured References

Intermediate Formatting lock Subscribe to unlock

39%
100%
61%

Apply Conditional Formatting

Apply and Remove Cell Styles

Create and Modify Cell Styles

Find and Replace Formatting

Apply a Theme

Collaboration lock Subscribe to unlock

42%
100%
58%

Cell Comments

Share Workbooks

Co-author Workbooks

Version History

Protect a Worksheet

Protect Workbook Structure

Password Protection

Excel Training

Excel Advanced Training

45%
99%
54%

PivotTables lock Subscribe to unlock

54%
100%
45%

Create PivotTables

Add Multiple PivotTable Fields

Change a PivotTable's Calculation

Add Calculated Fields

The GETPIVOTDATA Function

Filter PivotTables

Timelines

PivotTable Layout

Group Values

Refresh a PivotTable

Format a PivotTable

PivotCharts lock Subscribe to unlock

48%
98%
50%

Create PivotCharts

PivotChart Options

PivotChart Styles

Drill-Down Data

Troubleshoot Formulas lock Subscribe to unlock

39%
99%
60%

Formula Errors

The Watch Window

Evaluate Formulas

Advanced Formatting lock Subscribe to unlock

36%
99%
63%

Customize Conditional Formatting

Conditional Formatting with Formulas

Manage Conditional Formatting

International Currency and Formats

Body and Heading Options

Color Formats

Custom Themes

Form Controls

Save Form Templates

Advanced Formulas lock Subscribe to unlock

49%
100%
50%

IF Function

Nested Functions

AND, OR, and NOT Functions

SUMIF, AVERAGEIF, and COUNTIF Functions

VLOOKUP

HLOOKUP

INDEX and MATCH

UPPER, LOWER, and PROPER

RIGHT, LEFT, and MID

Formula Calculation Options

Analyze Data lock Subscribe to unlock

27%
99%
72%

Goal Seek

Scenario Manager

Consolidate Data

Macros lock Subscribe to unlock

35%
99%
63%

Enable Macros

Create Macros

Modify Macros

Copy Macros