Excel Pivot Table Master Course (Udemy.com)
Learn everything you need to know about Excel Pivot Tables with a highly rated instructor! Excel 2010, 2013 & 2016
Created by: Matt Jackman
Produced in 2018
What you will learn
- Analyze large sets of information quickly and easily using Excel Pivot Tables
- Use their skills to understand their business information better
- Create more valuable insights for their company
Quality Score
Overall Score : 96 / 100
Course Description
By the end of the course, you'll be confident using Pivot Tables on the data that you use every day.
Who will benefit from this course?
If you use large sets of information within Excel, then you'll definitely benefit from learning Pivot Tables. You might get this data from other departments in your company or maintain it on your own, but if you ever need to analyse that information or understand it more thoroughly, Pivot Table will be essential.
What skills do you need?
Pivot Tables are an intermediate topic in Excel so before you take this course you should be comfortable with the following tasks in Excel.
- Copying and pasting information
- Creating formulas in Excel
- Navigating between sheets and using the Ribbon
This course stands out in a few key areas. Firstly, we actually show you how to ensure your data is in the right format to start using Pivot Tables. This is one of the most critical elements of Pivot Tables, but it's something that most courses leave out. Without the correct structure, you'll struggle to effectively analyse your data.
Additionally, this course uses the same sample data throughout the majority of the course. So instead of showing you a new skill on data that you're not familiar with, we build your skills on data that you've used throughout the course. This way you can focus on learning new skills without being bogged down with trying to understand the new data set.
The course does have practice activities that use different data sets to test your skills and expose you to some other data. In those videos, we spend time ensuring you understand the data set and pose specific questions for you to answer. We then walk through the practice answers together to ensure you get the most out of them.
Conclusion
Pivot Tables have the power to change the way you use Excel and give you skills that will set you apart from your colleagues. With Excel being a critical tool in almost every business, these skills will go a long way to boosting your career.Who this course is for:
- Somebody that uses Excel on a regular basis
- Has a desire to analyse data in Excel
- Works with large sets of information or maintains information on their own
Instructor Details
- 4.8 Rating
187 Reviews
Matt Jackman
Hi, I'm Matt.
I've been using Excel for over 15 years and learned a ton along the way. I've used Excel in some of Australia's largest companies developing Business Intelligence solutions that drive meaningful business results. Throughout my journey, the thing that has always energized me the most is seeing people's eyes light up when I show them something new for the first time.
Now, I'm the lead instructor at exceltutes.com, as project dedicated to teaching people how to use Excel. It's a project I'm very passionate about and I'm excited to share the experience with the Udemy community.
I hope I have the opportunity to show you something new for the first time and give you skills that will allow you to shine.
Students also recommend
-
Microsoft Excel - Online Tutorial for Beginners (2010)
-
0.0 (0 Reviews)
-
Provider: Chandoo.org
Time: 1h 30m
Free


