PC End User

Excel: Charting Tools (1 Day) - Virtual or In-person


Sometimes, a picture really does say a thousand words, or in the case of a Microsoft Excel chart, can convey what a thousand numbers can’t. Charts are pictorial representations of the numeric values and relationships in a set of data. Microsoft Excel 2013/2016 provides us a way to generate these graphics with its Charts tools features.

Displaying data in a well-conceived chart can make your numbers more understandable, show relationships, and help to spot trends and patterns, all by providing at-a-glance views and easy-to-interpret visuals!

Performance Objectives: Upon completion of this course, you should be able to:

  • Create, modify and format charts
  • Explore and change chart types—column, bar, line, pie, combo
  • Add, manipulate, and format chart elements
  • Learn “best-practice” tips in presenting charts
  • Discover some closely related visualization tools
  • Identify Data bars, color scales, and icon sets in Conditional Formatting
  • Define Sparklines and Pivot charts

Audience: Anyone who uses excel and especially reporting.

Recommended Prerequisite: To be successful in this course, you should be familiar with using personal computers, the mouse and keyboard. You should be able to use Windows to launch and close programs; navigate to information stored on the computer; and manage files and folders. To ensure your success, we recommend you first take an introductory Windows course.

  • Sorry, there are no classes currently available for this course.
    Contact the DES Training Center traininginfo@des.wa.gov for training options.