Future Mtgs
Home Up Tips Directory Links of Interest Site Map FAQs

[ Future Mtgs ] Aug 2005 ] Apr 2005 ] Mar 2005 ] Feb 2005 ] Dec 2004 ] Nov 2004 ] Oct 2004 ] Sept 2004 ] Aug 2004 ] July 2004 ] June 2004 ] May 2004 ] Apr 2004 ] Mar 2004 ] Feb 2004 ] Jan 2004 ] 2003 Meeting Index ] 2002 Meeting Index ] 2001 Meetings ] 2000 Meetings ] 1998-9 Meetings ]
Puzzlers ]

Future Meeting Dates            -        Past meetings

At the May 8, 2002 meeting, the membership decided that the second Wednesday was preferable to the first Wednesday.    We confirmed the decision via the members@excelsig.org email list.
bullet

September 8, 2004
What is common?   What exists in only one list?   Making a union of lists.
Data Input Validation.
Woody's Technique 35: Building Self-Verifying Spreadsheets.
Woody's Technique 37: Ripping through Lists.

bullet

October 13, 2004 - We will need a substitute leader for this date.

bullet

November 10, 2004

bullet

December 8, 2004

bullet

January 12, 2005

bullet

February 9, 2005

bullet

March 9, 2005

bullet

April 13, 2005

bullet

May 11, 2005

 

Topics for Future meetings 
(Mostly Excel, with some Access, Powerpoint, and Word) 
bullet

See List of User Interface Features and Functions:

bullet

User Functions - Writing your own VBA worksheet functions
    -This we will try to do in at least every other meeting.

bullet

Web Resources for Help and Assistance.

bullet

Regression Analysis: Linear, Multiple Linear, Non-linear.

bullet

Pivot Tables and Charting.

bullet

Create Hyperlinks to other cells in your workbook.

bullet

Use VBA to have Excel Store data into an Access Table.

bullet

Creating your own Addins  (I could use help with this one.)

bullet

Attaching Toolbars to Workbooks to run macros in the workbook or addins.

bullet

MS Query.

bullet

Data Transmission Service (DTS) for moving data between Excel and Access.

bullet

Template Wizard: a tool to link Excel worksheets to a Database Table.

bullet

Use VBA and DAO to automatically get an Access Query result and load into Excel

bullet

Use VBA and DAO to put get an Access Query and load some fields in the order desired into the Excel Workbook.

bullet

Secure your data

bullet

Use VBA to build charts on demand.

bullet

Star Office and Open Office - alternatives to MS Office.

bullet

Seagate Analysis - a Free tool for Database-like formated reports, OLAP, and queries.

bullet

Publishing Excel to the internet.

 

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 .