[ Dec. 2001 ] [ Nov. 2001 ] [ Oct. 2001 ] [ Sept. 2001 ] [ August 2001 ] [ July 2001 ] [ June 2001 ] [ May 2001 ] [ April 2001 ] [ Mar. 2001 ] [ Feb. 2001 ] [ Jan 2001 ]
[ 2nd Wednesday ] [ Sig Days ]
|
6:30-7:00 pm
|
Introduction: General
Questions and Problems from the Audience
Puzzler: I have a list of 200 integers that vary
randomly from 1 to 100. How do I determine how many UNIQUE
numbers are in that list?
From Excel-L
ListServe December week 4. This one is fun because
there are lots of solutions.
|
|
7:00-8:00 pm
|
Effective Excel Formatting
 |
Format Toolbar |
| Customizing a Format Toolbar for
you |
| Custom Number
Formats i.e.
"[>10][Green]0.00;[<-5][red]-0.00;[yellow]0.0;"<TEXT!>" |
|
Color and Shading |
|
Styles - Making formats standard
across a workbook |
|
|
8:00-8:10 pm
|
We asked the question
of the attendees: Should we move to First Wednesday or retain
Third Friday. Overwhelmingly the vote was to Move to 1st
Wednesday. (Starting in March). |
|
8:10-9:00 pm
|
Effective Excel Formatting
|
Conditional Formating: Changing Background, Font, Size, Borders based
upon value of the cell or values of other cells |
|
Page Layout |
|
Formatting with VBA |
|
Zipped Files
Top of the Page
|
