|
 PLEASE NOTE: These notes are taken
from Microsoft Excel 97 Help files, and include many of Excel's new
features. Look for additional information in Excel Help: select Key
Information, then click on If you are upgrading from a previous
version of Excel.
PivotTable dynamic views can pull together large amounts of data in
crisp summaries -- and new features make them even easier to
tailor to your needs.
| Feature
|
Description
|
| PivotTables
|
PivotTables are interactive tables that quickly
summarize large amounts of data. PivotTables replace Microsoft
Excel version 4.0 crosstab tables. You can easily convert a
crosstab table to a PivotTable.
|
| PivotTable Wizard
|
You can use the PivotTable Wizard to cross-tabulate
and summarize data from an existing list or table or an
external database and then rearrange and instantly calculate
the result. The Office Assistant provides help for each step,
making the wizard even easier to use.
|
| PivotTable selection
|
You can select parts of the PivotTable structure,
such as all occurrences of a particular item in a field, that
you want to format or use in formulas.
|
| Page fields that retrieve
data one item at a time
|
When you work with large external databases, you
can query the database for each item in a page field as you
display it, so that your PivotTables can gain access to much
larger amounts of data.
|
| Automatic sorting
|
You can sort items in a PivotTable automatically
and keep the sort order when you refresh the PivotTable or
change its layout.
|
| Automatic display of top
or bottom items
|
You can show the top or bottom items for a field
and set the number of top or bottom items you want to display.
|
| Dates stored as numbers
in PivotTables
|
Sorting and formatting dates in PivotTables now
works the same as on the rest of a worksheet.
|
| Feature
|
Description
|
| PivotTable options
|
You can set options that affect the entire
PivotTable in a separate PivotTable Options dialog box. This
dialog box is available both from the PivotTable Wizard and in
finished PivotTables.
|
| "Persistent" formatting
|
When you use PivotTable selection, you can apply
formatting and autoformats to PivotTables, so that your
formatting is retained when you refresh a PivotTable or change
its layout.
|
| Background queries
|
You can run a query to get PivotTable data from an
external database in the background, so that you can continue
working in Microsoft Excel while the data is being retrieved.
|
| Merged labels
|
You can use merged cells automatically for outer
row and column fields in PivotTables.
|
| Page field layout
|
If you use many page fields in a PivotTable, you
can fit more page fields on the screen by displaying the page
fields down rows or across columns.
|
| Options for error values
and empty cells |
You can display a value you choose, including a
blank cell, instead of the default error displays, such as
#REF and #NAME, or displaying a 0 (zero) for empty cells.
|
| Memory optimization
|
You can optimize memory for fields that have fewer
than 256 items, so that smaller PivotTables use much less memory.
|
| Feature
|
Description
|
| Calculated fields
and items
|
You can create fields and items within fields that
calculate your own formulas on data from the PivotTable.
|
| List the formulas in a
PivotTable
|
You can display a list of the formulas you used for
your calculated fields and items.
|
| Change the calculation
order
|
When you create more than one formula for a
calculated item, you can specify which calculated item formulas
take precedence over other formulas.
|
| References to PivotTable
data in formulas
|
The GETPIVOTDATA worksheet function lets your
formulas outside of PivotTables perform calculations that use
the data in PivotTables.
|
Want to use PivotTable summary data in a formula? Need to know how
many blank cells are in a range? New and updated functions in Microsoft
Excel can help you out.
| Function
|
Description
|
| AVERAGEA
|
Returns the average of the values in a range of
cells. Unlike the AVERAGE function, AVERAGEA includes in its
calculation cells that contain text and the values TRUE and
FALSE.
|
| GETPIVOTDATA
|
Retrieves data from a PivotTable.
|
| COUNTBLANK
|
Counts the number of blank cells in a range of
cells.
|
| COUNTIF
|
Counts the number of cells in a range that meet a
specific condition or criteria.
|
| HLOOKUP
|
Finds an exact match when you set a new argument,
range_lookup, to FALSE.
|
| HYPERLINK
|
Creates a shortcut or jump that opens a document
stored on a network server, an intranet, or the Internet.
|
| MAXA
|
Returns the largest value in a range of cells.
Unlike the MAX worksheet function, MAXA includes in its
calculation cells that contain text and the values TRUE
and FALSE.
|
| MINA
|
Returns the minimum value in a range of cells.
Unlike the MIN worksheet function, MINA includes in its
calculation cells that contain text and the values TRUE
and FALSE.
|
| STDEVA
|
Estimates standard deviation based on a sample of a
population. Unlike the STDEV worksheet function, STDEVA
includes in its calculation cells that contain text and the
values TRUE and FALSE.
|
| STDEVPA
|
Calculates standard deviation based on an entire
population. Unlike the STDEVP worksheet function, STDEVPA
includes in its calculation cells that contain text and the
values TRUE and FALSE.
|
| SUMIF
|
Adds or sums the values in a range of cells that
meet a specific condition or criteria.
|
| VARA
|
Estimates the variance of a sample of a population.
Unlike the VAR worksheet function, VARA includes in its
calculation cells that contain text and the values TRUE and
FALSE.
|
| VARPA
|
Calculates the variance based on the entire
population. Unlike the VARP worksheet function, VARPA includes
in its calculation cells that contain text and the values TRUE
and FALSE.
|
| VLOOKUP
|
Finds an exact match when you set a new argument,
range_lookup, to FALSE.
|
 New in Excel 97, Page 2
|
MS Office Contents
|
Home
|
New in Excel 97, Page 4
|
|