Friday, August 12, 2011

How To... Create a Basic Pivot Table in Excel 2010

My second Learning with YouTube video this week is about Pivot Tables in Microsoft Excel 2010. Pivot tables allow you to rotate or swap data fields in a spreadsheet to generate a view of your data that filters, summarizes, and groups the data in many different ways. Put simply, if you want to make sense of a large data sheet, this might be the tool for you.

I have always been fascinated by some people's ability to create great looking tables with ease using Pivot Tables - it looks really cool when you see others doing this. I never investigated how to create them, but it turns out it is very easy to create a basic Pivot Table, so my video shows you how do do this. There's lots of advanced stuff that you can also do, but the video is just intended to get you started. 


No comments:

Post a Comment