The Advanced Excel Charting Techniques class is a full-day, hands-on workshop. Students are assumed to be familiar with creating and formatting charts in Excel. Through examples and explanations, students will learn faster, more efficient ways to work with charts and data, and their charts and reports will be more effective at conveying their message.
- 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
- Step Charts
All classes offered by Peltier Technical Services have been developed by Jon Peltier of Peltier Tech. They assume an intermediate level of competency in Excel, and build on this base to develop strong skills. Attendees work on practical examples using their own notebook computers. Class materials include presentations and workbooks, as well as a handful of helpful utilities.
