Part VII: Appendixes
940
l (^) region3.xlsx: One of three workbooks used to demonstrate data consolidation.
l source.xlsx: A workbook used to demonstrate linking (uses dependent.xlsx).
Chapter 28
l (^) webpage.xlsx: A workbook used to demonstrate HTML exporting.
Chapter 33
l budget data.accdb: A single-table Microsoft Access database file, used to demonstrate
Microsoft Query.
Chapter 34
l bank accounts.xlsx: A workbook that contains data suitable for a pivot table.
l (^) normalized data.xlsx: A workbook that demonstrates normalized data.
Chapter 35
l calculated fields and items.xlsx: A workbook that contains a pivot table that demon-
strates calculated fields and calculated items.
l county data.xlsx: A workbook that contains a large table and a pivot table created from the
table.
l employee list.xlsx: A workbook that contains a table to demonstrate the use of non-
numeric data in a pivot table.
l hourly readings.xlsx: A workbook that contains time-based information to demonstrate
grouping item by time.
l income and expense.xlsx: A workbook that contains a pivot table to demonstrate how to
reference cells within a pivot table.
l music list.xlsx: A workbook that demonstrates how to create and format a pivot table
report.
l reverse pivot.xlsm: A workbook that contains a VBA macro that converts a summary table
into a 3-column database table.
l sales by date.xlsx: A workbook that contains time-based information to demonstrate
grouping items by date.
l sales by region pivot chart.xlsx: A workbook that demonstrates how to create a pivot
chart from a pivot table.
l test scores.xlsx: A workbook that demonstrates how to use a pivot table to create a fre-
quency distribution.
Chapter 36
l direct mail.xlsx: A workbook that contains a profit model to demonstrate how to create a
2-way data table for what-if analysis.
l mortgage loan.xlsx: A workbook with input cells and formula cells to demonstrate what-if
analysis.
57_474877-bapp02.indd 94057_474877-bapp02.indd 940 3/29/10 11:47 PM3/29/10 11:47 PM