Excel PivotTable Quick Tips

Offered By: LinkedIn Learning

Tags

Microsoft Excel Courses Data Analysis Courses Data Visualization Courses Microsoft Office 365 Courses Data Filtering Courses Spreadsheets Courses Slicers Courses PivotTables Courses PivotCharts Courses

Course Description

Overview

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

Syllabus

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

Taught by

Jess Stratton

Related Courses

Using Covid-19 Data to Make Supply Chain Logistics Decisions in Spreadsheets
Coursera Project Network via Coursera Microsoft Excel - Excel from Beginner to Advanced
Udemy Excel Shortcuts, Excel Tips, Excel Tricks - Excel Skills!
Udemy Learn Excel 2016 Intermediate Level - Beyond the Basics
Udemy Microsoft Excel Mastery: From Beginner to Pro
Udemy