Getting started with charts in Excel 365
Excel
| Beginner
- 9 videos | 29m 50s
- Includes Assessment
- Earns a Badge
- CPE
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
-
44sThis 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 58sCharts 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
-
3. Creating a bar chart4m 2sIn 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
-
4. Creating a pie chart4m 18sIn 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
-
5. Creating a line chart4m 14sIn 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
-
6. Inserting charts with the Quick Analysis tool2m 59sUsing the Quick Analysis tool in Excel 365, you can quickly insert a chart to present information visually. FREE ACCESS
-
7. Labeling a chart3m 35sIn 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
-
8. Presenting negative values in a chart4m 3sIn 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
-
9. Applying basic chart formatting2m 58sWith 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.
