Getting started with charts in Excel 365

Excel Microsoft 365 (2021)    |    Beginner
  • 9 videos | 29m 50s
  • Includes Assessment
  • Earns a Badge
  • Certification CPE
Likes 9 Likes 9
Present your Excel 365 data visually by using charts. Excel features several built-in charts, each of which can be customized to suit your needs. In this course, you will learn how to insert charts and add charts quickly with the Quick Analysis tool. You will explore how to create a bar chart, pie chart, line chart, and add chart labels. This includes adding a chart title and data labels, and discovering how to present negative values in a chart. Finally, you will explore how to apply basic formatting, such as default colors, to your charts. In order to practice what you have learned, you will find practice exercises and samples in the Course Contents pane or in the Resources section.

WHAT YOU WILL LEARN

  • discover the key concepts covered in this Microsoft 365: Getting started with charts in Excel 365 course
    insert a recommended chart in Excel 365
    create a bar chart in Excel 365
    create a pie chart in Excel 365
    create a line chart in Excel 365
  • use the Quick Analysis tool to insert a chart in Excel 365
    add labels to a chart in Excel 365
    present negative values in a chart in Excel 365
    apply basic formatting to charts in Excel 365

IN THIS COURSE

  • 44s
    This video outlines the key content covered in the Microsoft 365: Getting started with charts in Excel 365 course, including how to create a bar, pie and line chart, labelling a chart, and how to apply basic chart formatting. FREE ACCESS
  • 2m 58s
    Charts can be used to analyze and present data in a visually appealing manner. Excel 365 comes complete with a variety of different chart types to choose from. Because some chart types are better suited to illustrating data sets than others, Excel 365 can recommend a chart type to use based on the data. This video aligns with MOS MO-200 / Excel Associate Certification exam objective: 5.1.1 Create charts. FREE ACCESS
  • Locked
    3.  Creating a bar chart
    4m 2s
    In Excel 365, you can turn any set of data comparisons into a bar chart to make the distinctions between the values more visually compelling. FREE ACCESS
  • Locked
    4.  Creating a pie chart
    4m 18s
    In Excel 365, you can turn any single series of data values into a pie chart to demonstrate how all of the respective values contribute to the whole. FREE ACCESS
  • Locked
    5.  Creating a line chart
    4m 14s
    In Excel 365, you can turn data table values into a line chart to illustrate various data fluctuations over time, as well as the interconnectedness of data variables. Line charts are especially useful to depict data trends visually. FREE ACCESS
  • Locked
    6.  Inserting charts with the Quick Analysis tool
    2m 59s
    Using the Quick Analysis tool in Excel 365, you can quickly insert a chart to present information visually. FREE ACCESS
  • Locked
    7.  Labeling a chart
    3m 35s
    In Excel 365, charts can contain large amounts of information. To make charts easier to read, you can label various chart elements, such as the data points, axes, and even the chart title. Charts can also have multiple labels, which helps to make the information they contain easier to interpret. FREE ACCESS
  • Locked
    8.  Presenting negative values in a chart
    4m 3s
    In Excel 365, you can present negative values in a chart differently from positive values to make the distinction clearer. In this video, you will learn how to adjust the way in which negative chart values are formatted and arranged on the respective chart axes. FREE ACCESS
  • Locked
    9.  Applying basic chart formatting
    2m 58s
    With Excel 365, you can easily make basic formatting changes such as adjusting your chart's default color options to make it more impactful. In this video, you will explore how to apply basic formatting to charts in Excel 365. FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE