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

LinkedIn Learning

Excel: PivotTable Tips

via LinkedIn Learning

Overview

Prepare for a new career with $100 off Coursera Plus
Gear up for jobs in high-demand fields: data analytics, digital marketing, and more.
Go from beginner to power PivotTable user. Learn how to use Excel PivotTables and PivotCharts for powerful data analysis.

Syllabus

Introduction
  • About the Pro Tip series
  • Learn PivotTable tips
1. PivotTable Tips
  • Customizing the field list
  • Autofitting column width
  • Outline and tabular layouts
  • Counting nonnumerical fields
  • Grouping dates
  • Enabling multiple filters
  • Grouping values
  • Adding value calculations
  • Showing empty items
  • Configuring slicers and timelines
  • Conditional formatting
  • Removing and reviving source data
  • Adding custom sort lists
  • Solve order and list formulas
Conclusion
  • Conclusion: PivotTable Tips

Taught by

Chris Dutton

Reviews

4.7 rating at LinkedIn Learning based on 375 ratings

Start your review of Excel: PivotTable 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.