Excel: PivotTable Tips
Offered By: LinkedIn Learning
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
- 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: PivotTable Tips
Taught by
Chris Dutton
Related Courses
Using Covid-19 Data to Make Supply Chain Logistics Decisions in SpreadsheetsCoursera 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