Excel Dashboard and Visualization Boot Camp – April 2010
by Jon Peltier
Friday, January 22nd, 2010
Peltier Technical Services, Inc., Copyright © 2010.
Licensed under a Creative Commons Attribution-Noncommercial-Share Alike 3.0 Unported License.
Microsoft MVPs Jon Peltier (Peltier Technical Services) and Mike Alexander (DataPig Technologies) are joining together to host our third Excel Dashboard and Visualization Boot Camp! The last two events were hugely successful, and we can’t wait to do it again.
The conference will be held on Tuesday through Thursday, April 27-29, 2010, in Frisco, Texas (just north of Dallas).
This 3-day boot camp is designed for Excel users who need to more effectively synthesize data into meaningful dashboards, charts, and visualizations. The topics presented during this boot camp will introduce you to advanced techniques that will help you build and manage better reporting mechanisms. Going beyond simple tables and charts, you will learn to:
- Synthesize data in meaningful views with advanced charting techniques
- Create dashboards that communicate and get noticed
- Create interactive dashboarding mechanisms
- Implement macro-charged reporting
- Automate the creation of PowerPoint slides directly from Excel
- Integrate external data into your reports
The boot camp will follow this three day agenda, with each day comprising two in-depth classes:
Day 1: Visualization Best Practices
- Tips for Building Excel Dashboards
Mike Alexander - Advanced Charting Techniques
Jon Peltier
Day 2: Building Report Interactivity
- Building Interactive Reporting
Mike Alexander - Automating Excel Charting with VBA
Jon Peltier
Day 3: Integration Techniques
- Integrating Excel and PowerPoint
Jon Peltier - Using External Data in Excel Reporting
Mike Alexander
For information and registration, visit the link below:
Excel Dashboard and Visualization Boot Camp
Jon Peltier and Mike Alexander
Tuesday through Thursday, April 27-29, 2010
Frisco, TX
If you have specific questions, contact Mike Alexander.
The classes I will be teaching are described in more detail on the PTS Advanced Excel Training Classes page.
Related Posts:
- Upcoming Excel Training Sessions
- Interesting Links for 24 April 2009
- Interesting Links for 3-April-2009
- Advanced Excel Conference, June 2009
- Mike Alexander’s Favorite Chart Labeling Tricks (Guest Post)
- PTS Charting Classes
- Excel Dashboard Training
- Dashboarding and Charting Training
- Miscellaneous Notes for 11 June 2009
- It’s Friday!
Posted: Friday, January 22nd, 2010 under Conferences.
Comments: 4
Comments
Comment from Carmine Di Benedetto
Time: Friday, January 22, 2010, 1:36 pm
Hi John,
I work as a research analyst for a SaaS company and I produce a lot of quadrant charts. As I’m sure you know, you cannot add leader lines to connect labels to points for quadrant charts in Excel 2007. As far as I know, Excel only allows you to add leader lines to pie charts. Do you have a utility that would enable me to add these leader lines to the quadrant charts?
Thanks for taking the time to read my message.
Carmine Di Benedetto
Comment from Jon Peltier
Time: Friday, January 22, 2010, 2:55 pm
Carmine -
You can use error bars to simulate vertical or horizontal leader lines (see Callout Labels with Error Bars), or 2-point XY series (line and no marker) for any generic lines (see Callout Labels with XY Line Segments).
Comment from Carmine
Time: Friday, January 22, 2010, 3:41 pm
Thanks for the swift reply John. The problem is that I need to be able to grab the labels and have the leader lines follow the label no matter where I place them on the chart. Just like the way the labels follow the leader lines with the pie charts. The way you suggested would not allow me to do this.
Thanks
Comment from Jon Peltier
Time: Monday, January 25, 2010, 1:44 pm
That can be done with a lot of complicated code, but it’s way beyond a comment in a blog post. It’s way beyond a blog post itself.
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.