Peltier Tech Blog

Excel Chart Add-Ins | Training | Charts and Tutorials | Peltier Tech Blog

 

Main menu:

Peltier Tech Chart Utilities for Excel Peltier Tech Panel Chart Utility Peltier Tech Waterfall Chart Utility Peltier Tech Cluster-Stack Chart Utility Peltier Tech Box and Whisker Chart Utility Peltier Tech Marimekko Chart Utility Peltier Tech Dot Plot Utility Peltier Tech Cascade Chart Utility

 
Excel Dashboards
 

 
Amazon Books
 

Subscribe

Site search

Subscribe

Site search


Recent Posts

Popular Posts

Categories


 

Privacy Policy

Creative Commons License
Licensed under a Creative Commons Attribution-Noncommercial-Share Alike 3.0 Unported License.

Dashboarding and Charting Training

 
by Jon Peltier
Monday, March 29th, 2010
Peltier Technical Services, Inc., Copyright © 2012.
Licensed under a Creative Commons Attribution-Noncommercial-Share Alike 3.0 Unported License.

Alex Kerin of Data Driven Consulting and Jon Peltier of Peltier Technical Services are teaming up to present a day-long training session on Excel Charting and Dashboarding. This training will take place on Wednesday, June 2, 2010, at the DoubleTree Hotel in Westborough, MA, in the Route 495 corridor near the Mass Pike.

The training balances Jon’s highly technical expertise in Excel charting with Alex’s extensive experience in data driven business dashboarding.

Tuition for the all-day, hands-on program is $300, with discounts for early registration. This fee includes meals and breaks during the day plus all course materials. Participants need to bring their own laptops.

For more details, or to register for the class, visit the Excel Charting and Dashboarding home page.

Program Outline

Morning Session

Dashboards 1 – Alex

  • Introduction
  • Data Quality
  • Dashboard Design
  • Dashboard Elements

Advanced Excel Charting 1 – Jon

  • Appropriate Chart Data
  • Chart Types
  • Formatting
  • Combination Charts
  • Dynamic and Interactive Charts

Afternoon Session

Advanced Excel Charting 2 – Jon

  • Conditional Chart Formatting
  • Error Bars
  • Custom Chart Types You Didn’t Think Excel Could Make

Dashboards 2 – Alex

  • Excel as a Dashboard Platform
  • Dealing with Excel Versions
  • Sparkline Add-ins
  • Wrap Up

Program Details

Wednesday, June 2, 2010
8 am to 5 pm

DoubleTree Hotel
5400 Computer Drive
Westborough, MA 01581

Tuition includes conference materials, food, beverages
– $300 base price
– $250 before April 15
– $275 before May 8

Related Posts:

Learn how to create Excel dashboards.

Comments


Comment from Matt Healy
Time: Monday, March 29, 2010, 7:28 am

I notice the course description page says “Wednesday, June 2, 2009″ Don’t you mean “Wednesday, June 2, 2010″?


Comment from Jon Peltier
Time: Monday, March 29, 2010, 8:13 am

Matt – Doh!! Of course I mean 2010. I usually stop making this error by February of the new year.


Comment from Anonymous
Time: Friday, April 9, 2010, 11:04 am

I know this is a little off topic but I was wondering how you can move a chart object in a separate tab to another sheet and still make the vba code work. In my example, the vba code is for a mouseover event. Thank you for your time.

Robert


Comment from Jon Peltier
Time: Friday, April 9, 2010, 11:14 am

Robert -

You have to use the class module approach to enable events for the embedded chart.

This example shows how to use chart events in a chart sheet:
Chart Event to Highlight a Series

This example shows the class module approach to do the same for an embedded chart:
Chart Event Class Module to Highlight a Series

Write a comment

I welcome comments from my readers. If you have an opinion on this post, if you have a question or if there is anything to add, I want to hear from you. Whether you agree or disagree, please join the discussion.

If you want to include an image in your comment, post it on your own site or on one of the many free image sharing sites, and include a link in your comment. I'll download your image and insert the necessary html to display the image inline.

Read the PTS Blog Comment Policy.





Subscribe without commenting

Peltier Tech Chart Utilities for Excel Peltier Tech Waterfall Chart Utility Peltier Tech Box and Whisker Chart Utility Peltier Tech Cluster-Stack Chart Utility Peltier Tech Panel Chart Utility Peltier Tech Marimekko Chart Utility Peltier Tech Dot Plot Utility Peltier Tech Cascade Chart Utility

Create Excel dashboards quickly with Plug-N-Play reports.