• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 11. Managing a Database with Exc... > Summarizing and Comparing Data with ...

Summarizing and Comparing Data with Pivot Tables

Excel’s pivot tables are reports that summarize worksheet data and lay it out in a more meaningful format. For example, suppose you had a database that kept track of your monthly sales by product and salesperson. You could create a pivot table to summarize the amount of each product sold each month by each salesperson. You could then quickly rearrange the table to analyze the data in various ways. Figure 11.12 illustrates how a pivot table works.

Figure 11.12. A pivot table summarizes and organizes your data.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint