Excel - Create a PivotTable and analyze your data Tutorial

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

An error occurred while attempting to play the video

Disponible dans Microsoft365

DiLeap AI: CE QUI POURRAIT VOUS INTÉRESSER

Excel - Create a PivotTable report manually

In this video, you will learn how to create a PivotTable report manually using Microsoft 365. Pivot table reports are a powerful way to summarize, analyze, explore, and present your data in a report.
This video will guide you through the process of creating a PivotTable and analyzing your data.
By following the steps, you will be able to make sense of your data, especially when you have a large amount of it.
This will help you gain insights and make informed decisions based on your data.

4:59
1426 views

Excel - Introduction to PivotTables

In this video, you will learn about the introduction to PivotTables.
PivotTables are not much more complicated than the functionalities you have already seen in previous tutorials.
They are associated with complex and profound data analysis.
PivotTables have several advantages, including the ability to rework and analyze tables with many columns and thousands of lines.
They also allow for quick and visual understanding of mathematical formulas, such as calculating averages, sums, and the number of elements.
Additionally, PivotTables enable faster analysis through dynamic filters, category collapsing, and selecting specific parts of the table.
By adding the word PivotChart, you can further enhance your charts visually.
This video will help you gain a deeper understanding of PivotTables and their benefits.

527 views

Excel - Sort, filter, summarize and calculate your PivoteTable data

In this video, you will learn how to sort, filter, summarize, and calculate your PivotTable data.
The video covers various ways to analyze PivotTable data, including sorting it to quickly identify trends, filtering it to focus on specific criteria, and using slicers to efficiently filter the data.
Additionally, the video demonstrates how to summarize the data using different functions and display it in various formats, such as percentages.
This knowledge will help you effectively analyze and understand your PivotTable data, enabling you to make informed decisions.

3:49
1423 views

Excel - Use slicers, timelines and PivotCharts to analyze your pivotetable data

In this video, you will learn about using slicers, timelines, and PivotCharts to analyze your PivotTable data.
The video covers how to set up your data sources, create a PivotTable, filter data, edit summary formulas, change header names, and display data in the desired order.
It also explains the benefits of using slicers in Excel.
This knowledge will help you showcase your data effectively and make accurate summaries.

3:38
399 views

Excel - Create a two-dimensional PivotTable

In this video, you will learn how to create a two-dimensional PivotTable using Microsoft 365. Pivot tables are a powerful tool for summarizing, analyzing, exploring, and presenting data in a report.
This tutorial will guide you through the process of creating a PivotTable manually.
By the end of the video, you will be able to create a PivotTable that provides a clear overview of your data.
This knowledge will help you make sense of your data and gain valuable insights.

536 views

RELATED COURSES This tutorial is part of the following courses

Video Training – Discover how Excel and SharePoint interact

Take advantage of the collaborative work and interactions between Excel and SharePoint! The interconnections between Excel and SharePoint are numerous and feature-rich.

1095 vues

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

204 vues

ALL COURSES