Conference sessions on Wednesday:

9:00 - Excel solutions outside the box

Bob Umlas will go through a variety of unique ways to solve many common problems with Excel.

10:45 - Excel Monthly reporting strategies

Damon Longworth will demonstrate various strategies to increase productivity while creating monthly reports.

1:00 - Mechanics of Excel Charting

Jon Peltier will show us how to easily create charts as he explains how the charting engine works. All of this while giving us tips to make the whole process easier.

2:45 - Excel User's Guide to Access

Mike Alexander will demonstrate how to get Excel data into Access, explain joins, build basic queries, show how to enhance queries with operators, illustrate where formulas are entered, introduce group by queries and aggregate queries.

Conference sessions on Thursday:

9:00 - Excel Pivot Tables

Jon Peltier will show some of the finer techniques to create pivot tables.

10:30 - Access Advanced Queries

Mike Alexander will demonstrate the use of action queries, illustrate ways to transform data with Access functions, explore conditional queries, macros and ways to schedule queries that will run automatically.

1:00 - Excel Using Arrays in VBA

Damon Longworth will demonstrate various ways to create and use arrays in VBA.

2:45 - Excel Tips and Tricks

Bob Umlas will go through a fast paced display of tips and tricks to increase productivity with Excel.

Add-on classes on Wednesday:

8:30 - Access UserForm Tips and Tricks - Mike Alexander

Build a Custom Filter in Your Form

Creating a Basic Search Form

Add Data from Unbound Text Boxes to a Table

Creating a Splash Screen

Poor Man's Progress Bar

Create Web Page Effects with the 'On Mouse Move' Event

Adding and Removing Items between Input Boxes

Using Conditional Formatting to highlight records

1:00 - Excel User Forms - Bob Umlas

Checkboxes, Combobox, Adding new data, Automatically displaying a list, Frames, Images, Labels, Listbox, Getting selected items, Adding/Removing items, Multi-column RowSource, Multipage, Option button, RefEdit, Scrollbar, Spin button, Tab Strip, TextBox, Restricting textbox entries, Password characters, ToggleButtons, Events, Disabling the Close button, Getting information from worksheet to form & vice versa, Creating Wizards, Creating your own controls, Useful URL's,

Miscellaneous: getting info from clipboard to controls, Invisible objects shown by mouse move, Initialize event, using GetCustomListContents, setting focus, controltip, text accelerator - including for textboxes, tab order, tag, groupname, tabstop, enabled default buttons, Startup positions for forms

Add-on classes on Thursday:

8:30 - Excel Intermediate VBA - Bob Umlas

Bob Umlas will show examples of these techniques:

Range("A1").range("Data").whatever,

For i=1 to 801 step 100

   cells(i,1).range("Data").Clearcontents

Next

IsAddin

For each x in Array(…)

Debug.Assert; Debug.Print, Add Watch, Right-click in VBA, last position, set next statement, run to cursor, Using Bookmarks, Get/Set/Delete, Setting Application.Cursor =, Aware of naming ranges for XL2007, Ranges.xls, Variable scoping, Arr=Range("A1:E100") and then work with Arr Gosub, Selection.Name.name, Immediate window, Selection.offset(0,2).Select (for large discontiguous range), F5 from WS to VBA, Range name = VBA proc name & why it says module1.xyz instead of xyz, Set statement, >~5000 lines of code/module, Doevents, Ontime, Now

Events - sheet vs workbook, Erl, On Error Resume Next, w/If Err.Number<>0, Stop vs Breakpoint, Option Private Module; Sub XYZ(Optional q) to not show in macro, run, list, Commandbars("Toolbar List").enabled, Option Base 1, Option compare text, Application.Worksheetfunction…., EnableEvents,

For i=1 to 1000

   Select Case i

      Case 10,57,355

      Case 12,702,780 to 800, 977

   End

  Select 

Next

IIF

1:00 - Excel Advanced Charting Techniques - Jon Peltier

1. Intro and Review of Best Practices

2. Combination Charts

3. Dynamic Charts

4. Axis Tricks

5. User Defined Types and Templates

6. VBA to Automate Charting in Excel

7. VBA for Charting Across Applications.

8. Question and Answer

Add-on classes on Friday:

8:30 - Excel Charting with VBA  - Jon Peltier

Jon Peltier will provide examples to create charts using VBA. In addition, he will walk through ways to modify all portions of the chart with code.