Excel Pivot Tables Explained
For some good tips on how to create a pivot table check out Stephen Well’s article from Personal Computer World.
Explore how Excel’s Pivot Table can help you to make sense of your data
Whether you call it a table, list or flat-file database, a series of records all neatly split into the same fields forces a disciplined order upon a mass of related data. But it doesn’t necessarily help you to analyse it.
That’s where an Excel Pivot Table is so useful. It allows you to look at the same information in many different ways. You can not only group and summarise the data, but also add depth to it. You can tell Excel which of the fields in the list are to be arranged in rows and columns. You can also designate a page field that seems to arrange items in a stack of pages. You can add a calculated field and twist all the data around, hence the Pivot.
Leave a Comment
If you would like to make a comment, please fill out the form below.
You must be logged in to post a comment.
