K2's Mastering Excel Charting
Earn 2 CPE Credits!
Exam price $89.

All of our materials/exams are NASBA and the AICPA approved the revisions to the Statement on Standards for Continuing Professional Education (CPE) Programs (Standards).

Your Exam purchase includes

  • Course materials (video & PDF version)
  • Unlimited attempts to complete exam
  • Instant grading & certificate of completion
  • One year access to complete your CPE
  • Instructor discussion forum


Most accounting professionals quit using charts to communicate financial and operational information years ago because charting was too time-consuming and too cumbersome, but the new charting engine in Excel overcomes both of those issues. Now users can quickly and easily build advanced charts that allow users to filter data interactively, and create charts that change dynamically as the volume of data changes. Plus, users can easily produce combination charts on two axes, generate advanced Pivot Charts, and build charts commonly used in dashboards, such as gauge or thermometer charts. In this two-hour session, you will learn how to build amazing charts to communicate your information and analyses more effectively.

  • List ten major types of charts produced by Microsoft Office
  • Use Excel, Word, or PowerPoint to create and modify advanced charts
  • Describe the process for creating dynamic headings in Office charts
  • Explain the general process for creating custom charts such as gauge or thermometer charts
  • Use chart templates to simplify and facilitate creating similar charts in the future
  • None
  • Working knowledge of Excel and Microsoft Office
  • Intermediate
  • 103648

No Reviews