Utilizing Excel Charts

Course details

This course teaches a practical, step-by-step approach to creating and managing charts in Excel. You learn numerous techniques that you can use immediately to build charts more efficiently and effectively. This course covers everything from the basics of creating a chart to leveraging automation and templates.

You learn how to:

• Use the Table feature in Excel 2007 and later to create charts that expand or contract automatically as your source data changes.
• Avoid repetitive formatting by using chart templates.
• Create self-updating chart titles that are linked to formulas within a worksheet cell.

We also compare user interface changes in Excel 2013 that vastly simplify chart-related tasks, and explore the new Recommended Charts feature in Excel 2013.

Using Excel 2010 to demonstrate, the instructor has also provided downloadable handouts with easy to follow numbered steps specific to these versions of Excel:

• Excel 2013
• Excel 2010
• Excel 2007
• Excel 2003