Excel 2010 Bible

Chapter 35: Analyzing Data with Pivot Tables 719 Automatic grouping examples When a field contains numbers, dates, or times, Exc ...

Part V: Analyzing Data with Excel 720 FIGURE 35.6 The pivot table, before grouping by month. FIGURE 35.7 Use the Grouping dialog ...

Chapter 35: Analyzing Data with Pivot Tables 721 FIGURE 35.8 The pivot table, after grouping by month and year. Figure 35.9 show ...

Part V: Analyzing Data with Excel 722 Grouping by time Figure 35.10 shows a set of data in columns A:B. Each row is a reading fr ...

Chapter 35: Analyzing Data with Pivot Tables 723 Figure 35.11 shows part of a table of 221 students and the test score for each. ...

Part V: Analyzing Data with Excel 724 FIGURE 35.12 The pivot table and pivot chart show the frequency distribution for the test ...

Chapter 35: Analyzing Data with Pivot Tables 725 The formulas used to create calculated fields and calculated items aren’t stand ...

Part V: Analyzing Data with Excel 726 FIGURE 35.14 This pivot table was created from the sales data. Creating a calculated field ...

Chapter 35: Analyzing Data with Pivot Tables 727 the data source. For this example, the calculated field name is Average Unit Pr ...

Part V: Analyzing Data with Excel 728 FIGURE 35.16 This pivot table uses a calculated field. Inserting a calculated item The pre ...

Chapter 35: Analyzing Data with Pivot Tables 729 Enter a name for the new item in the Name field and specify the formula in the ...

Part V: Analyzing Data with Excel 730 After you create the calculated items, they appear in the pivot table. Figure 35.18 shows ...

Chapter 35: Analyzing Data with Pivot Tables 731 Filtering Pivot Tables with Slicers A Slicer is an interactive control that mak ...

Part V: Analyzing Data with Excel 732 New Feature Slicers are new to Excel 2010. n The same type of filtering can be accomplishe ...

Chapter 35: Analyzing Data with Pivot Tables 733 FIGURE 35.21 Using Slicers to filter a pivot table by state and by month. Refer ...

Part V: Analyzing Data with Excel 734 Column F contains formulas, and this column is not part of the pivot table. These formulas ...

Chapter 35: Analyzing Data with Pivot Tables 735 FIGURE 35.23 After expanding the pivot table, formulas that use the GETPIVOTDAT ...

Part V: Analyzing Data with Excel 736 A pivot chart example Figure 35.24 shows part of a table that tracks daily sales by region ...

Chapter 35: Analyzing Data with Pivot Tables 737 A pivot chart includes field buttons that let you filter the chart’s data. To r ...

Part V: Analyzing Data with Excel 738 If you modify the underlying pivot table, the chart adjusts automatically to display the n ...