- Courses
- Excel 2013 Advanced

4 hour course
Excel 2013 Advanced
4.9 out of 5 on G2
Try this course with a Free Trial
Learn to:
- Create PivotTables
- Troubleshoot complex formulas
- Automate tasks with macros
- Use IF, VLOOKUP, & advanced
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 |