Objective: This short course explains what pivot tables are and the benefits of using them and then dives into how to create them, modify them and produce detailed information with little to no effort.

Pivot tables are an amazing way of taking large data sets, such as client data, customer sales, staff information or stock type data and analyzing it in a way that is meaningful. This makes it easy to interpret what is happening and make decisions with confidence and ease.

Mention Pivot tables to those not so comfortable with Excel, and eyes glaze over. Establish knowledge of what pivot tables are and how to leverage them to produce professional reports in Excel without the need for complicated formulas or functions. This is a serious time saver!

Jump onboard and learn how to analyse large data sets. Great for those wanting to minimise the need for complex formulas or just make their data analysis less stressful!

What you will learn in this course :

- What a pivot table is and the benefits of using them.
- 3 Different methods to create simple pivot tables
- How to arrange, format and update pivot tables
- The simple way to easily add additional elements to your pivot tables
- How to leverage pivot tables to generate a variety of reports
- How to dissect data with slicers and timelines
- How to insert a second pivot table.

User-friendly, and jargon-free, this course is a MUST for anyone working with large amounts of data who ware aiming to make sense of data without the need for complex or complicated formulas or functions.