| A | B |
|---|
| Associated PivotTable Report | Interactive with its PivotTable |
| Add-in | An optional command or feature that is not immediately available; you must first install and/or activate an add-in to use it. |
| Clear Filter | A command that removes a filter |
| Column area | An area to position fields that you want to display as columns in the PivotTable report. Field names placed here become column titles, and the data is grouped in columns by these titles. |
| Data Model | A method of incorporating data from multiple, related tables into an Excel worksheet. |
| Field buttons | Buttons on a PivotChart with an arrow to choose a filter |
| Field names | Categories of data for a PivotTable report |
| Field section | The upper portion of the PivotTable that contains the names of all the field names, the column titles in the source data |
| Filter | The process of displaying only a portion of the data based on matching a specific value to show only the data that meets the criteria that you specify |
| Filtering buttons | The buttons on a slicer which you use to select the item by which to filter |
| FILTER area | An area in the lower portion of the PivotTable Fields pane to position fields by which you want to filter the PivotTable report, enabling you to display a subset of data in the PivotTable report. |
| Layout section | The lower portion of the PivotTable field list that has four areas where you can build the PivotTable report by rearranging and repositioning fields |
| PivotChart report | A graphical representation of the data in a PivotTable report |
| PivotTable | Another name for Excel’s PivotTable report |
| PivotTable Fields pane | PivotTable Fields pane |
| Power View | An Excel BI tool that allows you to create and interact with multiple charts, slicers, and other data visualizations in a single sheet. |
| PowerPivot | An Excel BI tool that allows you to analyze data from multiple sources, work with multiple data tables, and create relationships between tables. |
| Refresh | The command to update a worksheet to reflect the new data. |
| Relationship | An association between tables that share a common field. |
| Slicers | Easy-to-use filtering controls with buttons that enable you to intuitively drill down through large amounts of data in an interactive way |
| Source data | Data in an Excel worksheet, or from an external source, arranged in columns and rows in a format suitable to be used for a PivotTable report table or range in the current worksheet |
| Values area | An area in the layout section of the PivotTable Field List in which you can position fields that contain data that is summarized in a PivotTable report or PivotChart report; the data placed here is usually numeric or financial in nature and the data is summarized-summed |
| Watch Window | A window that displays the results of specified cells |
| Business Intelligence tools | Tools that can be used to perform data analysis and create sophisticated charts and reports. |
| Canvas | The area of a Power View worksheet that contains data visualizations. |
| Quick Explore | A tool that allows you to drill down through PivotTable data with a single click. |
| ROWS area | An area to position fields that you want to display as rows in the PivotTable report. Field names placed here become row titles, and the data is grouped by these row titles. |
| Slicer header | The top of a slicer that indicates the category of the slicer items. |
