Getting started with charts in Excel 365 (2023)

Excel 365 (2023)    |    Beginner
  • 11 videos | 48m 3s
  • Includes Assessment
  • Earns a Badge
  • Certification CPE
Visualizing information with charts and graphs is a critical skill in today's data-driven environment. This course walks you through everything you need to know to create, format, and manage charts in Excel 365. The course begins by introducing you to the process of creating various chart types from a range or table. See how to browse through column charts, line graphs, and more, and choose the type that fits your data best. You'll then learn to modify these charts, managing their layout, style, and data. Next, find out how to add and configure titles, axes, and a wide variety of other chart elements from error bars to trendlines. See how to format the style and properties of these elements to highlight specific data points. You'll also learn how to add and format sparklines, small in-line charts that you can use to succinctly communicate trends. This course aligns with the objectives of Exam MO-210: Microsoft Excel (Microsoft 365 Apps).

WHAT YOU WILL LEARN

  • Discover the key concepts covered in the getting started with charts in excel 365 (2023) course
    Create charts
    Create a chart sheet and change the chart layout, style, and type
    Edit chart data, series, and categories
    Modify chart titles, axes, and axis titles
    Configure data labels, data tables, error bars, and gridlines
  • Insert and configure trendlines
    Format the chart area and add alt text
    Format data series and other chart elements
    Insert line, column, and win/loss sparklines
    Modify sparkline type, markers, style, and axis options

IN THIS COURSE

  • 1m 1s
    This video outlines the key content covered in the Getting started with charts in Excel 365 (2023) course, including creating charts, adding and removing chart elements, and creating sparklines. FREE ACCESS
  • 4m 50s
    You can easily create a variety of chart types from a range or table, including line charts, column charts, and more. Once you have created a chart, you can move it within the worksheet or resize it. Find out more in this tutorial. This video aligns with MO-210 Microsoft Excel Exam objective: Create charts. FREE ACCESS
  • Locked
    3.  Modifying chart design in Excel 365
    4m 39s
    Once you have created a chart, you can create a chart sheet, a worksheet where you can focus on viewing and modifying the chart. Excel also provides a number of ways to change a chart's basic design. You can select a quick layout to display certain chart elements, choose a chart style to quickly change its appearance, and even change the chart type to better suit your needs. This video aligns with MO-210 Microsoft Excel Exam objectives: Create chart sheets, Apply chart layouts, and Apply chart styles. FREE ACCESS
  • Locked
    4.  Editing chart data in Excel 365
    5m 9s
    Excel charts are linked to the source data. This means you can edit the source and the chart will update automatically. In addition, there are several ways to modify the data directly in the chart, such as by switching rows and columns, changing the chart data range, and editing individual data series and categories. This video aligns with MO-210 Microsoft Excel Exam objectives: Add data series to charts, and Switch between rows and columns in source data. FREE ACCESS
  • Locked
    5.  Configuring chart titles & axes in Excel 365
    5m 5s
    In Excel, you can modify the chart title, axes, and axis titles to make your chart easier to read and understand. This includes linking the chart title to a cell in your worksheet, adding axis titles, and customizing title text. FREE ACCESS
  • Locked
    6.  Adding & removing chart elements in Excel 365
    3m 55s
    In addition to using built-in quick layouts, you can customize your chart's layout by adding and removing specific chart elements. These include data labels, data tables, error bars, and gridlines. In this video, you will see how to add, remove, and modify these elements. This video aligns with MO-210 Microsoft Excel Exam objective: Add and modify chart elements. FREE ACCESS
  • Locked
    7.  Inserting trendlines in Excel 365
    4m 22s
    Trendlines are a valuable tool that allows you to identify patterns in your data and make predictions. In this tutorial, you will see how to insert different types of trendlines. You will also see how to configure options related to the trendline, and how to remove it from a chart. This video aligns with MO-210 Microsoft Excel Exam objective: Add and modify chart elements. FREE ACCESS
  • Locked
    8.  Formatting the chart area in Excel 365
    4m 48s
    In Excel, the entire chart and its elements are referred to as the chart area. In this video, you will see how to format the overall appearance and text of the chart area. You will also see how to add alt text, change the chart size, and access advanced formatting options. This video aligns with MO-210 Microsoft Excel Exam objectives: Add and modify chart elements, and Add alternative text to charts for accessibility. FREE ACCESS
  • Locked
    9.  Formatting chart elements in Excel 365
    5m 5s
    In addition to formatting the entire chart area, it is possible to individually format different chart elements. In this video, you will see how to format a data series, format individual data points and negative values, as well as how to access formatting options for other chart elements. FREE ACCESS
  • Locked
    10.  Creating Sparklines in Excel 365
    4m 38s
    Sparklines are small, in-cell charts that allow you to display large amounts of data in a compact format. In Excel, there are three types of sparklines: line sparklines, column sparklines, and win/loss sparklines. See how to insert each type of sparkline in this tutorial. This video aligns with MO-210 Microsoft Excel Exam objective: Insert Sparklines. FREE ACCESS
  • Locked
    11.  Formatting sparklines in Excel 365
    4m 30s
    Just like charts, sparklines can be easily customized according to your preferences. In this tutorial, you will see how to change the sparkline type, show individual points and markers, format the sparkline style, as well as configure basic axis options. 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.

YOU MIGHT ALSO LIKE

Rating 4.5 of 2242 users Rating 4.5 of 2242 users (2242)
Rating 4.5 of 271 users Rating 4.5 of 271 users (271)
Rating 3.9 of 21 users Rating 3.9 of 21 users (21)