Course:Excel 2013 Advanced | CustomGuide
Excel 2013 Advanced

Excel 2013 Advanced

Certiport

100% Aligned to MOS Certification

Excel 2013 Advanced
Excel 2013 Advanced
Upgrade for Progress
Complete Course to Display Score
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
PivotCharts Verified Learning
Create PivotCharts
PivotChart Options
PivotChart Styles
Drill-Down Data
Troubleshoot Formulas Verified Learning
Formula Errors
The Watch Window
Evaluate Formulas
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
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
Analyze Data Verified Learning
Goal Seek
Scenario Manager
Consolidate Data
Macros Verified Learning
Enable Macros
Create Macros
Modify Macros
Copy Macros