Excel Dashboard and Visualization Bootcamp

Frisco, Tx
Wednesday, October 22, 2008


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

Inverting Negative Data Points

Using Macro to Create and Format a Charts Automatically

Using Access data in Excel

Building XY Combination Charts

Understanding the VB Editor

Introduction to MS Query

Waterfall Charts Explained

Tweaking Recorded Macros

How to Exceed Excel’s Row Limits

Creating Gantt Charts in Excel

Debugging and Error Proofing

Passing Parameters to MS Query

Linking Chart Text to Cells

Using  a Dialog to Notify User

Creating Automated Reporting

Creating  Clustered-Stacked Column Charts

Let User Select Chart Data and Chart Position

Creating Run Charts and Moving Average Charts

Let User Select Chart Options from a Custom Dialog

Tips for Charting Seasonal Data

Modular (Reusable) Procedures

Make a Chart that Expands with your Data

Conditional Formatting in a Chart

Show Multiple Data in a Panel Charts

Share Excel Charts with PowerPoint and Word

 

Contact Information

  • Phone: 214-578-2141
    Email: mha105@yahoo.com

Payment Instructions

  • Register with Credit Card
    Click the Register Now button above

    Invoice or PO
    If your organization requires an invoice or purchase order,
    contact us
    . 
    Be sure to include your contact information.

    Register with Check
    To Register with Check or Money Order, make payable to DataPig Technologies.

    Mail to:
    DataPig Technologies
    7548 Preston Rd #141-136
    Frisco, TX  75034

    *Be sure to include your email address so that we may contact you with registration information

© 2019
Quick, easy and affordable online event registration and event management software for all event sizes.