The Advanced Excel Conference June 2009 will be held in June 2009 at the Chelsea Hotel in Atlantic City, New Jersey. This year, it will be hosted by Excel MVPs Jon Peltier and Bob Umlas.
111 South Chelsea Avenue
Atlantic City, NJ
1-800-548-3030
Keep reading for a breakdown of each day's activities.
Wednesday, June 17
Morning Session – Intermediate VBA
Bob Umlas
- The myriad ways of working with the Range object
- Loops
- Select Case, If-Then-Else
- Object variables
- Using the VBE
- Events
- Error handling
- Shortcuts
- …and much more
Afternoon Session – Advanced Excel Charting
Jon Peltier
- Get the Data Right
- Building Combination Charts
- Making a Dynamic Chart that Expands with your Data
- Conditional Formatting a Chart
- Waterfall Charts Explained
- Creating Gantt Charts in Excel
- Linking Chart Text to Cells
- Clustered-Stacked Column Charts
- Creating Process Control Charts
- Show Multiple Series in Panel Charts
Thursday, June 18
Morning Session – Using Excel and PowerPoint Together
Jon Peltier
- Manually Putting Excel Charts and Tables into PowerPoint
- Linking PowerPoint to the Excel Source
- Copying Charts as Images
- Using VBA to Paste from Excel into PowerPoint
- Positioning and Sizing Charts when Pasting Them
- Use an Excel Table to Manage an Entire Presentation
Afternoon Session – VBA UserForms
Bob Umlas
- Designing and Displaying Basic Forms
- Initializing data in the form before showing it
- Getting information from the Worksheet to the Form and Back
- Creating Wizards
- Using Buttons, Checkboxes, Listboxes, Labels, Multipage forms, Comboboxes, Images, Events, Scrollbars, Spinners, Option Buttons, and more
- Enabling, Disabling, Making things visible/invisible, Progress bars
Lunch and midsession coffee breaks will be provided on both days.
Conference Fees
- One Day Only:
- $300 ($275 before midnight on May 24)
- Both Days:
- $550 ($525 before midnight on May 24)
To register, visit Jon Peltier's conference page for details.
Here's Jon's recap from last years' sessions: Excel User Conference Recap. In My Excel User Conference Experience I wrote my own review of last year's conference.
About JP
2 Comments:
For those of us that can not attend this conference, will the conference notes/information be published and made available?
LaMar Goates
Boise, ID
No idea, but I doubt it. You might consider attending some of the other boot camps that are closer to your area:
Excel and Access Integration Workshop
Excel Dashboard and Visualization Bootcamp