Event Description

This course is a two-lesson advanced level course that guides you through creating, formatting, and modifying PivotTables and PivotCharts in Excel using step-by-step hands-on activities.

Designed For

Users experienced with using Excel 2019 who want to grow their Excel skills.

Objectives

Select different methods to create a PivotTable including the PivotTable button, Recommended PivotTables button, the Quick Analysis feature, and the Summarize with PivotTable button and Data Model Recognize multiple ways to format a PivotTable using a shortcut menu and buttons on the PivotTable Tools Design tab Identify ways to modify a PivotTable using buttons on the PivotTable Tools Analyze tab, a keyboard shortcut, the filtering arrows, the Field List, slicers, and a shortcut menu Select different methods to create a PivotChart including the PivotChart button, standard Excel charting buttons, a keyboard shortcut, and simultaneously with the PivotTable Recognize multiple ways to format a PivotChart using the Chart Elements and Chart Styles buttons, buttons on the PivotChart Tools Design and Format tabs, task panes, a shortcut menu Identify ways to modify a PivotChart using Pivot Field buttons, a shortcut menu, the Field List, and buttons on the PivotChart Tools Design tab

Major Subjects

Use the PivotTable button to create a PivotTableUse the Recommend PivotTables button to create a PivotTableUse the Quick Analysis feature to create a PivotTableUse the Summarize as PivotTable button with the Data Model to create a PivotTableFormat the PivotTable values using a shortcut menuChange the PivotTable layout using the PivotTable Tools Design tabRearrange, hide and show subtotals and grand totals using the PivotTable Tools Design tabApply a PivotTable style using the PivotTable Tools Design tabRefresh a PivotTable using the PivotTable Tools Analyze tab or keyboard shortcutFilter a PivotTable using the filtering arrowsModify the PivotTable structure using the Field ListFilter a PivotTable using slicersAdd a calculated field to a PivotTable using the PivotTable Tools Analyze tabModify the Value Field Settings using a shortcut menuUse the PivotChart button to create an embedded PivotChartUse the standard Excel charting buttons to create a PivotChartUse a keyboard shortcut to create a PivotChart on its own chart sheetCreate a PivotChart and linked PivotTable simultaneouslyAdd or remove chart elements using the Chart Elements buttonChange the chart style and color scheme using the Chart Styles buttonChange the chart layout using the PivotChart Tools Design tabSelect and format individual chart elements using the PivotChart Tools Format tabFilter the PivotChart using the Pivot Field buttonsChange the chart type and subtype using a shortcut menAdd, remove, and reposition the PivotChart fields using the Field ListSwitch the row/column orientation using the PivotChart Tools Design tab

Instructions

None