Course:Excel 2016 Advanced | CustomGuide

Excel 2016 Advanced

Excel 2016 Advanced Try this course with a
Skill Pre-assess Lesson Post-assess Learning mode
PivotTables
Verified Learning
Create PivotTables Click to start 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
Skill Pre-assess Lesson Post-assess Learning mode
PivotCharts
Verified Learning
Create PivotCharts
PivotChart Options
PivotChart Styles
Drill-Down Data
Skill Pre-assess Lesson Post-assess Learning mode
Troubleshoot Formulas
Verified Learning
Formula Errors
The Watch Window
Evaluate Formulas
Skill Pre-assess Lesson Post-assess Learning mode
Advanced Formatting
Verified Learning
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
Skill Pre-assess Lesson Post-assess Learning mode
Advanced Formulas
Verified Learning
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
Skill Pre-assess Lesson Post-assess Learning mode
Analyze Data
Verified Learning
Goal Seek
Scenario Manager
Consolidate Data
Skill Pre-assess Lesson Post-assess Learning mode
Macros
Verified Learning
Enable Macros
Create Macros
Modify Macros
Copy Macros