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

icon
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

icon
Quality Score

Content Quality
/
Video Quality
/
Qualified Instructor
/
Course Pace
/
Course Depth & Coverage
/

Overall Score : 96 / 100

icon
Course Description

Pivot Tables are the most powerful tool in Excel to analyze large sets of information. If you've never used Pivot Tables before, don't worry. This course takes you from the very beginning of Pivot Tables and slowly builds on your skills and knowledge by breaking up new skills into short but comprehensive videos.
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.
  1. Copying and pasting information
  2. Creating formulas in Excel
  3. Navigating between sheets and using the Ribbon
Why this course?
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

icon
Instructor Details

placeholder

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.

icon
Reviews

4.8

187 total reviews

5 star 4 star 3 star 2 star 1 star
% Complete
% Complete
% Complete
% Complete
% Complete

By Jessica Hudson on 12/6/2020

Learning a lot about pivot tables

By Mary Kenney on 10/18/2020

Y

By Megan Miller on 10/14/2020

Very helpful class. I knew very minimal about Pivot Tables and now I feel much more confident about them. And best part is even if I don't remember 100% I can always come back and check it out. Matt is a great instructor!

By R.D.Domun on 9/21/2020

it ia a good match

By Susan Jackson on 9/11/2020

yis

By Patti Blasingame on 9/1/2020

I create large employee learning reports for execs in a clean dashboard appearance. I am here to make myself better with Excel.

By John Hetherington on 8/12/2020

I really enjoyed it - very useful and taught in a clear way. Learning this online was actually better than in person, since you can go back and re-do a section as many times as needed.

By Donna GrandErie on 7/16/2020

?

By Ong Hong Eang on 7/15/2020

V good, thanks for the comprehensive coverage on Pivot Table

By Nitin Thakkar on 7/3/2020

One of the best Pivot Table tutorials. Thank you

By Lindy Davidson on 7/2/2020

It was very useful - thank you so much!

By Louis Kotze on 6/18/2020

Great course love it!