PivotTable

Power Pivot

A built-in add-in program that enables users to create a PivotTable from multiple related tables

what field is a user defined field?

Calculated Field

data mining

The process of analyzing large volumes of data to identify patterns and trends

Do Excels automatically update Pivot Tables?

No

Can you change data in a PivotTable?

No, you must edit the excel table and the refresh

Pivot summarizes data using what points?

SUM, COUNT, AVERAGE, MIN, MAX, PRODUCT, COUNT NUMBERS, STDEV,STDEVP, VAR & VARP

What filters data in a Pivot Table

Slicers

what does a pivot table allow you to do?

to summarize, analyze, and explore large amounts of data

Are Pivot Charts interactive?

yes, , meaning changes made in the associated PivotTable are immediately reflected in the PivotChart

outline

a hierarchical structure of data

structured reference

a tag or table name that replaces a cell name

Group filter

filters out data based on a row or column category

what is data mining

* a process *analyzes large volumes of data *identifies trends and patterns

What is a slicer

A window listing all items in a field and enabling efficient filtering

columns area

Drag fields here to add more vertical data to a PivotTable

Rows area

Drag fields here to display categories horizontally in a PivotTable

what is a report filter

allows you to filter the PivotTable to display summarized data for one or more field items or all field items in the Report Filter area

PivotTable

an interactive table that enables you to group and summarize either a range of data or an Excel table into a concise, tabular format for easier reporting and analysis

What process do PivotTables support?

data mining

what does filtering a field allow you to do?

focus on the subset items in that field.

Report filter

sets the overall conditions for aggregating data