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

LinkedIn Learning

Excel PivotTable Quick Tips

via LinkedIn Learning

Write review

Overview

AI, Data Science & Cloud Certificates from Google, IBM & Meta — 40% Off
One plan covers every Professional Certificate on Coursera. 40% off Coursera Plus Annual.
Unlock All Certificates
Leverage Excel PivotTables efficiently as you move beyond basic PivotTable functions to create powerful, customized reports that transform complex data into meaningful insights.

Syllabus

Introduction
  • Analyze your data quickly with PivotTables
1. Excel PivotTable Basics
  • Get data ready for an Excel PivotTable
  • Create a basic Excel PivotTable
  • Use a recommended PivotTable
  • Create multiple PivotTables
2. Adjusting Excel PivotTable Data
  • Rearrange a PivotTable
  • Calculate values in a PivotTable
  • Summarize values in a PivotTable
  • Expand and collapse details in a PivotTable
  • Format data in a PivotTable
  • Group data in a PivotTable
3. Filtering and Sorting Data in a PivotTable
  • Filter data in a PivotTable
  • Sort data in a PivotTable
4. Conditional Formatting with PivotTables
  • Apply conditional formatting to a PivotTable
  • Remove conditional formatting from a PivotTable
5. PivotCharts and Slicers
  • Create a basic PivotChart
  • Insert slicers into a PivotTable
6. Data Grouping with Excel Functions
  • Use GROUPBY to view data like a PivotTable
  • Use PIVOTBY to view data with more columns
7. Addressing Common Error Messages in PivotTables
  • PivotTable error messages: Field name not valid
  • Refresh a PivotTable
  • PivotTable error messages: Overlapping and make space

Taught by

Jess Stratton

Reviews

4.7 rating at LinkedIn Learning based on 582 ratings

Start your review of Excel PivotTable Quick Tips

Never Stop Learning.

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

Someone learning on their laptop while sitting on the floor.