Course Content

Subtotals

· Creating Subtotals

· Adjusting Views with Subtotals

PivotTables

· Creating a PivotTable Report

Analyzing Data Using PivotTables

· Rearranging the PivotTable

· Sorting a PivotTable

· Filtering a PivotTable

Formatting a PivotTable

· Changing a PivotTable Calculation

Summarizing Fields by Different Functions

· Show Values as Percentages

Refreshing Data in a PivotTable

· Refresh PivotTable Data Automatically When Workbook Opens

Adding Records to the Source Data

Grouping Options

· Group Numeric Items

· Group Dates or Times

· Group Selected Items

· Rename a Default Group Name

· Ungroup Items

· Timelines – An Alternative to Grouping Dates

PivotTable Drilldown

· Exploding the Data from a Single Cell

· Create a Separate PivotTable Reports for Multiple Sets of Data

Using Slicers

Custom Calculations

· PivotTable Formula Elements

· Add a Calculated Field

· Add a Calculated Item to a Field

· Edit or Remove a Calculated Field

Field Settings

Using PivotTable Styles

· Pivot Table Style Options

Subtotals and Grand Totals

Report Layouts; Compact, Tabular and Outline

Analyze Ribbon – Additional Tools

· PivotTable Group

· Show/Hide Group

· Actions group

Modify Pivot Table Field List

· Pivot Tables Field List Search

Conditional Formatting

Creating a PivotChart

· Creating a PivotChart

· Chart drill down

Standalone PivotCharts