Chat with us, powered by LiveChat

Average Improvement Results

Assess Learn Verify Improvement
Excel 2019 Training

Excel 2019 Basic

50%
96%
46%

Excel Fundamentals demo

54%
97%
42%
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

55%
98%
43%
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

53%
99%
45%
Formula Basics
AutoFill
Sums and Averages
MIN and MAX
COUNT

Basic Formatting lock Subscribe to unlock

48%
98%
50%
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

45%
98%
52%
Images
Shapes
Hyperlinks
Object Properties and Alt Text

Manage Worksheets lock Subscribe to unlock

41%
99%
57%
View Worksheets
Multiple Windows
Move and Copy Worksheets
Insert, Rename, and Delete Worksheets
Freeze Rows and Columns
Hide Worksheets and Gridlines
Excel 2019 Training

Excel 2019 Intermediate

41%
98%
57%

Charts lock Subscribe to unlock

33%
98%
65%
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

57%
99%
42%
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

37%
99%
62%
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

35%
99%
63%
Quick Analysis
Outline and Subtotal
Data Validation
Flash Fill
Import and Export Data

Tables lock Subscribe to unlock

53%
99%
45%
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%
60%
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

43%
99%
56%

Cell Comments

Share Workbooks

Co-author Workbooks

Version History

Protect a Worksheet

Protect Workbook Structure

Password Protection
Excel 2019 Training

Excel 2019 Advanced

44%
99%
54%

PivotTables lock Subscribe to unlock

57%
99%
42%
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

44%
99%
54%
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

34%
99%
65%

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

50%
99%
48%

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

31%
99%
68%
Goal Seek

Scenario Manager

Consolidate Data

Macros lock Subscribe to unlock

38%
100%
61%

Enable Macros

Create Macros
Modify Macros

Copy Macros

Trusted by Over 3,000 Organizations

client-image

We love the 12-15 minute learning modules. They allow our learners to begin using the newly acquired skills right away.

client-image

My students LOVE the courses I made with CustomGuide! I am immensely pleased with the product and have saved really hundreds of hours of design time. I’m learning so much myself in putting this all together that I’m much more productive.

client-image

The toughest part [in training] is creating the material, which CustomGuide has done for us. Employees have found the courses easy to follow and, most importantly, they were able to use what they learned immediately.

  • customer-logo
  • customer-logo
  • customer-logo
  • customer-logo
  • customer-logo
  • customer-logo
  • customer-logo
  • customer-logo