Mastering Excel Charts

Mastering Excel Charts
K2E Canada Inc. presents a broad curriculum of technology-focused on-demand webinars. Participants who take these webinars will have the opportunity to learn from an award-winning team of instructors with literally hundreds of years of experience in helping professionals identify, address, and solve issues through the practical application of technology. Webinars address a variety of topics, including Excel, QuickBooks, PDFs, accounting solutions, and Microsoft Office.

NOTE: Course login details are normally sent to registrants within one week from date of registration.


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.


  • Selecting the right chart type for the reporting objective
  • Creating and customizing advanced charts in Excel quickly and easily
  • Linking or embedding charts from Excel into Word or PowerPoint
  • Constructing dynamic headings in charts that change as the underlying data changes
  • Producing specialized charts, such as gauge, thermometer, or combination charts
  • Using Pivot Charts to communicate data summarized in PivotTables

Upon completing this course, you should be able to:

  • 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 creation of similar charts in the future

Working knowledge of Excel and Microsoft Office
Program Level: Intermediate 
Advance Preparation: None 

Excel and Microsoft Office users seeking to use charts as effective communication tools to report or analyze data

CPD: 2 Hours

4/1/2022 - 3/31/2023 11:59 PM