How to Create and Use Pivot Tables

What You Will Learn?

• Hello and welcome to this simple and easy to understand course on how to create and use pivot tables..
• Pivot tables are a tool exclusive to the software I use throughout this course, and they are extremely useful when dealing with large amounts of data. A pivot table is used to summarise a large amount of data into an easy-to-read table. You will find them an invaluable way to save time, and organise and present your data..
• In this course, we shall delve into how to create and use pivot tables. I've created some easy-to-follow lessons with some example datasets that show you how to organise your data, and how to create pivot tables. You could use pivot tables to analyse a dataset you already have and see your data in a number of different ways with a few quick clicks without manually manipulating any information..
• This course is ideal for anybody who needs to analyse data quickly, for example business people, teachers, caterers, car garage salespeople, and students. Throughout this course, I assume you have absolutely no knowledge of pivot tables or even spreadsheets in general, so I take you right from the start and describe each step in terms you will understand..
• Through this course we will look at:.
• · Organising Datasets.
• · Creating Pivot Tables.
• · Recommended Pivot Tables.
• · Adding Charts to View Data.
• · Slicers.
• · and much more....
• I hope you enjoy :).