Visualizing Data with Charts

Course Length: 1/2-day

Course Overview

Excel provides you with powerful features to help organize and analyze data. Viewing information in the form of ranges of data entries is not always the easiest or most logical way to present or understand data. You need a way to visualize data. This course will help users convert raw or analyzed data into visually clear, easy-to-interpret, high-impact visuals. It will help you to understand which charts are most appropriate for presenting your data and how to format the visuals to make them easier to read. This course will take you beyond the basics of creating charts into advanced chart features that will make your visualizations more interactive.

Prerequisites

Excel Level 1 or equivalent knowledge

Excel Level 2 or equivalent knowledge

Outline

Create Charts

• Chart Basics
• Chart Types

Modify and Format Charts

• Modification vs. Formatting
• Chart Elements
• Select Data Source Dialog Box

Advanced Chart Features

• Advanced Charts Elements
• Beyond Line Graphs, Bar Graphs, and Pie Charts
• Create and Use Chart Templates