You’ll learn an array of techniques and time-saving tricks during this live presentation by Excel expert David Ringstrom, CPA. He discusses several invaluable Excel charting features, including the Recommended Charts feature, the Slicer feature, the Sparkline feature, the PivotChart feature, and others. David also explains how to avoid repetitive formatting, create self-updating chart titles, and enliven your charts with clip art.

David demonstrates every technique at least twice: first, on a PowerPoint slide with numbered steps, and second, in Excel 2016. He’ll draw to your attention any differences in Excel 2013, 2010, or 2007 during the presentation as well as in his detailed handouts. David also provides an Excel workbook that includes most of the examples he uses during the webcast. 

Topics Typically Covered:

• Seeing how the Sparkline feature empowers you to create tiny, in-cell charts for showing trends of data.
  
• Exploring the Recommended Charts feature in Excel 2013 and later.
  
• Learning to avoid repetitive formatting by using chart templates and determining where this feature was relocated in Excel 2013 and later.
  
• Comparing user interface changes in Excel 2013 and 2016 that have vastly simplified chart-related tasks.
  
• Using the Table feature in Excel 2007 and later to create charts that expand or contract automatically as your source data changes.
  
• Creating self-updating chart titles that are linked to formulas within a worksheet cell.
  
• Using the SUMIF function to summarize data based on a single criterion.
  
• Enlivening your charts with clip art in any version of Excel.
  
• Summarizing complex data sets quickly with Excel’s PivotChart feature.
   

Learning Objectives:

• Identify how to create self-expanding charts by way of Excel’s Table feature.
  
• Define how to save time by copying chart formatting between charts and using chart templates.
  
• Apply new charting features available in Excel 2013 and later