Excel Charts Speed Tips (Currently Unavailable)

Author: David H. Ringstrom

In this session Excel expert David H. Ringstrom, CPA shares numerous techniques that you can use to work with charts more efficiently.

David will provide detailed handouts specific to these versions of Excel:

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

Publication Date: August 2014

Designed For
Practitioners who may benefit from using Excel more effectively.

Topics Covered

• See the new Recommended Charts feature in Excel 2013, as well as user interface changes in Excel 2013 that make managing charts far easier
• Enliven your charts with clip art
• Use the Table feature in Excel 2007 and later to create charts that expand or contract automatically as your source data changes
• Create self-updating chart titles that are linked to formulas within a worksheet cell
• Master the versatile SUMIF function.
• Quickly summarize complex data sets with Excel's Pivot Chart feature
• Discover the Sparklines feature in Excel 2010 and 2013, and how to replicate it in Excel 2007 and earlier.

Learning Objectives

• Recognize the new features in Excel 2013, such as recommended charts, and user interface changes
• Identify the use of the Table feature and INDEX/COUNTIF functions to create self-maintaining charts

Level
Intermediate

Instructional Method
Self-Study

NASBA Field of Study
Specialized Knowledge and Applications (2 hours)

Program Prerequisites
A basic knowledge of Excel.

Advance Preparation
None