Excel Pivot Table Basics
4.6 (328 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
3,842 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Excel Pivot Table Basics to your Wishlist.

Add to Wishlist

Excel Pivot Table Basics

Start analyzing data with Excel's most powerful data analysis tool, Pivot Tables. They're easier than you think!
4.6 (328 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
3,842 students enrolled
Created by Matt Jackman
Last updated 5/2017
English
Current price: $10 Original price: $75 Discount: 87% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 1 hour on-demand video
  • 1 Article
  • 4 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Use basic Pivot Tables in Excel
  • Analyze large sets of information
  • Use Excel more efficiently
  • Structure information more effectively
View Curriculum
Requirements
  • How to navigate the Excel ribbon (the menu options in Excel)
  • How to create basic formulas in Excel
  • How to copy and paste information in Excel
Description

What's this course about

Pivot Tables are one of the most powerful features in Excel. Once you learn how to use Pivot Tables, they'll change the way you use Excel.

If you're not familiar with Pivot Tables, they're a tool that allow you to summarize large sets of information quickly and easily. You can analyze thousands of rows in a matter of seconds that could otherwise take hours trying to figure out using complex formulas.

This is an introductory Pivot Table course and gives the information you'll need to start using Pivot Tables.

Who will benefit from this course

If you're somebody that uses Excel on a regular basis to track or maintain information, you will definitely benefit from learning Pivot Tables.

You don't have to be a master of Excel formulas to take this course, but you should have a sound understanding of how to navigate around Excel before you take this course.

This would be considered an intermediate Excel course and students should understand basic mathematical calculations (e.g. addition, subtraction, multiplication and division) and formulas in Excel.

What you'll learn in this course

  • How to structure your data to take advantage of Pivot Tables
  • How to create a Pivot Table
  • How to summarize information in different ways using Pivot Tables

By the end of this course, you'll be able to take your own information and leverage Pivot Tables to answer questions you never thought possible!

Who is the target audience?
  • Students should be relatively comfortable using Excel
  • Students should understand basic mathematical calculations
  • Students that work with lists of information will definitely benefit from this course
Students Who Viewed This Course Also Viewed
Curriculum For This Course
+
Preparing Your Data
3 Lectures 10:36

Most people try to analyse information using formulas, but this can be quite complex and difficult to manage. In this lesson, we look at a common way that people summarise information in Excel using formulas and compare the process with using Pivot Tables.

Download the workbook for this video to follow along in the next lesson.

Preview 05:10

How to Fix Your Data
03:52
+
Creating Pivot Tables
6 Lectures 18:42

In this lesson, we start getting familiar with the data that we'll be using in the course. We create a simple Pivot Table to put some context around what we'll be learning.

Download the workbook for this course to follow along and build your Pivot Tables.

Creating a Pivot Table with our Sample Data
06:15

You can use any field that you have in your data set to analyze your data. Pivot Tables even allow you to place more than one field in any of the areas. This gives you tremendous flexibility when it comes to answering questions in different ways.

Using Multiple Fields to Analyze Your Data
02:22

When you place values into your Pivot Table, they won't always be formatted how you want. In this lesson, we explain how to format values in a Pivot Table. It's a little bit different than what you might be used to.

Formatting Values
04:12

Whoops, where's my stuff? A question I've asked myself many times. It's easy to close your field list and it can be a bit tricky to get it back. Once you know how it works, it's easy.

Preview 01:38

Ok, now for the power! In just a few simple clicks, you can totally change the way your data is summarized. You can use the same piece of data to answer different questions using Pivot Tables. 

Summarizing Your Data
03:20
+
Lock In Your Knowledge
5 Lectures 18:59
Don't forget to leave a review
00:29



In this video, we go through our challenge questions to see how you did.

Challenge Answers
06:54

Download the practice workbook for this lesson to answer the questions within. We'll then walk through the data sets and answer a few questions together.

Download the workbook in this lesson to follow along and complete the practice questions.

Practice Workbook
10:07

Now that we have a sound understanding of what a Pivot Table is and how to create one, let's test our knowledge.

Pivot Table Basics Quiz
4 questions
+
Bonus Lecture: Thank You and Voucher Inside
1 Lecture 02:29

Get the Pivot Table Master course for only $19 - save 85%!

For more information or to claim your discount, go to the link below!

https://www.udemy.com/excel-pivot-table-master-course/?couponCode=KWH0B23


Bonus Lecture: Thank You and Voucher for Master Course
02:29
About the Instructor
Matt Jackman
4.7 Average rating
375 Reviews
4,056 Students
2 Courses
Business Intelligence Professional - Excel Power User

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.