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

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