Excel 2013 Advanced
Learn by doing—not by watching—with interactive simulations.
Sign up & start learningProven 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 2013 eLearning Features
-
Interactive; learn by doing, instead of passively watching long, boring videos. -
Customizable, select only the skills you want and the learning method you need. -
SCORM-compliant; and will work great in your LMS.
Average Improvement Results |
||||
|---|---|---|---|---|
| Assess | Learn | Verify | Improvement | |
Excel 2013 Advanced |
58%
|
|||
PivotTables
|
48%
|
|||
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
|
59%
|
|||
Create PivotCharts |
 |
|||
PivotChart Options |
||||
PivotChart Styles |
||||
Drill-Down Data |
||||
Troubleshoot Formulas
|
62%
|
|||
Formula Errors |
|
|||
The Watch Window |
||||
Evaluate Formulas |
||||
Advanced Formatting
|
66%
|
|||
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
|
51%
|
|||
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
|
70%
|
|||
Goal Seek |
|
|||
Scenario Manager |
||||
Consolidate Data |
||||
Macros
|
62%
|
|||
Enable Macros |
|
|||
Create Macros |
||||
Modify Macros |
||||
Copy Macros |
||||
