|
Day 1:
Best Practices and Techniques
|
Day 2:
Building Interactivity
|
Day 3:
Integration
|
|
7:30 - 8:00
Breakfast served on location
|
7:30 - 8:00
Breakfast served on location
|
7:30 - 8:00
Breakfast served on location
|
|
8:00 - 12:00
Tips for Building Excel Dashboards
Mike Alexander
|
8:00 - 12:00
Building Interactive Reporting
Mike Alexander
|
8:00 - 12:00
Integrating Excel and PowerPoint
Jon Peltier
|
|
Preparing for a Dashboard Project
|
Data Modeling Tips
|
Manually Put Excel Charts and Tables into PowerPoint
|
|
Effective Data Modeling
|
Understanding Form Controls
|
Linking PowerPoint to the Excel Source
|
|
Data Modeling Tips
|
Giving your Audience a Menu
|
Copying Charts as Images
|
|
Dynamic Labeling
|
Dynamically Switching Views without VBA
|
Use VBA to Paste from Excel into PowerPoint
|
|
Chart Design Principles
|
Leveraging Pivot Tables for Dynamic Reporting
|
Position and Size Charts when Pasting Them
|
|
Trending Components
|
|
Make Multiple Slides from Multiple Charts or Tables
|
|
Grouping Components
|
|
Use an Excel Table to Manage an Entire Presentation
|
|
Performance Components
|
|
|
|
12:00 - 1:00
Lunch Buffet served on location
|
12:00 - 1:00
Lunch Buffet served on location
|
12:00 - 1:00
Lunch Buffet served on location
|
|
1:00 – 5:00
Advanced Charting Techniques
Jon Peltier
|
1:00 – 5:00
Automating Excel Charting with VBA
Jon Peltier
|
1:00 – 5:00
Using External Data in Excel
Reporting
Mike Alexander
|
|
Get the Data Right
|
Record Macros to Create and Format Charts Automatically
|
Using Server/Database data in Excel
|
|
Building Combination Charts
|
Understanding the VB Editor
|
Introduction to MS Query
|
|
Make a Dynamic Chart that Expands with your Data
|
Tweaking Recorded Macros
|
How to Exceed Excel’s Row Limits
|
|
Conditional Formatting in a Chart
|
Improving your Programming Technique
|
Passing Parameters from Excel to your Database through MS Query
|
|
Waterfall Charts Explained
|
Debugging and Error Proofing
|
Creating Automated Reporting Mechanisms
|
|
Creating Gantt Charts in Excel
|
Using a Dialog to Interact with Users
|
|
|
Linking Chart Text to Cells
|
Let User Select Chart Data and Chart Position
|
|
|
Creating Clustered-Stacked Column Charts
|
Let User Select Chart Options from a Custom Dialog
|
|
|
Creating Run Charts and Moving Average Charts
|
Modular (Reusable) Procedures
|
|
|
Show Multiple Data in a Panel Charts
|
|
|