Question
What are Pivot Tables in Excel?
Answer
PivotTable reports can help to analyze numerical data and answer questions about it. With PivotTable reports, you can look at the same information in different ways with just a few mouse clicks. Data swings into place, answering questions, telling you what the data means. Imagine an Excel worksheet of course evaluation data with hundreds or thousands of rows of data. The worksheet lays out all the data about courses in several departments and how faculty performed on the areas of teaching and course approval. But it's a lot of data to deal with — listed in row after row and divided into multiple columns.
How can you get information out of the worksheet? How can you make sense out of all of this data?
Which department performed highest? During which terms do we see the best evaluations? You can get answers to all these questions with PivotTable reports — it's like turning a mob into a marching band. A PivotTable report turns all that data into small, concise reports that tell you exactly what you need to know.
For more information about Pivot Tables in Excel, please view the full tutorial from the CTL here: Excel Part 4
If you need further assistance, please click the CTL Support Request button on this page