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; learn by doing, instead of passively watching long, boring videos. -
Customizable, you can select only the skills you want and the learning method you need. -
SCORM-compliant; will work great in your LMS.
Average Improvement Results |
||||
|---|---|---|---|---|
| Assess | Learn | Verify | Improvement | |
Excel 2019 Basic |
46%
|
|||
Excel Fundamentals
|
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 | |
| 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
|
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
|
44%
|
|||
Formula Basics |
|
|||
AutoFill |
||||
Sums and Averages |
||||
MIN and MAX |
||||
COUNT |
||||
Basic Formatting
|
50%
|
|||
Format Text |
|
|||
Align and Merge Cells |
||||
Format Numbers and Dates |
||||
Borders and Background Colors |
||||
Copy Formatting |
||||
Row Heights and Column Widths |
||||
Insert Objects
|
52%
|
|||
Images |
|
|||
Shapes |
||||
Hyperlinks |
||||
Object Properties and Alt Text |
||||
Manage Worksheets
|
58%
|
|||
View Worksheets |
|
|||
Multiple Windows |
||||
Move and Copy Worksheets |
||||
Insert, Rename, and Delete Worksheets |
||||
Freeze Rows and Columns |
||||
Hide Worksheets and Gridlines |
||||
Excel 2019 Intermediate |
58%
|
|||
Charts
|
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
|
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
|
63%
|
|||
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
|
63%
|
|||
Quick Analysis |
|
|||
Outline and Subtotal |
||||
Data Validation |
||||
Flash Fill |
||||
Import and Export Data |
||||
Tables
|
47%
|
|||
Insert a Table |
|
|||
Sort Data |
||||
Filter Data |
||||
Add Rows and Columns |
||||
Table Styles |
||||
Remove Duplicates |
||||
Slicers |
||||
Structured References |
||||
Intermediate Formatting
|
61%
|
|||
Apply Conditional Formatting |
|
|||
Apply and Remove Cell Styles |
||||
Create and Modify Cell Styles |
||||
Find and Replace Formatting |
||||
Apply a Theme |
||||
Collaboration
|
57%
|
|||
Cell Comments |
|
|||
Share Workbooks |
||||
Co-author Workbooks |
||||
Version History |
||||
Protect a Worksheet |
||||
Protect Workbook Structure |
||||
Password Protection |
||||
