Pivot Table Mastery in a couple of clicks

Pivot Tables are an important feature of Excel that allow you to extract and summarise significant data from a large data set. Instead of this being a long process of manual filtering through hundreds or even thousands of entries, Pivot Tables enable an automated process to get exactly what you want quickly without much fuss. So learning this Excel technique can really help data analysis and isn’t actually too hard to get to grips with.

Firstly, watch Jon Flynn’s video. It’s a really excellent simple introduction to what Pivot Tables are and how to create them by going through an example.

Okay, so now you know what they are, read the four ‘five minute’ quick bullet point lessons on Pivot tables to get you started on really using them http://fiveminutelessons.com/learn-microsoft-excel/pivot-tables

Next, check the 6 page guide here and download the practice workbook to try out your newly learnt skills!  http://www.gcflearnfree.org/excel2013/27

For further explanations and screen shots, see the lessons on Home and Learn here: http://www.homeandlearn.co.uk/excel2007/excel2007s7p7.html 

And to focus your knowledge on the business side of Pivot Tables, Bill Jelen, (‘Mr. Excel’ himself!) has a highly recommended book called ‘Pivot Table Data Crunching’ which will be sure to make you a master!

Buy it from Amazon here http://www.amazon.co.uk/Pivot-Table-Data-Crunching-Microsoft/dp/0789743132/ref=sr_1_1?ie=UTF8&qid=1394797280&sr=8-1&keywords=pivot+table+data+crunching

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s