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

Social Network Analysis
University of Michigan via Coursera Intro to Algorithms
Udacity Data Analysis
Johns Hopkins University via Coursera Computing for Data Analysis
Johns Hopkins University via Coursera Health in Numbers: Quantitative Methods in Clinical & Public Health Research
Harvard University via edX