SP922 - Creating Charts with Excel

Course Description

Learn to use Excel to create powerful graphic presentations and visualizations, including bar graphs, pie charts, exploded pies, line graphs, scatter plots, and three-dimensional graphs. Discover how to scale and format graphs, properly select data ranges, add titles and labels, set up legends, use grids and color, and make other graphic enhancements. Learn to select the appropriate graph type for your data and to alter that graph for your specific needs. Other topics include principles of graphing, printing graphs, and effective spreadsheet design to aid in graphing.

By the end of this course, you will be able to: 

• Understand common charting terms and chart objects. 

• Create a variety of charts, including column charts, pie charts, line charts, scatter charts, and combination charts. 

• Modifying an existing chart by changing the data range, chart type, and chart location. 

• Formatting chart objects to customize the appearance of your chart. 

• Creating pictographs that use graphics to represent data series in a column chart. 

Applies Towards the Following Certificates

• Excel Certificate : Approved Course Substitutions