Nov 2003
Home Up Past Meetings Notes Tips Directory Links of Interest Site Map FAQs

Our Next Meeting is: Wednesday, November 12,  2003
 

6:30-7:00 pm 

General Questions and Problems from the Audience
7:00 - 8:00 Excel User Interface Tips (Beginner to Intermediate Level)

Useful Toolbars:  
   Drawing,   - Drawing shaps and connected lines.   Flow Charts
   Shapes_And_Connectors.zip   (Example workbook 7KB)

Formula Auditing   -  Find formula references easily
Protection  -  Controlling what users can and cannot change.
Customizing Toolbars

8:00-8:10 pm

 (Break)
8:10 - 9:00 Excel "Functions of the Month"

Database functions:  How to set them up.   Making calculations from a large table according to what rows fit a criteria.
DSUM - Database Sums
DAVERAGE
DMIN
DMAX

How to do an Array Function instead of a DSUM.   It is easier to setup for simple criteria.
 
HallOfFame.zip  BaseBall Hall of Fame Example Workbook

DSUMSHEET:  AutoFilter with DSUM, DAVERAGE, DCount

Sheet4:  Advanced Database Extraction.   SUBTOTAL for sum and average.

Sheet5:   Pivot Table (Teams by rows, Statistics across columns).

Macros:

Sub RefreshPitcherList()    ' An Advanced Filter
' RefreshPitcherList Macro
' Macro recorded 11/12/2003 by raseysm
Range("DataArea1").AdvancedFilter Action:=xlFilterCopy, CriteriaRange:= _
Range("Crit4"), CopyToRange:=Range("Head4"), Unique:=False
End Sub

Function smrCellColorNumber(rngCell As Range) As Long
'Return the ColorIndex of the fill of the first cell of a referenced range.

smrCellColorNumber = rngCell.Range("A1").Interior.ColorIndex
End Function
 

For questions or comments concerning content on this website: Stephen Rasey
Design of this site by Cheryl D. Wise
Copyright © 2000-2004 by WiserWays. All rights reserved.
Revised: 2005-07-10 01:08 .