4 hour course

Excel 2013 Advanced

Users love us
4.9 stars out of 5 on G2

4.9 out of 5 on G2

Try this course with a Free Trial

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

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