Excel Essentials: Chart Techniques


Overview
In this session Excel expert David H. Ringstrom, CPA shares his favorite techniques that he uses to work with charts more effectively. David will provide detailed handouts specific to these versions of Excel:

  • Excel 2013
  • Excel 2010
  • Excel 2007
  • Excel 2003
Separate handouts are available because various features work slightly different in each version of Excel.

Objectives
  • Learn new features in Excel 2013 that simplify charts
  • Master automation techniques that streamline repetitive tasks
  • Avoid frustration by mastering nuances of charts
Emphasis
  • See the new Recommended Charts feature in Excel 2013, as other user interface changes in Excel 2013 that make managing charts far easier
  • Easily add clip-art to your charts
  • Automate charts by way of the Table feature in Excel 2007 and later
  • 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 later.
Who Should Attend:
Practitioners that create charts in Microsoft Excel, or that wish to master charts

Prerequisite
None

Preparation
No advance preparation required
 
Level of Knowledge
Intermediate
 
CPE Credit
2 Hours
 
Delivery Method  
Group Internet Based
 
NASBA Field of Study
Specialized Knowledge and Applications

Author
David H. Ringstrom