Microsoft Excel allows you to work with different tables in a single dashboard. This generates that the user can have a dynamic with which you can consult different data by clicking on the filters you have created.
These tools are known as pivot tables. and are widely used in spreadsheets due to their efficiency and speed with which they are created. But they have some secrets that you should know them.
So that you can become a professional in handling dynamic tableswe will show you below all the tips you should know to create the best query box.
When is it more convenient to use a pivot table than a normal one?
A dynamic table offers the possibility of changing the columns and rows to show a certain order. In this way it will be possible to filter more comfortably, since only the searched data will be displayed.
Instead, a normal table will always display filtering by columns or rows, making the information It cannot be stated in an easier way to understand different parameters.
Steps to create a pivot table in an Excel spreadsheet
The steps you will have to do to create a pivot table are:
- Navigate to the cell in which you want the pivot table to be.
- Click on the tab “Insert”.
- Then choose from the group “Boards” the tool “Dynamic table”.
- Choose the data you want to analyze by activating the option “Select a table or range” and placing the selection in the field “Table or range:”.
- Find where you want the table report to appear. It can be in a new or existing spreadsheet.
- When you have finished, you must click on “To accept”.
- Then you will see that the table has been inserted in the place you have set. What you should do now is to include the rows and columns so that the chart meets your needs.
Facebook Comments
Disqus