Excel Training Course: PivotTable

Module 2: Customize your PivotTable (Format, Sort, Group, etc..)

Your total points (the more you visit each page, the more points you earn): [mycred_my_balance]
12% Complete

Introduction

In this module, we will learn the various operations of a PivotTable, which render this tool extremely powerful in data analysis.

If you have any questions or comments, please enter your comments in the "Discussion Area" below the videos.  We learn better through discussion and mutual support!

Format a PivotTable

Sort within a PivotTable

Add Subtotals

Change Types of Data to Analyze

Refresh Data

Apply Conditional Formatting (aka. heat map)

Draw PivotChart

Please provide your feedback to this module: