Course details

Excel Office 365 (Windows): Creating Charts & Graphics

Excel Office 365 (Windows): Creating Charts & Graphics


Overview/Description
Expected Duration
Lesson Objectives
Course Number
Expertise Level



Overview/Description

Learners can explore the use of charts in Excel for Office 365 to enhance the look of data in this 10-video course, which demonstrates how to use several of Excel's charts, and how to customize charts for specific data. You will learn to use the Quick Analysis tool to insert a chart, and how to use visualized patterns to display data. This course then examines how to label charts, and how to choose which elements to show, including labels, legends, and titles. Learners will observe how to use the Formatting tools to change a chart's appearance. You will learn to customize your chart axes, how to adjust measurements, how to move maximum and minimum values, and how to change the point where the two axes cross in the chart. This course examines how to use Sparklines to represent an overall trend of a selected data range, and to format them further. Finally, you will learn how to select a color scheme, mark different data points, and even highlight the negative values in a trend.



Expected Duration (hours)
0.6

Lesson Objectives

Excel Office 365 (Windows): Creating Charts & Graphics

  • insert , edit and remove charts
  • insert charts quickly
  • customize chart labels
  • format a chart
  • customize chart elements
  • customize chart axes
  • create a chart template
  • present negative values in a chart
  • insert trendlines
  • customize trendlines
  • Course Number:
    ds_msex365_13_enus

    Expertise Level
    Intermediate