Excel 2019 Bible

Chapter 29: Introducing PivotTables 29 FIGURE 29.13 This PivotTable shows daily totals for each branch. FIGURE 29.14 This PivotT ...

Part IV: Managing and Analyzing Data ■ (^) The Weekday field is in the Rows section. ■ The Amount field is in the Values section ...

Chapter 29: Introducing PivotTables 29 FIGURE 29.16 This PivotTable counts the number of accounts that fall into each value rang ...

Part IV: Managing and Analyzing Data FIGURE 29.17 This PivotTable uses a filter to show only the teller data. This PivotTable us ...

Chapter 29: Introducing PivotTables 29 ■ (^) The Customer field is in the Filters section. ■ The OpenedBy field is in the Filter ...

679 C H A P T E R 30 Analyzing Data with PivotTables IN THIS CHAPTER Creating a PivotTable from non-numeric data Grouping items ...

Part IV: Managing and Analyzing Data FIGURE 30.1 This table doesn’t have any numeric fields, but you can use it to generate the ...

Chapter 30: Analyzing Data with PivotTables 3030 ■ (^) To show percentages, add a second instance of the Location field to the V ...

Part IV: Managing and Analyzing Data Arizona, California, and Washington in the PivotTable. Then right-click the selected cells ...

Chapter 30: Analyzing Data with PivotTables 3030 FIGURE 30.4 PivotTables with options for subtotals and grand totals Automatic g ...

Part IV: Managing and Analyzing Data FIGURE 30.5 You can use a PivotTable to summarize the sales data by month. A workbook demon ...

Chapter 30: Analyzing Data with PivotTables 3030 FIGURE 30.6 The PivotTable with Excel’s automatic grouping FIGURE 30.7 Use the ...

Part IV: Managing and Analyzing Data FIGURE 30.8 The PivotTable, after grouping by month and year If you select only Months in t ...

Chapter 30: Analyzing Data with PivotTables 3030 FIGURE 30.9 This PivotTable shows sales by quarter and by year. Multiple Groups ...

Part IV: Managing and Analyzing Data Grouping by time Figure 30.10 shows a set of data in columns A:B. Each row is a reading fro ...

Chapter 30: Analyzing Data with PivotTables 3030 summary method for a column, right-click any cell in the column and choose the ...

Part IV: Managing and Analyzing Data The Grouping dialog box that generated the bins specified that the groups start at 1, end a ...

Chapter 30: Analyzing Data with PivotTables 3030 This example uses the Excel Grouping dialog box to create the groups automatica ...

Part IV: Managing and Analyzing Data FIGURE 30.13 This data demonstrates calculated fields and calculated items. FIGURE 30.14 Th ...

Chapter 30: Analyzing Data with PivotTables 3030 The examples that follow create ■ A calculated field, to compute average sales ...