Advanced Excel Conference 2009
April 3, 2009 • JP • No Comments • Rate This Article
• Links to this article
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.
(No Ratings Yet)
Loading ...What now?
Subscribe To The Blog
Email This Article
Follow Me On Twitter
My Facebook Page
Or just keep reading:
I'm just an average guy who writes VBA code for a living. This is my personal blog. Excel and Outlook are my thing, with a sprinkle of Access and Word here and there. Follow this space if you want to learn more about VBA. Keep Reading »
Previous Post: Export Excel Range to a Picture File, Redux
Next Post: Update to Data Filter Tool
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