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 :)
Coupons are created by instructors to promote their courses and attract new students. They can offer either discounted prices (for example, $11.99) or 100% free access. Each coupon expires once it reaches its redemption limit (usually 1,000 enrollments, sometimes 100) or when its expiration date arrives (often within 5 days).
Each Udemy coupon has a maximum activation limit — usually 1,000 uses, though some are limited to 100. This means the coupon can only be redeemed that many times before it expires, or until it reaches its expiration date — whichever comes first.
We don’t have direct contact with instructors, and only they can create or share coupons. You can try reaching out to the instructor directly — their social links (like Twitter or Facebook) are often listed on their course or profile page. Unfortunately, we can’t provide or request coupons on your behalf.
We are a Udemy affiliate partner, which means we may earn a small commission when you purchase a paid course through some of the affiliate links on this website. (Free or 100% off courses do not generate any commission.) This website is not owned, operated, or endorsed by Udemy, Inc. “Udemy” is a registered trademark of Udemy, Inc. `