[ 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 ]
[ June 2000 ] [ July 2000 ] [ August 2000 ] [ Sept 2000 ] [ Oct 2000 ] [ Nov 2000 ] [ Dec 2000 ]
Excel and PPT.
Animating an Excel Graph using VBA. Pasting Excel into Powerpoint.
Linking Excel and Powerpoint files. Use Powerpoint VBA to copy an
Excel Graph onto a new slide.
Ways
to Summarize Data with: Outlines, Subtotals, Pivot Tables,
Views.
VBA Subroutine to Sort Sheets.
Put Hyperlinks into Excel
Copy Web Page data into Excel
Clean up Web Format for Table Use
Published Web Queries (already set up)
Setting up your own Web Queries to bring
data from a website into Excel automatically.
Exchanging Data between Excel and Access.
Loading Excel data into Access.
Create simple Access Queries and copy data
into Excel.
Much of the first hour went into depth on Autofilters and Advanced Filters
Attemped to compare Advanced Filters with MS Query (Get External Data), but we
were unsuccessful with the MS Query link to our tables. We will try
again in September
Introduced the Chart Events to itentify a selected bubble on the chart.
Introduced the means to jump to a web page using the "ActiveWorkbook.FollowHyperlink"
method.
Questions from the floor included examples of Cut, Copy and
Paste. Formula Relative and Absolute References, and a user defined
function with a multi-cell range as an argument.
Download XLS Workbook:
WiserWays Stock Bubble, Version 1.1 (Zip
Download 0.45MB, expands to 1.3MB)
Given a Spreadsheet of Stock statistics,
Use Advanced Filter to Extract Stocks of a given industry group to a
separate list.
Make a Chart of the stocks as an X,Y Scatter.
Define the Plot Series as variable Ranges using OFFSET()
from other defined ranges.
Create a "Bubble" Chart to show FOUR components of each
stock:
Add a list box on the chart to Highlight one selected point out of
many.
June 2000 (Notes:)
May 2000
April 2000 Lookups: VLookup, HLookup, Lookup,
Match, and Index
(Zip 23KB) Word 97 notes and Excel 97 Example.
March 2000 Tables: consolidating, filtering, and
subtotaling.
(Zip 9 KB)
February 2000: Workbook design: Steve
Rasey's presentation - and a lot more!
(Zip 23 KB)
Top of the Page
