• Less than 1 hour of material
  • LinkedIn Learning
  • English
Excel PivotTable Quick Tips

Course Overview

Explore quick, bite-sized tips on how to analyze data quickly with PivotTables in Microsoft Excel.

Course Circullum

Introduction
  • Analyze your data quickly with PivotTables
1. PivotTable Basics
  • Get data ready for a PivotTable
  • Create a basic PivotTable
  • Use a recommended PivotTable
2. Adjusting 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
  • 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. Addressing Common Error Messages
  • PivotTable error messages: Field name not valid
  • Refresh a PivotTable
  • PivotTable error messages: Overlapping reports
out of 5.0
5 Star 85%
4 Star 75%
3 Star 53%
1 Star 20%

Item Reviews - 3

Submit Reviews

Free Trial Available

This Course Include:
Introduction
  • Analyze your data quickly with PivotTables
1. PivotTable Basics
  • Get data ready for a PivotTable
  • Create a basic PivotTable
  • Use a recommended PivotTable
2. Adjusting 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
  • 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. Addressing Common Error Messages
  • PivotTable error messages: Field name not valid
  • Refresh a PivotTable
  • PivotTable error messages: Overlapping reports
  • Provider:LinkedIn Learning
  • Certificate:Certificate Available
  • Language:English
  • Duration:Less than 1 hour of material
  • Language CC:

Do You Have Questions ?

We'll help you to grow your career and growth.
Contact Us Today