Mastering Excel Charts

Overview:

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 course, you will learn how to build amazing charts to communicate your information and analyses more effectively.

Course Content

In this course, you will gain knowledge about the following topics:

·         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 

Learning Objectives:

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

Who Will Benefit: 

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