Excel: PivotTable Tips

Go to class
Write Review

Free Online Course: Excel: PivotTable Tips provided by LinkedIn Learning is a comprehensive online course, which lasts for 1-2 hours worth of material. The course is taught in English and is free of charge. Upon completion of the course, you can receive an e-certificate from LinkedIn Learning. Excel: PivotTable Tips is taught by Chris Dutton.

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