Excel - Map Chart in Excel Tutorial

In this video, you will learn about creating a map chart in Excel.
The video covers how to use a map chart to compare values in different geographical areas.
You can achieve this by selecting the "Filled Map" option in the Insert Maps menu.
This tutorial will help you understand and utilize the map chart feature in Excel, enhancing your data visualization skills.

0:31
1143 views

An error occurred while attempting to play the video

Disponible dans Microsoft365

DiLeap AI: CE QUI POURRAIT VOUS INTÉRESSER

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
1197 views

Excel - Automatic Data Entry in Excel

In this video, you will learn about automatic data entry in Excel.
The video covers how to enter geographic or stock data, even if they contain spelling errors.
It demonstrates how to select your cells, define the Geography data type, select data to populate your columns, and fill in your table as you wish.
This tutorial will help you improve your data entry skills in Excel and save time.

0:41
626 views

Excel - Add a chart to a dedicated sheet

In this video, you will learn how to add a chart to a dedicated sheet in Excel.
The video covers the process of removing a chart from a sheet, creating a new sheet, and pasting the chart onto it.
It also demonstrates how the chart automatically updates in real-time when the data in the original sheet is changed.
Additionally, the video shows how to move the chart to an existing worksheet or create a new sheet for it.
Adding a chart to a dedicated worksheet allows for a full-screen graph without gridlines.
This tutorial is essential for anyone using Microsoft 365 and wanting to enhance their Excel skills.

443 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

Video Training - Artificial Intelligence in your daily life

Across Microsoft 365, AI powers innovative apps that can help you write and design better, visualize maps and charts in Excel, and streamline your inbox. Find out how Microsoft AI technology can solve business problems.

828 vues

ALL COURSES