HAL-PC Office and Excel SIG, Houston, Texas

HAL-PC MS Office & Excel SIG in Houston, Texas - Home Page

Web Site Sponsored by WiserWays, LLC

2004-2005 SIG Leader: Stephen Rasey

HAL-PC's Excel SIG meetings and website are free sources of help for you to use Excel and other Microsoft Office Applications in business and at home. In the SIG meeting, We concentrate on Excel and VBA, but we also work with Access and PowerPoint. We use Excel 2003 in the SIG. We also help with Excel XP, Excel 2000 and Excel 97.

	Meeting Time: Second Wednesday of the Month at 6:30 pm to 9:00 pm.
	Meeting Place: At the HAL-PC Headquarters, Houston, Texas. (see Map))
	WHAT do we do? Frequently Asked Questions You do not need to be a member of HAL-PC to attend. If you like to attend regularly, please apply for a HAL-PC membership.

The meeting for July 13, 2005 is Cancelled.
Stephen Rasey is out of town.

Our Next Excel Meeting is: Wednesday, August 10, 2005
The following meeting is Wednesday, September 14, 2005
News,Tips and Puzzlers: Revised: 15-Feb-2005 and Tips of the Month

6:30 - 8:00	Build a Mail Merge application that sends account delinquency letters to clients with past Due more than 30 days. Elements: Load Client Addresses into Excel from a Tab Delimited File Have Client Balance Aging table showing age of amount due Pivot Table showing Balance due by Age. Create a query to summarize Balance Due by age Range Create a query identifying Clients needing a letter and amount due Create a query joining amount due with addresses. Link MS Word to the final query for a mail merge. This meeting will use Excel, Access, and Word.
	Break
8:10 at 9:00	Continuation. Problems from the Floor.

Files from May Meeting Uploaded: Create an Excel Workbook that will automatically query an Access Database

PastMtgs/0508/DBqry.zip 3.1 MB (Includes a 9 MB compressed Access Database that the Excel Workbook queries.

News, Tips, and Puzzlers:

Top of the Page

Home • Past Meetings Notes • Tips Directory • Links of Interest • Site Map • FAQs