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:
- Excel Dashboard Training
- Second Excel Dashboard Boot Camp – May 2009
- Excel Dashboard and Visualization Bootcamp 2011
- Advanced Excel Conference, June 2009
- Interesting Links for 3-April-2009
- Interesting Links for 24 April 2009
Posted: Monday, March 29th, 2010 under Conferences.
Comments: 4
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.