Hi friends, I am Sameer welcome back to my article, In this article, I will guide you on how to create a pivot table in excel.
Excel has, by its very nature, the best application to create spreadsheets of all kinds, which allows us to complete day-to-day data-intensive data. about the database, in addition to allowing us to represent the data they include in the worksheet.
the submission of lists and spreadsheets that Excel allows us to create are two functions that we can use to publish on it, the latter is one of the most powerful functions provided by the application which is located in Office 365.
Table of Content
1 What is comparing tables
2 Pivot tables will be created
2.1 File types
2.2 Create pivot tables
2.2.1 Filters
2.2.2 All
2.2.3 Kab
2.2.4 Key
3 Strategies reversed
What is a comparable table?
It seems like more than one time you have heard of the pivot table, one of the many great ideas and functions that Excel has for us and it allows us to manage large amounts of data quick and easy.
The earning tables that we can create with Excel, not only allow us to extract data from the tables but also allow us to retrieve data from the data created with Access, Microsoft application for data creation. If you want How to Hide Columns in Excel.
Ok, but what is a pivot table? Pivot tables are filters that we can use in databases and that also allows us to make inferences of results. If you regularly use filters in your presentation, if you use pivot ratio, you will notice how much time you spend with them.
Pivot tables will be created
In order to create pivot packages, we need a data source, a data source that can be a presentation file that we always use to store data. If we use the data created in the Directory, we can create a file to send to the table where all the data is stored.
If the data used is text, with data separated by a greeting, we can create from that data from where to extract the data to create comparative targets. If this flat file type is the only file design we need to build strong tables, we need to see the possibility of exporting the file to another format or creating a macro that is monitored creating expansion tables at all times. we import data.
Although his name would be easily distracted, nothing more comes from the fact. Creating pivot tables is a very simple process if we follow all the steps we show below.
File type
Once we have the data created, we need to prepare it so that Excel can identify which cell contains the data and which cells contain the names of the data that we need to filter to create dynamic data.
To fix the tables, the first thing we need to do is select all the cells that are part of the table and click on the Format button as a table on the Home ribbon.
Different spreadsheets will be shown below, spreadsheets that not only modify the aesthetics of the table but show Excel that it is a capital layer of data. In that case, it does not matter which one we choose. To the question, Where is the information in the door? We must check the box labeled.
In this way, we tell Excel that the first row of the table represents the name of the data in the table, in order to create a dynamic table, which will allow us to filter the filter system. The. Once we have the table with the data, and we have set it up correctly, we can create the extension table.
Create pivot tables
The first thing we need to do is choose which table is the material that will be part of the expansion table, including the indicators that tell us what data they include (in our table four City, Employee, Guardian, Kg).
Next, we go to the Rope and click on Insert.
Inside, click on Dynamic Messages and a box named Create a pivot table.
In this box we see two options:
Select the file you want to check. As we have selected the table that we want to use to create the dynamic table, it has already been shown the selection in the name Table1. We can change this name in case we intend to add more tables in the old folder. If you want How to move columns and rows in excel.
Select where you want to place the pivot table. If we do not want to compare the data of the site to the pivot table, it is necessary to create a new form, which we can call the Pivot Table, so as not to confuse with the form which files out, which we can call File Number.
If we had done all the steps, the result would have been the same as the one in the picture above. If not, you will need to skip each step. In the right panel (the panel where we can move from the application or exit it floats) the data we have selected is displayed, which we need to install the filters we need.
The measures we can develop are as follows:
Filters
Here we place (by default the fields above) the fields we want to see as a value or a number. For example, I have placed the fields in the City, Staff, and Research to be able to select the total number of mailings to be sold together (Area, Worker, and Research). Use) or by city residents, Employees or Officers.
In Value, we have included all the certificates that have been sold. In the case of the example, 6 represents the number of certificates that all employees of all employees in all the districts of the city of Novelda have sold.
All
In this section, we should list all the fields we want to have displayed as a drop-down box in order to select and disclose all the results related to that value.
In the case of the example, we have placed the Area in each, so it gives us the number of mailings that have been sold in each city. If we use filters, as in the above, we can extend the results, create accurate sales information, and which staff to sell.
Kab
The Rows section allows us to create that key release from the line and function the same way as with the line link but changing the function. As we can see in the figure above, when placing an Area in the Data, the findings appear in a row and not in a row.
Important
In this section, we need to add the answers we want we share all The. By pulling the Kg field to price The value, a column is created from where every kilogram sold by the locals is reported, which is the Row filter that we have added.
In this section, we also have Applications. It was set up to show the count of cities or towns. The Sum of the KG field is set so that the total Kg of. To change which position we want to do at home in one of the design fields, we need to click on (i) on the right side of the field.
Ideas are reversed
If you have built it so far, you might think the pivot ratio is a very difficult world not worth touching. On the contrary, as you can see in this article, everything has a problem of experimentation, measurement, and measurement until we can release the data as we wish it to be. released.
If you add a field in a section that you do not need, you just need to pull it out of the form and it will be removed. Pivot tables are intended for large files, not for tables 10 0 20 files. For these situations, we can use the water filter directly.
You may also visit here.
For more up-to-date information, join our WhatsApp group by clicking here.
