|
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
|
