Manage Workbook options and Settings

Manage Workbooks

Save a workbook as a template

Copy macros between workbooks

Manage Document Versions

Reference data in another workbook

Reference data by using structured references

Enable macros in a workbook

Display hidden ribbon tabs

Manage Workbook Review

Restrict editing

Protect a worksheet

Configure formula calculation options

Protect workbook structure

Manage workbook versions

Encrypt workbooks with a password

Apply custom data formats and Layouts

Apply custom data formats and Validation

Create custom number formats

Populate cells by using advanced Fill Series options

Configure data validation

Apply advanced conditional Formatting and Filtering

Create custom conditional formatting rules

Create conditional formatting rules that use formulas

Manage conditional formatting rules

Create and Modify Custom Workbook Elements

Create custom colour formats

Create and modify cell types

Create and modify custom themes

Create and modify simply macros

Insert and configure form controls

Prepare a Workbook for Internationalization

Display data in multiple international formats

Apply international currency formats

Manage multiple options for +Body and +Heading fonts

Create advanced Formulas

Apply functions in Formulas

Perform logical operations by using the AND, OR and NOT functions

Perform logical operations by using the nested functions

Perform statistical operations by using SUMIFS, AVERAGEIFS AND COUNTIFS functions

Look up data using Functions

Look up data by using the VLOOKUP

Look up data by using the HLOOKUP function

Look up data by using the MATCH function

Look up data by using the INDEX function

Apply advanced date and time Functions

Reference the date and time by using the NOW and TODAY functions

Serialize numbers by using date and time functions

Perform data analysis and business Intelligence

Import, transform, combine, display and connect to data

Consolidate data

Perform what-if analysis by using Goal Seek and Scenario Manager

Use cube functions to get data out of the Excel data model

Calculate data by using financial functions

Troubleshoot Formula’s

Trace precedence and dependence

Monitor cells and formula’s by using the Watch Window

Validate formula’s by using error checking values

Evaluate formula’s

Calculate data by using financial functions

Define named ranges and Objects

Name cells

Name data ranges

Name tables

Manage named ranges and objects

Create advanced charts and Tables

Create advanced Charts

Add trend lines to charts

Create dual axis charts

Save a chart as a template

Create and manage PivotTables

Create PivotTables

Modify field selections and options

Create slicers

Group PivotTable data

Reference data in a PivotTable by using the GETPRIVOTDATA function

Add calculated fields

Format data

Create and manage PivotCharts

Create PivotCharts

Manipulate options in existing PivotCharts

Apply styles to PivotCharts

Apply styles to PivotCharts

Manipulate options in existing PivotCharts

Drill down into PivotChart details