Getting into the Pivot Table Environment

The pivot table environment might seem somewhat scary the first time you see it, but as you gather some experience and practice using it, you soon start to see that there sure is a method behind the madness.

Pivot Tables take data management for the everyday user to another level. Using simple commands and drag and drop gestures, you can organize long lists of information and create custom tables from a list of entries or a database.

The tables you create with this tool have dynamic features, which means they stay connected to the original list of data. As you modify your database, you can have your pivot table updated accordingly.

Just as any of the functions we have looked at in this section, pivot tables are a great tool to master for people who work with comprehensive lists on a regular basis.