[ Nov 2003 ] [ Oct 2003 ] [ Sept 2003 ] [ Aug 2003 ] [ July 2003 ] [ June 2003 ] [ June 2003 ] [ Apr 2003 ] [ Mar 2003 ] [ Feb 2003 ] [ Jan 2003 ]
Dec 2003 - Cancelled (Leader conflicts)
- Nov. 11, 2003 -
Shapes Toolbar. Filtering. VBA User Defined
Function.
- Shapes_And_Connectors.zip
-
-
HallOfFame.zip
BaseBall Hall of Fame Example Workbook
-
AutoFilter with DSUM, DAVERAGE, DCount
-
Advanced Database Extraction. SUBTOTAL
for sum and average.
-
Pivot Table (Teams by rows, Statistics across
columns).
-
Sub RefreshPitcherList() '
An Advanced Filter
-
Function smrCellColorNumber(rngCell As Range)
As Long
-
Testing for errors. ISERROR()
Conditional Formatting.
Tracing Errors. Highlighting errors.
Numbers as Text.
Broken Links: #REF!
Circular References
ISNUMBER(), AND(), NOT(), SUM() and COUNT(), COUNTA()
Average with SUBTotal() on Filtered Rows, Contitional Formatting for
highlighting errors.
Sept 10, 2003 - Cancelled
(Leader conflicts)
Aug 13,
2003 - MATCH, INDEX, LARGE functions. It
also shows a Pivot Table and a Pivot Chart. Compare
July 9, 2003 -
Elections, Data Validation. Problem from the
floor: Trapping Errors in Macros.
June 11, 2003 - Grouped and Sorted Lists
May 14, 2003
April 9, 2003 - Essential VBA to Have Excel save
results to an Access Database.
March 12, 2003 - You can use
EXCEL instead of ACCESS for small relational databases
February 12, 2003 - Saving your Work, Results,
and Conclusions. Make a Snapshot.
