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

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

An error occurred while attempting to play the video

Disponible dans Microsoft365

DiLeap AI: CE QUI POURRAIT VOUS INTÉRESSER

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

Excel - Add filters on PivotCharts

In this video, you will learn how to add filters on PivotCharts.
The video covers the process of selecting the relevant fields related to music and applying them as filters.
This will help you customize your PivotChart and focus on specific data points.

422 views

Excel - Functions and formulas

In this video, you will learn about functions and formulas in Microsoft Excel.
The video covers how to use slicers to filter data, create drop-down lists, sort and filter data, use conditional formatting, create charts, and analyze data using PivotTables.
This will help you become proficient in using functions and formulas to manipulate and analyze data in Excel.

3:24
1618 views

RELATED COURSES This tutorial is part of the following courses

Video Training Microsoft Excel - Advanced level

With our "advanced" tutorials, discover and master the full potential of Excel, using complex functions, macros and the power of DCTs and Power Pivot, combined with the Power Query tool.

Your trainer for this course
Cours E-learning

184 vues

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

ALL COURSES