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

Excel Skills for Business: Intermediate I
Macquarie University via Coursera Create Charts and Dashboard using Google Sheets
Coursera Project Network via Coursera Access 2016: Building Dashboards for Excel
LinkedIn Learning Excel 2016: Setting Up a Database
LinkedIn Learning Excel PivotTables: Mastering PivotTables and PivotCharts
LinkedIn Learning