Learn to:
- Create PivotTables
- Troubleshoot complex formulas
- Automate tasks with macros
- Use IF, VLOOKUP, & advanced
Features:
| Skill | Pre-assess | Lesson | Post-assess | Learning mode |
|---|
Excel 2013 Advanced Outline
|
||||
| Skill | Pre-assess | Lesson | Post-assess | Learning mode |
|---|---|---|---|---|
| PivotTables |
Verified Learning
|
|||
|
Create PivotTables
How to Create PivotTables in Excel |
Not Started | Not Started | Not Started | |
|
Add Multiple PivotTable Fields
How to Add Multiple PivotTable Fields to a PivotTable in Excel |
Not Started | Not Started | Not Started | |
|
Change a PivotTable's Calculation
How to Change a PivotTable's Calculation in Excel |
Not Started | Not Started | Not Started | |
|
Add Calculated Fields
How to Add and Remove Calculated Fields in Excel PivotTables |
Not Started | Not Started | Not Started | |
|
The GETPIVOTDATA Function
How to Use the GETPIVOTDATA Function in Excel |
Not Started | Not Started | Not Started | |
|
Filter PivotTables
How to Filter PivotTables in Excel |
Not Started | Not Started | Not Started | |
|
Timelines
How to Add a Timeline in Excel |
Not Started | Not Started | Not Started | |
|
PivotTable Layout
Adjust a PivotTable's Layout in Excel |
Not Started | Not Started | Not Started | |
|
Group Values
How to Group Values in Excel |
Not Started | Not Started | Not Started | |
|
Refresh a PivotTable
How to Refresh a PivotTable in Excel |
Not Started | Not Started | Not Started | |
|
Format a PivotTable
How to Format a PivotTable in Excel |
Not Started | Not Started | Not Started | |
| Skill | Pre-assess | Lesson | Post-assess | Learning mode |
|---|---|---|---|---|
| PivotCharts |
Verified Learning
|
|||
|
Create PivotCharts
How to Create PivotCharts in Excel | Account Required | |||
|
PivotChart Options
PivotChart Options in Excel | ||||
|
PivotChart Styles
How to Apply PivotChart Styles in Excel | ||||
|
Drill-Down Data
How to Drill-Down Chart Data in Excel | ||||
| Skill | Pre-assess | Lesson | Post-assess | Learning mode |
|---|---|---|---|---|
| Troubleshoot Formulas |
Verified Learning
|
|||
|
Formula Errors
How to Fix Formula Errors in Excel | ||||
|
The Watch Window
How to The Watch Window in Excel | ||||
|
Evaluate Formulas
How to Evaluate Formulas in Excel | ||||
| Skill | Pre-assess | Lesson | Post-assess | Learning mode |
|---|---|---|---|---|
| Advanced Formatting |
Verified Learning
|
|||
|
Customize Conditional Formatting
How to Customize Conditional Formatting in Excel | ||||
|
Conditional Formatting with Formulas
How to Use Conditional Formatting with Formulas in Excel | ||||
|
Manage Conditional Formatting
How to Manage Conditional Formatting in Excel | ||||
|
International Currency and Formats
How to Use International Currency and Formats in Excel | ||||
|
Body and Heading Options
How to Apply Body and Heading Font Options in Excel | ||||
|
Color Formats
How to Create and Apply Color Schemes in Excel | ||||
|
Custom Themes
How to Create and Apply Custom Themes in Excel | ||||
|
Form Controls
How to Form Controls in Excel | ||||
|
Save Form Templates
How to Save a Form as a Template in Excel | ||||
| Skill | Pre-assess | Lesson | Post-assess | Learning mode |
|---|---|---|---|---|
| Advanced Formulas |
Verified Learning
|
|||
|
IF Function
How to Use the IF Function in Excel | ||||
|
Nested Functions
How to Insert Nested Functions in Excel | ||||
|
AND, OR, and NOT Functions
How to use AND, OR, and NOT Functions in Excel | ||||
|
SUMIF, AVERAGEIF, and COUNTIF Functions
How to Use SUMIF, AVERAGEIF, and COUNTIF Functions in Excel | ||||
|
VLOOKUP
How to Use the VLOOKUP Function in Excel | ||||
|
HLOOKUP
How to Use HLOOKUP in Excel | ||||
|
INDEX and MATCH
How to Use the INDEX and MATCH Functions in Excel | ||||
|
UPPER, LOWER, and PROPER
How to Use UPPER, LOWER, and PROPER Functions in Excel | ||||
|
RIGHT, LEFT, and MID
How to Use RIGHT, LEFT, and MID Functions in Excel | ||||
|
Formula Calculation Options
How to Change Formula Calculation Options in Excel | ||||
| Skill | Pre-assess | Lesson | Post-assess | Learning mode |
|---|---|---|---|---|
| Analyze Data |
Verified Learning
|
|||
|
Goal Seek
How to use Goal Seek feature in Excel | ||||
|
Scenario Manager
How Use to Scenario Manager in Excel | ||||
|
Consolidate Data
How to Consolidate Data in Excel | ||||
| Skill | Pre-assess | Lesson | Post-assess | Learning mode |
|---|---|---|---|---|
| Macros |
Verified Learning
|
|||
|
Enable Macros
How to Enable Macros in Excel | ||||
|
Create Macros
How to Create Macros in Excel | ||||
|
Modify Macros
How to Modify Macros in Excel | ||||
|
Copy Macros
How to Copy Macros in Excel | ||||
Quick Answer: