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

Learn Excel 2016 Intermediate Level - Beyond the Basics
Udemy Microsoft Excel - Improve your skills quickly
Udemy Access 2016: Building Dashboards for Excel
LinkedIn Learning Cert Prep: Excel 2013 Microsoft Office Expert Part Two (77-428)
LinkedIn Learning Excel 2010: Pivot Tables
LinkedIn Learning