Office Online - PivotTable Insertions Tutorial

In this video, you will learn about PivotTable insertions.
The video covers how to start from an unformatted table and use the Insertion tab to select the data you want to filter.
It also demonstrates how to use filters to easily find your data.
This tutorial will help you understand and utilize PivotTable insertions effectively in Microsoft 365.

0:43
2244 views

Available in Microsoft365

DiLeaP AI: THIS MIGHT BE HELPFUL

Excel - Refer to a table by appying filters and sorts

In this video, you will learn how to refer to a table by applying filters and sorts.
The video covers the process of filtering data based on specific conditions and sorting the data in a desired order.
This will help you effectively manage and analyze data in tables.

2:49
511 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
3448 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.

1:12
422 views

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

Excel - Merge two columns

In this video, you will learn about merging two columns using Microsoft 365. The video covers the process of merging columns in Microsoft Excel and demonstrates how to do it step by step.
This will help you organize and manipulate data more efficiently in Excel using Microsoft 365.

3:27
782 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

1764 Views

ALL COURSES