Excel 2010 Bible

Chapter 34: Introducing Pivot Tables 699 A single database table can have any number of data fields and category fields. When yo ...

Part V: Analyzing Data with Excel 700 FIGURE 34.5 This range contains normalized data and is appropriate for a pivot table. Figu ...

Chapter 34: Introducing Pivot Tables 701 Creating a Pivot Table In this section, I describe the basic steps required to create a ...

Part V: Analyzing Data with Excel 702 Click OK, and Excel creates an empty pivot table and displays its PivotTable Field List ta ...

Chapter 34: Introducing Pivot Tables 703 Note In versions prior to Excel 2007, you could drag items from the field list directly ...

Part V: Analyzing Data with Excel 704 You can apply any of several built-in styles to a pivot table. Select any cell in the pivo ...

Chapter 34: Introducing Pivot Tables 705 l (^) Item: An element in a field that appears as a row or column header in a pivot tab ...

Part V: Analyzing Data with Excel 706 Modifying the pivot table After you create a pivot table, changing it is easy. For example ...

Chapter 34: Introducing Pivot Tables 707 Pivot table data is most frequently summarized using a sum. However, you can display yo ...

Part V: Analyzing Data with Excel 708 A pivot table is very flexible, but it does have some limitations. For example, you can’t ...

Chapter 34: Introducing Pivot Tables 709 FIGURE 34.13 This pivot table shows daily totals for each branch. Question 2 Which day ...

Part V: Analyzing Data with Excel 710 FIGURE 34.14 This pivot table shows totals by day of the week. Question 3 How many account ...

Chapter 34: Introducing Pivot Tables 711 FIGURE 34.16 This pivot table counts the number of accounts that fall into each value r ...

Part V: Analyzing Data with Excel 712 l (^) The Amount field is in the Values section (summarized by Count). l A second instance ...

Chapter 34: Introducing Pivot Tables 713 FIGURE 34.18 This pivot table (and pivot chart) compares the Central branch with the ot ...

Part V: Analyzing Data with Excel 714 FIGURE 34.19 This pivot table uses three Report Filters. Learning More The examples in thi ...

715 CHAPTER Analyzing Data with Pivot Tables IN THIS CHAPTER How to create a pivot table from non-numeric data How to group item ...

Part V: Analyzing Data with Excel 716 Here are the settings I used for this pivot table: l The Sex field is used for the Column ...

Chapter 35: Analyzing Data with Pivot Tables 717 FIGURE 35.2 The pivot table, after making a few changes. Grouping Pivot Table I ...

Part V: Analyzing Data with Excel 718 FIGURE 35.3 A pivot table with two groups. Figure 35.4 shows pivot tables using various op ...