Excel for Mac: PivotTables in Depth

Learn how to summarize and analyze data using one of the most powerful and overlooked features in Excel for Mac: PivotTables.

Introduction

• Use Excel PivotTables to summarize and analyze data
• What you should know

1. Create and Pivot PivotTables

• Introducing PivotTables
• Format data for use in a PivotTable
• Create a PivotTable
• Pivot a PivotTable
• Configure a PivotTable
• Connect to an external data source
• Manage PivotTables

2. Summarizing PivotTable Data

• Manage subtotals and grand totals
• Change the data field summary operation
• Summarize more than one data field
• Create a calculated field
• Drill down to the underlying data
• Use PivotTable data in a formula

3. Sort and Filter PivotTable Data

• Sort PivotTable data
• Filter a PivotTable field by selection
• Filter a PivotTable by rule
• Filter a PivotTable using a search filter
• Filter a PivotTable using slicers
• Format slicers
• Filter with report filter fields
• Clear and reapply PivotTable filters

4. Format and Print PivotTables

• Apply a PivotTable style
• Create a PivotTable style
• Change the PivotTable layout
• Change the data field number format
• Print a PivotTable

5. Apply Conditional Formats to PivotTables

• Highlight cells by applying a rule
• Highlight the top or bottom values in a PivotTable
• Format cells using data bars
• Format cells using color scales
• Format cells using icon sets
• Edit a conditional formatting rule
• Control how multiple rules are applied
• Delete a conditional formatting rule

6. Summarize Data Visually Using a PivotChart

• Create a PivotChart
• Pivot a PivotChart
• Filter a PivotChart
• Format a PivotChart
• Change a PivotChart chart type

Conclusion

• Next steps