Page 158 - Ms Excel Note and Workbook

MICROSOFT EXCEL NOTE AND WORKBOOK

15 INTRO TO PIVOTTABLES

Using PivotTables to Answer Questions

Consider the example below. Let's say we wanted to answer the question What is the amount sold
by each salesperson? Answering it could be time consuming and difficult; each salesperson appears

on multiple rows, and we would need to total all of their different orders individually. We could use
the Subtotal command to help find the total for each salesperson, but we would still have a lot of
data to work with.

TIP
PivotTable can instantly
calculate and summarize
the data in a way that will
make it much easier to
read.

Fortunately, a PivotTable can instantly calculate and summarize the data in a way that will make it
much easier to read. When we're done, the PivotTable will look something like this:

TIP
Once you've created a
PivotTable, you can use it
to answer different
questions

149 | P a g e