Excel - Create a PivotTable report manually Tutorial

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
1449 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 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
1350 views

Excel - Your first PivotTable

In this video, you will learn about creating your first PivotTable in Microsoft Excel.
The video covers the steps to set up source data in the correct table structure, develop a structured PivotTable, apply filters and slicers to your data, edit summary formulas, change header names, and display data in the desired order.
It also demonstrates how to format a PivotTable and highlights the benefits of using slicers in Excel.
This tutorial will help you showcase your data effectively and make data analysis easier.

533 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 - 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

Excel - Use Power Pivot in a PivotTable

In this video, you will learn how to use Power Pivot in a PivotTable.
The video demonstrates the process of inserting a table and sending it to a new worksheet or an existing one.
It also shows how to combine multiple tables and create relationships using Power Pivot.
The benefit of using Power Pivot is that it allows for easier data modeling and visualization.
By following the steps in this tutorial, you will gain a better understanding of how to utilize Power Pivot in a PivotTable.

557 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.

1107 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

220 vues

ALL COURSES