Excel 2016 Charts and Graphs

excel 2013 iconCourse Length

Three hours

 Prerequisites

Excel 2016 Introduction or equivalent experience

Course Description

Learn how to manage your numerical data by creating charts and graphs that effectively present information. Then, emphasize your point by customizing your chart—learn how to format and modify chart elements, change chart type, layout, and style, plus much more.

 Course Topics

  • Explore chart types and create a chart
  • Identify and select chart elements
  • Select, move, resize, and delete an embedded chart
  • Change chart type
  • Change the chart type for a data series
  • Change chart location
  • Print an embedded chart on a page by itself
  • Resize, move, and delete a chart element
  • Use chart buttons
  • Modify chart elements
  • Format chart elements
  • Apply a predefined chart layout and chart style
  • Switch the data series between rows and columns
  • Update an existing chart with changed values
  • Add or remove data
  • Explode and rotate the slice(s) in a Pie chart
  • Draw attention to the small slices in a Pie chart
  • Modify Secondary Pie charts
  • Display a picture in a chart element
  • Create sparklines
  • Change the series overlap and gap width for a data series
  • Plot data on a second y-axis
  • Add floating text to a chart
  • Smooth the angles in a Line chart
  • Add lines or up/down bars
  • Add error bars
  • Add a trendline to a data series
  • Save a chart as a template
  • Apply a chart template to an existing chart
  • Delete a chart template
  • Use the “Select Data Source” dialog box
  • Review chart specifications and limits

What Participants Receive

Each participant receives a guide containing step-by-step instructions and practice exercises.