One of the most
under-utilized tools in Excel is Pivot Tables. This section is
intended to help you better understand their use.
Imagine an Excel
worksheet of sales figures with hundreds or thousands of rows of
data. The worksheet lays out all the data about salespeople in
two countries and how much they sold on individual days. But
it's a lot of data to deal with — listed in row after row and
divided into multiple columns. How can you get information out
of the worksheet? How can you make sense out of all of this
Who sold the most overall? Who sold the most per quarter or per
year? Which country has the most sales? You can get answers to
all these questions with PivotTable reports — it's like turning
a mob into a marching band. A PivotTable report turns all that
data into small, concise reports that tell you exactly what you
need to know.
Save and unzip the files below to a folder of your
choice. Then, open the Word document for reference as you perform
tasks in each workbook.
NOTE: Check out
our Free Training page, Level 5 of Excel 2000 and XP.