Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

LinkedIn Learning

Excel for Mac: PivotTables in Depth

via LinkedIn Learning

Overview

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

Syllabus

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

Taught by

Curt Frye

Reviews

4.7 rating at LinkedIn Learning based on 58 ratings

Start your review of Excel for Mac: PivotTables in Depth

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.