Excel 2013 Chpt 7
Field Button
A button on a PivotChart with an arrow to choose a filter, and thus change the data that is displayed in the chart.
Filtering Button
A button on a slicer which you use to select the item by which to filter.
Clear filter
A button that removes a filter
Pivot Chart Report
A graphical representation of the data in a PivotTable report.
Data Model
A method of incorporating data from multiple, related tables into an Excel worksheet.
PivotTable Fields Pane
A window that lists, at the top, all of the fields—column titles—from the source data for use in the PivotTable report and at the bottom, an area in which you can arrange the fields in the PivotTable.
PowerPivot
An Excel BI tool that allows you to analyze data from multiple sources, work with multiple data tables, and create relationships between tables.
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.
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.
Values Area
An area to 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. You can also perform other basic calculations such as finding the average, the minimum, or the maximum.
Columns 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.
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.
Relationship
An association between tables that share a common field.
Pivot Table
An interactive Excel report that summarizes and analyzes large amounts of data.
Add-In
An optional command or feature that is not immediately available; you must first install and activate an add-in to use it
Slicer
Easy-to-use filtering control with buttons that enable you to drill down through large amounts of data.
Associated PivotTable report
The PrivotTable report in a workbook that is graphically represented in pivot Chart
canvas
The area of a Power View worksheet that contains data visualizations.
Field Names
The column titles from source data that form the categories of data for a PivotTable
Refresh
The command to update a worksheet to reflect the new data
Source data
The data for a PivotTable, formatted in columns and rows, which can be located in an Excel worksheet or an external source.
Layout Section
The lower portion of the PivotTable Fields pane containing the four areas for layout; use this area to rearrange and reposition fields in the PivotTable.
Slicer Header
The top of a slicer that indicates the category of the slicer items
Field Section
The upper portion of the PivotTable Fields pane containing the fields—column titles—from your source data; use this area to add fields to and remove fields from the PivotTable.
Filter
To limit the display of data to only specific information.
Quick Explore
a tool that allows you to drill down through pivot table data with a single click.
Business Intelligence tools
tools that can be used to perform data analysis and create sophisticated charts and reports