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

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