Excel Training Course: PivotTable

Module 3: Extract Intelligence with PivotTable

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!

Download all Excel files for this module

Apply a filter

Add a layer

Group data by dates

Group data by values

Create a histogram (i.e. distribution chart) by grouping data

Please provide your feedback to this module: