Excel - New Chart types Tutorial

In this video, you will learn about new chart types in PowerPoint 2016. The video covers six new chart types that have been added, including histogram options, Pareto, box whisker, and waterfall charts.
These new chart types have the same rich formatting options that you are familiar with, making it easy to create data visualizations for financial and hierarchical information or to reveal statistical properties in your data.
This tutorial will help you enhance your data visualization skills and create impactful presentations.

1:52
1591 views

An error occurred while attempting to play the video

Disponible dans Microsoft365

DiLeap AI: CE QUI POURRAIT VOUS INTÉRESSER

PowerPoint - New chart types

In this video, you will learn about new chart types in PowerPoint 2016. The video covers six new chart types that have been added, including histogram options, Pareto, box whisker, and waterfall charts.
These chart types have rich formatting options and are especially well-suited for data visualization of financial and hierarchical information, as well as revealing statistical properties in your data.
This tutorial will help you create commonly used data visualizations and enhance your presentations.

0:39
1212 views

Excel - Understanding distribution charts for a series of values

In this video, you will learn about understanding distribution charts for a series of values.
The video covers different types of data visualization in Excel, such as line charts, clustered columns, pie charts, histograms, scatter charts, heat maps, maps, area charts, and hierarchy charts.
It explains when and how to use each chart to display data effectively.
This knowledge will help you make informed decisions and create visually appealing dashboards.
By following the tips and best practices provided, you can design better dashboards that tell a story, avoid information overload, and choose the right visualizations.
This tutorial is essential for anyone using Microsoft 365 and seeking to improve their understanding of distribution charts.

516 views

Excel - Create a chart

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
1198 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
1465 views

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

RELATED COURSES This tutorial is part of the following courses

Video Training Microsoft Excel - Intermediate level

Increase your scope of action with our intermediate tutorials dedicated to formulas, advanced visual enhancement and data analysis with pivot tables, and take advantage of all that Excel has to offer!

Your trainer for this course
Cours E-learning

220 vues

ALL COURSES