HOSP 187 Chapter Notes - Chapter 22: Pivot Table, Dialog Box

• School: University of Delaware
• Department: Hotel, Restaurant and Institutional Management
• Course: HOSP 187
• Professor: Zjisk

Document Summary

Pivot tables quickly summarize long lists of data. Calculate info without writing a single formula or copying a single cell. This pro(cid:272)ess of rearranging your ta(cid:271)le is kno(cid:449)n as pi(cid:448)oting your data: you"re turning the same information around to examine if from different angles. To look for trends and patterns in lists, it helps to build a summary table a table that tallies key amounts, like the average amount spent for a customer in a specific city, education level or gender. It has to include at least one column that has duplicate values. The order info table is perfect for a pivot table because it has several columns you can use to group the order rows, including: product and category, customer, ship city and ship country. Drag the quantity field to the values box. Some pivot tables layout use banding a pattern of alternating shading that separates one row from the next.