Advanced Excel Charting Techniques Class

Developed by Jon Peltier of Peltier Technical Services, the Advanced Excel Charting Techniques class is a hands-on experience, scheduled to take three to four hours. The class assumes an intermediate level of competency in Excel, and builds on this base to develop strong skills. Students work on practical examples using their own notebook computers. Class materials include presentations and workbooks, as well as a handful of helpful utilities.

Advanced Charting Techniques

• Get the Data Right
• Pick the Right Chart Type
• A Little Formatting Goes a Long Way
• Building Combination Charts
• Custom chart types
• Dummy series
• Reference lines
• Customized labels
• Creating Dynamic Charts That Expand with Your Data
• Make Your Charts Interactive
• Axis Tricks
• Advanced Formatting
• Conditional formatting in charts
• Linking chart text to cells
• Error bars
• Custom Chart Types You Didn't Think Excel Could Make
• Waterfall Charts
• Clustered-Stacked Charts
• Panel Charts
• Control Charts (Run Charts)
• Gantt Charts
• Stock Charts

Contact Peltier Technical Services

Contact Peltier Tech

• to get information on upcoming training programs,
• to schedule a training program at your facility,
• to customize a training program to meet the needs of your organization.

Peltier Technical Services, Inc.

Training | Excel Chart Add-Ins | Peltier Tech Blog

Peltier Technical Services, Inc., Copyright © 2010. All rights reserved.
You may link to this article or portions of it on your site, but copying is prohibited without permission of Peltier Technical Services.