Go To Special Command: Go To Special is a tool within Microsoft Excel that enables you to quickly select cells of a specified type within your Excel worksheet. This feature can be enabled or disabled as needed. GETPIVOTDATA: This feature allows users to craft formulas that refer to specific data within the pivot table, as opposed to a specific cell address, so that formulas maintain integrity even if the pivot table fields are rearranged. The Filter feature is available on the Data tab of all versions of Excel as well under the Sort & Filter command on the Home menu. Hiding Field Buttons on Pivot Chart 01:32:30Īnalyze: The ANALYZE tab has several commands that will enable you to explore the data in the PivotTable.Ĭtrl-Enter: When you have two or more cells selected in Excel, this keyboard shortcut puts the contents of the first cell in the selection in all selected cells at once.ĭesign: The DESIGN tab commands will be useful to structure the PivotTable with various report options and style options.ĭrill Down: When a user double-clicks on any number within a pivot table, Excel creates a new worksheet that displays the underlying records.įilter: The Filter feature in Excel allows you to show or hide rows within a list of data by making selections from drop-down lists.
Timeline Feature (Excel 3013 and later) 01:22:27 Preventing Pivot Table Drill Down 00:50:16 Reconstructing Pivot Table Source Data 0044:48 Remove Table Feature from Worksheet 00:41:58 Tables Eliminate Data Integrity Risk 00:37:36 Previous Experience with Excel Pivot Tables
Excel pivot chart drill down how to#
Discovering the Recommended PivotTables feature.Avoiding disabled features by converting Excel 97–2003 files to modern workbook formats with ease.Practitioners who would like to learn how to manipulate their pivot table data faster and more efficiently. David also provides an Excel workbook that includes most of the examples used in the course. He draws your attention to any differences in Excel 2013, 2010, or 2007 during the presentation as well as in his detailed handouts. After participating in David’s presentation, you’ll know how to create self-updating titles for charts and pivot charts, expand and collapse pivot table elements, drill down into numbers with a simple double-click, and more.ĭavid demonstrates every technique at least twice: first, on a PowerPoint slide with numbered steps, and second, in Excel 2016. He explains the PivotTable feature, the PowerPivot feature, the Recommended PivotTables feature, and others. In Part 2, Excel expert David Ringstrom, CPA, goes beyond the basics of pivot tables.