Pivot
Tables
A pivot table is
a very powerful tool which can be used to summarize numeric data in the
list based on other fields in the list. You can calculate totals,
averages, counts, min, or max based on any fields in the table. A
pivot table is different from sorting and inserting subtotals because with
subtotals, you can only have subtotals (or averages, etc.) based on one
column at a time.
Once you've created
a pivot table, you can easily rearrange the fields, add fields, or hide
or display different categories. You can even create a chart from
your pivot table.
Read pages 5.34 through
5.50 and perform the steps as indicated in the text.
Remember, row and
column fields are usually label fields. But you must always drag
a value field to the area labeled Drop Data Items Here.
Quick
Check:
Using the Faculty.xls
file, create a pivot table to find the highest salary based on rank and
department. Format the values in the table.
Save the file as
Pivot Table Your Name. Attach the file to an e-mail message with
the subject Pivot Table Quick Check. |
Assignments:
Case Problem 1,
page 5.51 - 5.52.
Case Problem 3, page
5.53 - 5.54.
These case problems
ask you to print at several steps along the way. If you come to campus
occasionally, you may wish to print and bring me your printouts.
If you do not wish
to make a trip to campus, you can accomplish the same purpose without printing.
For every instruction asking you to print, just highlight the area to be
printed, and copy the data to another sheet in the workbook. Label
the sheet as Instruction 3, or Instruction 4, etc. using the instruction
number in the case problem. Remember to include your name in the
filenames. Attach the files to an e-mail message with the subject
Tutorial 5
Assignments. |
|
