PivotTables

Introduction

What you will learn

You are going to achieve an understanding of what PivotTables are and what value they can add to you in your work. You are first going to learn some basic concepts and then go through an example of using a PivotTable in a scenario to create a report and answer questions.

PivotTables summary

PivotTables are an accessible and powerful reporting tool within Microsoft Excel. They allow you to instantly create customisable summaries of data. Anyone can learn and use them, and they can change your life!

• You can use PivotTables to summarise large amounts of data and create reports
• They are instant and accessible (everyone has excel and can learn this!)
• PivotTables reports are flexible and interactive – they can show many perspectives of the same data to answer questions and provide insights
• PivotTable reports can be instantly refreshed and updated to include new data