It can be difficult to convey the meaning derived from a spreadsheet, especially when there are large amounts of data involved. An excellent solution is to use the charts and other data visualization tools contained within Excel. In the Excel Charts and Visualizations course, we discuss how to create and modify charts, the many types of charts and when they are most applicable, advanced charting practices, sparkline graphics, custom formatting codes, shapes, icons, and dashboard concepts - everything you need to achieve the best possible presentations.
Learning Objectives
Upon successful completion of this course, participants will be able to:
Explain the nature of the ribbon system and how it is used.
Describe the purposes to which the different types of charts can be put.
Identify the characteristics of a chart sheet.
Specify the commands used to adjust charts.
Identify the characteristics of each type of chart.
Describe how a data series used in a chart is manipulated.
Identify the formatting options for sparkline graphics.
Specify the formatting codes needed for different types of numeric presentations.
Major Topics
Excel Charts and Visualizations
The Worksheet Ribbon
Chart Overview
Chart Sheets
Advanced Charting Practices
Sparkline Graphics
Custom Number Formats and Shapes
Excel Dashboarding
