|
Our Next Excel Meeting is:
Wednesday, October 13, 2004
News,Tips and Puzzlers: Revised: 12-Oct-2004 and
Tips of the Month
Info on
Office 2003 Service Patch 1 -
Information, Links, and Opinions (Revised 1-Sept)
Windows XP Service
Pack 2 - the major security upgrade (Revised 1-Sept.)
"Blue
Screen of Death"
seen
on many of Intel's newest systems.
| 6:30-7:00 pm |
General Questions and Problems from the Audience |
| 7:00 -
8:00 |
Comparing two Lists in Excel
What is common? What exists in only one
list?
Making a union of lists.Stephen
Rasey will be at the meeting.
SIG member Lawrence Rosenberg has agreed to help lead the SIG in
October. |
| 8:00 |
Break |
8:10
at 9:00 |
Data Input Validation.
If time permits:
Woody's Technique 35: Building Self-Verifying Spreadsheets.
Woody's
Technique 37: Ripping through Lists.
|
• •
News, Tips, and Puzzlers:
- 26-Sept
- Excel VBA: How to
retrieve the Range Name of the Active Cell?
- 20-Sept
- Patrick O'Beirne, Systems Modelling Ltd.
http://www.sysmod.com/
(From Excel-L)
- 14-Sept
- Spreadsheet Modeling Best
Practices: Read, Baston, Business Dynamics: April 1999. 102
p. PDF
Access: How to put the current record at the top of a continuous
form?
- 11-Sept
- See Spotfire Hurricane Tracks
for Hurricane Ivan at http://stephenrasey.com
- 9-Sept
- Rasey's Spotfire Hurricane Tracks as it applies to
Hurricane Ivan as of 20040908
Case Study the WiserWays Spotfire Hurricane Historical Tracker. It
was to predict whether 2002 Hurricane Lili was a danger to Houston.
Total time to prepare the data, database and Spotfire Application: 4
hours.
See October 2002 meeting for other notes.
- 8-Sept
- Sept 8 SIG Notes and Agenda
- 7-Sept
- Bob Umlas, Excel MVP, is leading a FREE 1-hour seminar on the web on
Excel tips & tricks.
Tuesday, 9/21, from 3-4PM est. To sign up, go to
http://www.iil.com, click on the orange
box on the left side saying "try a free webinar", then click "Microsoft
Excel 'Tips and Tricks'" then click the link to sign up.
(From the
Excel-L Developers mail list).
- 5-Sept
- For the Sept 8 meeting: Notes on
Combining the Signals recorded in web Query workbook with Historical Prices
from Yahoo.
Excel Bug:
You cannot change the Pivot Chart Data series colors and have them stay.
- 3-Sept
- MSDN:
How to Install Visual Studio Tools for the Microsoft Office System
BLOG: Peter Tor (MS) - Office
Development, Security, and Randomness.
http://weblogs.asp.net/ptorr/
(found on ms.public.vsnet.vstools.office 3-Sep-04)
PowerPoint:
epic software group,
inc. Ten Steps to Producing a Successful Multimedia CD-ROM
Presentation.
- 1-Sept
- More notes on
Digital Certificates
Woody's
Office Watch on Office 2003 Upgrade: upgrade Win XP SP2 first.
Wait a few weeks for Office 2003 SP1 upgra
|
