Peltier Technical Services, Inc.
 


 

The Chelsea Hotel
111 South Chelsea Avenue
Atlantic City, NJ

Advanced Excel Conference

Two Days of Excel Programming and Charting with
Jon Peltier and Bob Umlas

June 17-18, 2009

On the Boardwalk in Atlantic City

This was a very successful event, but unfortunately you missed it.
Follow these links for information about upcoming training events:

Upcoming Excel Training Activities

Excel Dashboard and Visualization Bootcamp

Jon Peltier and Mike Alexander
Three Days of Intensive, Hands-on Excel Dashboarding
Frisco, TX (near Dallas)
April 27-29, 2010

Excel Dashboards and Charts

Jon Peltier and Alex Kerin
All Day Hands-On Excel Dashboarding
Westborough, MA
June 2, 2010

Contact Peltier Tech to get information on upcoming training programs, to schedule a training program at your facility, to customize a training program to meet the needs of your organization.


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

 

Contact Peltier Technical Services for more information.

Back to PTS Advanced Excel Training


 

Peltier Technical Services, Inc.

Training | Excel Chart Add-Ins | Peltier Tech Blog

Peltier Technical Services, Inc., Copyright © 2011. All rights reserved.
You may link to this article or portions of it on your site, but copying is prohibited without permission of Peltier Technical Services.