How to Use Pivot Tables to Analyse Data in Excel

Pivot tables make it easy to summarise and quickly analyse large amounts of data. This data can be used to create interactive and informative dashboards by using Excel visualisations and pivot tables.

This three-week course by The Excel Club will teach you the basics of pivot tables. You'll also learn how to use them to create dashboards that can track trends and reveal valuable insights.

This course will teach you the basics of pivot tables and show you how to insert them. You can use pivot tables in many ways. This course will help you to learn how to add filters, work with dates and calculate using pivot tables.

You'll be looking at examples of data that you can use to analyse the data. This will cement your knowledge of pivot tables.

After you master the basics, you will learn advanced formatting techniques for pivot tables and some tricks that you can apply to them.

You'll continue to build on your charting skills in the previous courses. In this course, you will explore pivot charts and how they can be used to visually display data from pivot tables.

Pivot table dashboards can be a great way of presenting and providing unique perspectives on large amounts of data.

This course will walk you through all the steps required to create a pivot dashboard in just 20 minutes. This course will cover everything, from setting up pivot tables and creating charts to formatting your dashboard and using slicers and timelines.

You can see some of the steps in this course before you sign up.