Excel: PivotTable Tips

Offered By: LinkedIn Learning

Tags

PivotTables Courses Data Analysis Courses Slicers Courses PivotCharts Courses

Course Description

Overview

Go from beginner to power PivotTable user. Learn how to use Excel PivotTables and PivotCharts for powerful data analysis.

Syllabus

Introduction

About the Pro Tip series
Learn PivotTable tips

1. PivotTable Tips

Customizing the field list
Autofitting column width
Outline and tabular layouts
Counting nonnumerical fields
Grouping dates
Enabling multiple filters
Grouping values
Adding value calculations
Showing empty items
Configuring slicers and timelines
Conditional formatting
Removing and reviving source data
Adding custom sort lists
Solve order and list formulas

Conclusion

Conclusion: PivotTable Tips

Taught by

Chris Dutton

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