Excel Pivot Table Basics

Start analyzing data with Excel's most powerful data analysis tool, Pivot Tables. They're easier than you think!
Rating: 4.4 out of 5 (9,050 ratings)
87,771 students
Excel Pivot Table Basics
Rating: 4.4 out of 5 (9,077 ratings)
87,892 students
Use basic Pivot Tables in Excel
Analyze large sets of information
Use Excel more efficiently
Structure information more effectively

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

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 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 with ease!

Who this course is for:
• 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
Curriculum
4 sections • 14 lectures • 49m total length
• Introduction to Preparing Your Data
• How to Fix Your Data
• Introduction to Creating Pivot Tables
• Creating a Pivot Table with our Sample Data
• Using Multiple Fields to Analyze Your Data
• Formatting Values
• Section Introduction
• Pivot Table Basics Challenge
• Practice Workbook
• Thank You - Continue Learning Pivot Tables For Just \$10

Instructor
Digital Analytics and SEO Professional
• 4.4 Instructor Rating
• 9,355 Reviews
• 88,408 Students
• 2 Courses

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.