Getting started with charts in Excel 365 (2023)
Excel 365 (2023)
| Beginner
- 11 videos | 48m 3s
- Includes Assessment
- Earns a Badge
- 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). Would you like hands-on practice? Go to the Course Contents pane and download the sample files to follow along with select videos.
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 1sThis 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 50sYou 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
-
3. Modifying chart design in Excel 3654m 39sOnce 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
-
4. Editing chart data in Excel 3655m 9sExcel 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
-
5. Configuring chart titles & axes in Excel 3655m 5sIn 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
-
6. Adding & removing chart elements in Excel 3653m 55sIn 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
-
7. Inserting trendlines in Excel 3654m 22sTrendlines 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
-
8. Formatting the chart area in Excel 3654m 48sIn 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
-
9. Formatting chart elements in Excel 3655m 5sIn 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
-
10. Creating Sparklines in Excel 3654m 38sSparklines 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
-
11. Formatting sparklines in Excel 3654m 30sJust 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.
