YoVDO

Excel for Mac: PivotTables in Depth

Offered By: LinkedIn Learning

Tags

Microsoft Excel Courses Data Analysis Courses Data Visualization Courses Data Management Courses PivotTables Courses PivotCharts Courses

Course Description

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

Related Courses

Données et services numériques, dans le nuage et ailleurs
Certificat informatique et internet via France Université Numerique
Introduction to Digital Curation
University College London via Independent
Excel Avanzado
Miríadax
SAP Business Warehouse powered by SAP HANA
SAP Learning
Programming Mobile Applications for Android Handheld Systems: Part 2
University of Maryland, College Park via Coursera