Chapters 7 & 8
Field names
The column titles from source data that form the categories of data for a Pivot Table
Refresh
The command to update a worksheet to reflect the new data
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
Interval
The number of cells to include in the average.
Field button
A button on a Pivot Chart 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
Nested function
A function that is contained inside another function
Logical function
A function that tests for specific conditions.
PivotChart 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
Moving average
A sequence of averages computed from parts of a data series.
Quick Explore
A tool that allows you to drill down through PivotTable data with a single click
Integer
A whole number.
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
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 places here becomes 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 places here become row titles, and the data is grouped by these row titles
Relationship
An association between tables that share a common field
PowerPivot
An excel Bl tool that allows to to analyze data from multiple sources, work with multiple data tables, and create relationships between tables
Power View
An exel Bl tool that allows you to create and interact with multiple charts, slicers, and other data visualizations in a single sheet
PivotTable
An interactive Excel report that summarizes and analyzes large amounts of data
Slicer
Easy-To-Use filtering control with buttons that enable you to drill down through large amounts of data
Fixed expense
Expense that remains the same each month regardless of the amount of activity.
Variable expense
Expense that varies depending on the amount of sales.
NOT function
If the condition is false, true is returned.
Decision variable
In Solver, a cell in which the value will change to achieve the desired results.
Variable cell
In Solver, a cell in which the value will change to achieve the desired results.
Objective cell
In Solver, a cell that contains a formula for the results you are trying to determine.
Constraint cell
In Solver, a cell that contains a value that limits or restricts the outcome.
Constraint
In Solver, a condition or restriction that must be met.
Associated PivotTable report
The PivotTable report in a workbook that is graphically represented in a PivotChart
Source data
The data for a PivotTable, formatted in columns and rows, which can be located in an Excel worksheet or an external source
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 Pivot Table
Filter
To limit the display of data to only specific info
Transpose
To switch the data in rows and columns.
Business Intelligence tools
Tools that can be used to perform data analysis and create sophisticated charts and reports
AND function
a logical function that can be used to develop compound logical tests using up to 255 arguments
Break-even point
the point at which a company starts to make
COUNTIF function
A logical function that counts the cells that meet specific criteria in a specified range.
Forecast
A prediction of the future, often based on past performances.
Scenario
A set of values that Excel saves and can substitute automatically in your worksheet.
Scenario Manager
A what-if analysis tool that compares alternatives.
Solver
A what-if analysis tool with which you can find an
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
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.
Canvas
The area of a Power View worksheet that contains data visualizations
Syntax
The arrangement of the arguments in a function.
OR function
A logical function that can be used to develop compound logical tests using up to 255 arguments. The function returns a value of TRUE if ANY of the conditions are met.
SUMIF function
A logical function that contains one logic
Dual-axis chart
A chart that has one series plotted on a secondary axis.
