Disclosure: when you buy through links on our site, we may earn an affiliate commission.

Microsoft Excel Pivot Tables – The Complete Course

Learn Microsoft Excel Pivot Tables with a highly rated instructor! Excel 2010, 2013 & 2016
4.3
4.3/5
(388 reviews)
1,510 students
Created by

7.9

CourseMarks Score®

4.9

Freshness

9.1

Feedback

9.0

Content

Platform: Udemy
Video: 5h 34m
Language: English
Next start: On Demand

Table of contents

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. 
•Copying and pasting information
•Creating formulas in Excel
•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.

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

Requirements

• Confidently write formulas
• Copy and paste cells
• Navigate Excel and the Excel Ribbon

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
Digital Analytics and SEO Professional
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 director at Stay Digital, a company dedicated to helping local businesses thrive online.

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.
Browse all courses by on Coursemarks.
Platform: Udemy
Video: 5h 34m
Language: English
Next start: On Demand

Students are also interested in