tecnolkp.blogg.se - Making pivot tables in excel 2013

As seen to the right, you can pull the exact information you need from a complex spreadsheet without having to go through the above mentioned steps for Excel-2010. The best part is you do not have to drag and drop anything into the field list. With the new Microsoft Excel-2013, you are just one click away from creating a basic pivot table. Manually drag and drop the required fields according to our requirements to calculate-Sum, average, percentage, etc.

Go to the new worksheet to check if all the fields are appearing or notĤ.

However, the 2013 Excel updates make creating Pivot tables even simpler.Ī few years back, we had to follow these steps to create a simple pivot table:

to create a table. It can take a little while for a newbie to get the hang of Pivot tables. They also allow you to avoid using complex formulas like Vlookup, SumIF, etc. Excel Pivot tables help summarize your data.