Excel Training Course: PivotTable

Module 1: What is a 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 basics of a PivotTable, and why it is such a powerful tool any business professionals should learn to use.

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 Needed for this Module

Let's start with an example:

Sales of 2 products in 3 markets over 3 months

Now let's look at the data, and how to generate the above PivotTable.

Download Excel File

Different parts of a PivotTable, and how to change them.

Download Excel File

Please provide your feedback to this module:

Ready to go to another module?

Surescripts: Epilogue

Surescripts: Epilogue
Surescripts Module 1: Work Faster and Better in Excel

Surescripts Module 1: Work Faster and Better in Excel
Surescripts Module 2: Organizing Data

Surescripts Module 2: Organizing Data
Surescripts Module 3: PivotTables

Surescripts Module 3: PivotTables
Surescripts Module 4: Charts and Graphs

Surescripts Module 4: Charts and Graphs
Surescripts Module 5: Scenario Analysis and What-ifs

Surescripts Module 5: Scenario Analysis and What-ifs
Surescripts Module 6: Excel Modeling

Surescripts Module 6: Excel Modeling
Surescripts Module 7: Data Analysis

Surescripts Module 7: Data Analysis

Discussion Area

Have a question or comments?  Enter below!

Your thoughts?