|
Wednesday,
April 14, 2004
NOTE: we had our March
meeting on March 3, the first Wednesday, because the leader would be out of town
on the regular meeting date.
Because of the schedule change and late notice (my fault. I am sorry.), the
March 3 meeting was small. We shall repeat the subject for April 14.
Pivot Tables are very useful.
6:30-7:00 pm
|
General Questions and Problems from the Audience
|
| 7:00 -
8:30 |
Pivot
Tables: Read data from Excel tables and Access queries.
Summarize and Arrange data data in Pivot Tables,
Display data with Pivot Charts
Formatting tricks for Pivot Tables. The Example workbook
Pivot-H1qry-short.zip is a
small piece of a 20,000 row data query of risked cashflows.
The Projects are named after baseball players. Line Items
and Years are in rows. We use Pivot Tables to filter
and re-orient the data. |
| |
(Break) |
| 8:30 - 9:00 |
Excel
Aggravations What are the things that drive you crazy with Excel?
Are there better ways? |
------------------------
|
