The way we have to work on different projects is very different from what we had a couple of decades ago, due to the tools we have to help us work.
In the past, we had to do a lot of spreadsheet work by hand, with the help of a calculator, and running all the reports on a typewriter for a professional touch.
Fortunately, all of that has been left behind, because many of these past processes were extremely slow and often did not allow space for a mistake to be made, being very common in the second generation.
A computer can be found in any workplace or in any home, and it has all kinds of programs to do any kind of work.
If we talk about fully executive work we have at hand one of the best office suites that have come out: Microsoft Office; a suite of programs that give you the opportunity to write, present, enter data into spreadsheets, and much more.
And, it is through the spreadsheet program, Excel, that we can do much of the heavy lifting that was previously done in weeks of hard work.
With the latter in mind, we can do loads of complicated work in just a couple of hours thanks to Excel, due to all the tools it has to make a much easier calculation process.
Given this, it is useful to be able to know all the tools available to work with Excel effectively, therefore, below we will talk a little about one of the tools that Excel has for you, which are pivot tables.
How to create a pivot table in Excel?
Pivot tables are an option that Excel has to be able to perform calculations in a specific way, as well as graphs, all shown in a quite comfortable way for the user.
Through these tables, we can enter large amounts of data in order to perform simple calculations through their columns or rows, which leaves us with an excellent overview of the final accounts that we need through the data.
To be able to make a pivot table, you have to enter the data in the Excel cells, making labels of what each data or value belonging to each row or column is.
Each of these data must be entered intelligently and with attention to detail, and once that is ready you have to select all the cells you want within the pivot table.
Now, when all the cells are shaded, you should go to the ” Insert ” menu and select the ” Pivot Table ” option. And, within the options that will appear on the screen, you must click on ” Select a table or range “.
Within the table or range option indicate the same, indicate where you want the pivot table report to be placed by selecting “new spreadsheet” if you do not have a previously assembled to finally accept.
How to create a dynamic chart?
The charts that can be made from a pivot table are called pivot charts, and they can be done in an extremely simple way.
First, you must select the cells that you want to represent the chart, then click on the top option ” Insert ” and then on ” Dynamic chart ” to finally accept and see the chart that has been created from the data.
Remember that you can always arrange things a bit in the cells or through the dynamic graphics options so that they are exactly how you want.