Excel 2019 Bible

Chapter 28: Linking and Consolidating Worksheets 28 FIGURE 28.9 Expanding the outline to show more details For more information ...

Part IV: Managing and Analyzing Data Excel remembers the references that you entered in the Consolidate dialog box and saves the ...

655 C H A P T E R 29 Introducing PivotTables IN THIS CHAPTER Understanding PivotTables Identifying types of data appropriate for ...

Part IV: Managing and Analyzing Data PivotTables were introduced in Excel 97, and this feature improves with every new version o ...

Chapter 29: Introducing PivotTables 29 This table consists of a month’s worth of new account information for a three-branch bank ...

Part IV: Managing and Analyzing Data FIGURE 29.2 A simple PivotTable FIGURE 29.3 A PivotTable that uses a report filter Notice t ...

Chapter 29: Introducing PivotTables 29 If you were handed a strange object and asked to identify it, you’d probably look at it f ...

Part IV: Managing and Analyzing Data Using Worksheet Outlines.” Although the range contains descriptive information about each v ...

Chapter 29: Introducing PivotTables 29 FIGURE 29.5 This range contains normalized data and is appropriate for a PivotTable. FIGU ...

Part IV: Managing and Analyzing Data This workbook, named normalized data.xlsx, is available on this book’s website at www .wile ...

Chapter 29: Introducing PivotTables 29 If your data is in an external database, start by selecting a blank cell. When you choose ...

Part IV: Managing and Analyzing Data Excel attempts to guess the range, based on the location of the active cell. If you’re crea ...

Chapter 29: Introducing PivotTables 29 FIGURE 29.9 Use the PivotTable Fields task pane to build the PivotTable. Drag the Branch ...

Part IV: Managing and Analyzing Data Figure 29.10 shows the completed PivotTable. FIGURE 29.10 After a few simple steps, the Piv ...

Chapter 29: Introducing PivotTables 29 Column labels A field that has a column orientation in the PivotTable. Each item in the f ...

Part IV: Managing and Analyzing Data Source data The data used to create a PivotTable. It can reside in a worksheet or an extern ...

Chapter 29: Introducing PivotTables 29 the display by using the controls in the PivotTable Tools ➪ Design ➪ PivotTable Style Opt ...

Part IV: Managing and Analyzing Data Use the Summarize Values By tab to select a different summary function. Your choices are Su ...

Chapter 29: Introducing PivotTables 29 Here are some tips on other PivotTable modifications you can make: ■ To remove a field fr ...

Part IV: Managing and Analyzing Data Copying a PivotTable’s Content A PivotTable is flexible, but it does have some limitations. ...