[ Dec. 2001 ] [ Nov. 2001 ] [ Oct. 2001 ] [ Sept. 2001 ] [ August 2001 ] [ July 2001 ] [ June 2001 ] [ May 2001 ] [ April 2001 ] [ Mar. 2001 ] [ Feb. 2001 ] [ Jan 2001 ]
|
6:30-7:15 pm
|
Introduction: General
Questions and Problems from the Audience Puzzler:
When I use Autofilter a table, I want my totals to sum on only
the rows that pass the filter, i.e. the visible rows.
This is actually harder than you would think. A
typical SUM() will include values from the hidden
rows.
There are several work-arounds, but I know only one way to do it in
place and it requires a simple User Function. Other
solutions are welcome.
|
|
7:15-8:00 pm
|
Basic Charts: Column, Bar, Line, and
Scatter.
 |
Single series |
|
Multiple series |
|
|
8:00-8:10 pm
|
(Break) |
|
8:10-9:00 pm
|
Advanced Charting:
| Bubble Charts |
| Techniques to label your data. |
| Second Y-axis. |
|
Top of the Page
NOTE: The Excel SIG has for several years
meet on the Third Friday. On January 19, the membership decided overwhelmingly
to move the meeting night to the First Wednesday starting March 7,
2001.
|
