Chat with us, powered by LiveChat

Excel 2019 Advanced

Learn by doing—not by watching—with interactive simulations.

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 2019 eLearning 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.

Average Improvement Results

Assess Learn Verify Improvement
Excel 2019 Training

Excel 2019 Advanced

43%
98%
55%

PivotTables demo

55%
98%
42%

Create PivotTables

Click to try Not Started Not Started Not Started

Add Multiple PivotTable Fields

Not Started Not Started Not Started

Change a PivotTable's Calculation

Not Started Not Started Not Started

Add Calculated Fields

Not Started Not Started Not Started

The GETPIVOTDATA Function

Not Started Not Started Not Started

Filter PivotTables

Not Started Not Started Not Started

Timelines

Not Started Not Started Not Started

PivotTable Layout

Not Started Not Started Not Started

Group Values

Not Started Not Started Not Started

Refresh a PivotTable

Not Started Not Started Not Started

Format a PivotTable

Not Started Not Started Not Started

PivotCharts lock Subscribe to unlock

46%
98%
52%

Create PivotCharts

PivotChart Options

PivotChart Styles

Drill-Down Data

Troubleshoot Formulas lock Subscribe to unlock

37%
98%
61%

Formula Errors

The Watch Window

Evaluate Formulas

Advanced Formatting lock Subscribe to unlock

34%
97%
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

48%
98%
49%

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

28%
98%
69%

Goal Seek

Scenario Manager

Consolidate Data

Macros lock Subscribe to unlock

36%
98%
62%

Enable Macros

Create Macros

Modify Macros

Copy Macros