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

Introduction to Computational Finance and Financial Econometrics
University of Washington via Coursera Excel 2010
Miríadax The Finance of Retirement & Pensions
Stanford Graduate School of Business via NovoEd Einführung in die Wahrscheinlichkeitstheorie
Johannes Gutenberg University Mainz via iversity Introduction to VBA/Excel Programming
Cal Poly Pomona via Open Education by Blackboard