Manage Data in Excel with PivotTable

[soniya55531]

Learn how to manage data in Excel using pivot tables! See how to organize a lot of information and perform efficient and complete data analysis!

If you prefer this content in video lesson format, watch the video below or access our YouTube channel !


To receive the file(s) used in the class by email, fill in :

Your best email
To send
Excel Icon
Excel
Impressive
Everything you need to know, from Basic to Advanced, to master the most important tool in the Job Market. Learn the main Excel tools, functions and resources to make any spreadsheet more eye-catching and efficient.

Start now
Right arrow
Excel icon used as backgroundThree images of Excel course classes

Manage Data in Excel with PivotTable
In this lesson, I want to teach you how to manage data in Excel facebook data with pivot tables! You will learn how to organize a large volume of information and perform efficient and complete data analysis using this important Excel feature, pivot tables.

Considering that Excel can have up to 1 million rows, have you ever imagined doing a line-by-line analysis? It doesn't even make sense to think about it. That's why we have the pivot table to manage data in Excel quickly and efficiently.

Additionally, to further enhance your analysis, I will show you how to create clear and intuitive charts based on the analysis you have performed. In other words, in addition to the summary provided by pivot tables, you will also have a visual analysis of the data.

So, download the available material and come with me to learn how to use the pivot table to manage data in Excel.

Introducing the Database
In the material available for download, you will find the database that we will use throughout this class.

Introducing the Database
It contains fictitious information about a company's sales, containing more than 3 thousand lines with data about the date of sale, salesperson, region, product and the sales value.

This data is important for building our analyses and better understanding the company's sales. However, working with it this way would not be practical at all and would take up a lot of time.

This is considering this database, because Excel supports up to 1 million rows of data. Imagine dealing with even larger volumes. Doing this manually is totally inefficient and not advisable.

To optimize and make this analysis more efficient, saving time, we can use dynamic tables . With them, we can synthesize and summarize the information in our database in summary tables, which are much easier to work with and analyze.

How to Create a Pivot Table
To create the pivot table, simply click on any cell in your database, go to the Insert tab and select the Pivot Table option .