Visualizing Excel Data with SmartArt and Charts


January 27, 2020


Cathy Horwitz

  12:00 PM ET | 11:00 AM CT | 09:00 AM PT | 90 Minutes

* Not able to attend the live session? We can arrange an on-demand session for You. Please call 1-‪814-892-0304


They say that ‘a picture is worth a thousand words.  Using SmartArt and Charts to visually display complex Excel data communicates the data’s message much more effectively to your target audience.

SmartArt graphics and Charts can be created not just in Excel, but also in PowerPoint, Word and Outlook.  This makes learning these tools extremely useful. Below are the points Cathy will cover in her presentation for Charts and SmartArt Diagrams.

Creating SmartArt Diagrams

  • Inserting Diagrams
  • Modifying Illustrations
  • Formatting SmartArt
  • Convert Bulleted Text into SmartArt

Creating Charts

  • Types of Charts
  • Creating a Chart
  • Parts of a Chart
  • Changing the Chart Type
  • Switching Data
  • Changing the Chart Style
  • Moving a Chart to a Chart Sheet
  • Creating a Combination Chart

Session Highlights :

  • Understand data better through graphical representations of the data.
  • Use SmartArt graphic to visually represent information and ideas typically presented as text.
  • Use Excel Charts as a visual illustration of numeric values or data after data from a worksheet or after the data has been summarized in a PivotTable.
  • SmartArt graphics are designed for text and charts are designed for numbers. 

Who Will Benefit :

  • Business Owners
  • CEO's / CFO's / CTO's
  • All Managers
  • Accountants
  • CPA's
  • Financial Consultants
  • IT Professionals
  • All Auditors
  • Human Resource Personnel
  • Bookkeepers

Download Conference Material

Download Here (Password Needed)

Pioneer Educator is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website:

Download Conference Material

Download Here

Download Here