A course for complete beginners on how to create and use Pivot Tables in Excel
What you will learn
Learn how to create pivot tables
Learn how to use pivot tables
How to organise data ready to create pivot tables
How to add in pie charts or bar charts with your pivot tables
How to add conditional formatting to your pivot table
How to add in slicers
Description
Hello and welcome to this simple and easy to understand course on how to create and use pivot tables in Excel.
Pivot tables are a tool exclusive to Microsoft Excel, 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 Excel 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 🙂
Content