Conference Sessions Intermediate

Add-On Classes Advanced

10:30am

Conference Sessions Advanced

Add-On Classes Intermediate

10:30am

Conference Sessions None Scheduled

Add-On Classes Advanced

10:30am

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 - What's New in Excel 2007

Bob Umlas will highlight some of the new features added to Excel 2007.

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 - Changes to Charting in Excel 2007

Bernard Liengme will introduce such concepts as Ribbon, groups, commands, Quick Access Toolbar, themes, styles, and galleries.

Conference sessions on Thursday:

9:00 - Pivot Tables

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

10:30 - What's New in Access 2007

Andy Baron illustrate the new features in Access 2007, while comparing the new version with past versions.

1:00 - 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 - Excel for Engineers & Scientists - Bernard Liengme

This session is for those who use Excel for work in any technical field including support staff. You do not need to be an Einstein or an Edison, just someone who liked (or, at least, was competent at) high school math.

We will work with Excel 2003. Various topics will be explored: getting true exponents (such as 2.5 × 10-6) on chart axes; engineering notation (exponents that are multiples of 3); have LINEST fit polynomials; using the matrix functions to solve systems of equations (structural analysis, analysis of electric circuits, etc); using Solver to fit data to functions more complex than Add Trendline allows; modelling; finding the area under a curve (aka numerical integration); user-defined functions ...

The presenter will have a range of topics to talk about but will involve the audience in the final selection. Bring questions, bring Excel files and bring your laptop if you want to be interactive. A CD with sample files and an e-book copy of the author’s A Guide to Microsoft Excel for Scientist and Engineers will be distributed.

1:00 - 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 - Intermediate VBA

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 - Advanced Charting Techniques

Jon Peltier will use this outline:

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 - Charting with VBA

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.