Excel - Create a chart Tutorial

In this video, you will learn how to create a chart using Microsoft 365. The video covers the process of selecting the cells you want to use for the chart, clicking the quick analysis button, and accessing the Charts tab.
Excel then displays recommended charts based on the selected data.
You can hover over each chart option to see which one looks best for your data.
The video demonstrates creating a clustered column chart, which is great for comparing data.
By following the steps in the video, you will be able to create eye-catching charts that make it easier to analyze your data.
This tutorial is essential for anyone using Microsoft 365 and looking to improve their data visualization skills.

0:52
1186 views

An error occurred while attempting to play the video

We recommend
Excel

Disponible dans Microsoft365

DiLeap AI: CE QUI POURRAIT VOUS INTÉRESSER

Excel - Create a PivotChart

In this video, you will learn how to create a PivotChart using Microsoft 365. The video demonstrates the process of creating a new sheet, selecting the data, and creating the PivotChart.
It also shows how to add filters and modify the chart to customize it according to your needs.
Creating a PivotChart allows you to visualize and analyze data in a more dynamic and interactive way.
This tutorial will help you master the skill of creating PivotCharts using Microsoft 365, enhancing your data analysis capabilities.

566 views

Excel - Create your first chart

In this video, you will learn how to create your first chart using Microsoft 365. The tutorial guides you through the process step by step, starting with opening the necessary folders and selecting the data for your chart.
It shows you how to access the recommended charts and choose the most suitable one for your data.
You will also learn how to customize the chart's appearance by changing colors and styles.
This tutorial is a great resource for beginners who want to create visually appealing charts in Microsoft 365.

473 views

Excel - Create pie, bar, and line charts

In this video, you will learn how to create pie, bar, and line charts using Microsoft 365. The video demonstrates the process of selecting the cells you want to chart and clicking on the Charts option.
Excel will display recommended chart options based on the selected data.
However, it's important to note that the options may vary depending on the data.
The video shows how to create a pie chart by selecting the cells and clicking on the pie option.
It also explains that a pie chart can only display one data series.
The video then moves on to creating a bar chart using the same data, highlighting how charting the data in different ways can provide different perspectives and insights.
The video concludes by mentioning that there are many more chart options available in the Insert tab of the Charts group.
It recommends using the Recommended charts option to find the best chart for the selected data.
Finally, the video demonstrates how to create a line chart with markers, which can be a better option than a pie chart for displaying multiple data series.
This tutorial will help you create visually appealing and informative charts using Microsoft 365, enhancing your data analysis skills.

3:13
1441 views

Excel - Create a PivotTable and analyze your data

In this video, you will learn how to create a PivotTable and analyze your data using Microsoft 365. Pivot tables are a powerful tool for summarizing, analyzing, exploring, and presenting data in a report.
The video demonstrates how to create a PivotTable by clicking on any cell in your data, selecting "Insert," and choosing from the recommended pivot table layouts.
You can preview each recommendation to see how your data will look.
The video also shows how to format the numbers in the PivotTable as currency.
This tutorial will help you gain a better understanding of your data and make informed decisions.

1:35
1336 views

Excel - Available trend charts

In this video, you will learn about the available trend charts in Microsoft 365. Trend charts are a common method for visually illustrating relationships in data.
They are ideal for indicating changes among different data sets.
The video covers line charts and area charts.
Line charts connect discrete but continuous data points with straight lines, making them effective for trend analysis.
Area charts display quantitative data and emphasize the area between the axis and the line with colors, pictures, and hatchings.
They work best when the total is as important as its shares.
The difference between area charts and line charts is that area charts show filled areas below the line, which can obscure other data series on the same chart.
This knowledge will help you effectively present and analyze data using trend charts in Microsoft 365.

455 views

RELATED COURSES This tutorial is part of the following courses

Video Training Microsoft Excel - Discovery level

Discover and familiarize yourself with Excel: from creating and using your tables to enhancing your visuals and collaboration. Our introductory Excel tutorials combine simplicity and efficiency!

Your trainer for this course
Cours E-learning

229 vues

ALL COURSES