Tip:
Highlight text to annotate it
X
One new feature in Excel 2013 is the recommended pivot table
It is a very fast way to summarize large amounts of data
As you can see I have a quite a large data set here
I will now create a pivot table using the recommended pivot table command
I select one cell in my dataset
Click on Recommended Pivot table (Insert tab)
Excel automatically analyze my data and give me several different options on how I can summarixe my data with Pivot Table
Sales by region, Sum of Sales and count etc and so on…
If I see a Pivot table I find suitable I select it an click OK
And there I have my Pivot Table
This is a really fast way of using the excellent pivot table tool, a tool that have improved even more with Excel 2013
Thank you for watching!