ComplianceOnline

Exploring Excel: Charts and Graphs

Instructor: David H Ringstrom
Product ID: 704849
  • Duration: 90 Min
Purchase option for this webinar is currently unavailable. Please contact our Customer Care for more info.

Customer Care

Fax: +1-650-963-2556

Email: customercare@complianceonline.com

Read Frequently Asked Questions

This training program will detail applying new charting capabilities in Excel 2013 and later, define how to save time by copying chart formatting between charts, and list ways to simplify chart-related tasks. It will also enumerate how to enliven Excel charts with clip art.

Why Should You Attend:

In this webinar, attendees will:

  • Learn to automate the creation of Excel charts.
  • Learn about helpful features in Excel, such as the Slicer feature, Sparkline feature, and the Recommended Charts feature.
  • Discover why certain features are disabled in some workbooks.
  • Receive detailed handouts that serve as reference tools.

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.
  • Understand new charting capabilities in Excel 2013 and later.

Areas Covered in the Webinar:

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

Who Will Benefit:

  • Banking
  • Finance
  • Insurance
  • Education
  • Telecom
  • IT
  • CPAs
  • CFOs
  • Controllers
  • Marketing
  • Sales
  • Investments
  • Pharmaceutical
  • Medical Devices
  • FDA
  • Aviation
  • Energy
  • Retail
  • Human Resource
  • Logistics and Supply Chain
  • Accountants
  • Audit
Instructor Profile:
David H Ringstrom

David H Ringstrom
Owner, Accounting Advisors, Inc

David H. Ringstrom, CPA, is an author and nationally recognized instructor who teaches scores of webinars each year. His Excel courses are based on 25 years of consulting and teaching experience. Mr. Ringstrom focuses on what users don’t, but should know about Microsoft Excel. His goal is to empower attendees to use Excel more effectively.

Follow us :
ComplianceOnline Banking Summit 2016 | Risk Management and Data Security - 80390SEM
ComplianceOnline Medical Device Summit 2017

Product Reviews

This product hasn't received any reviews yet. Be the first to review this product! Write review

Best Sellers
You Recently Viewed
    Loading