The Complete Excel Pivot Tables Course: Beginner to Advanced

The Complete Excel Pivot Tables Course: Beginner to Advanced, available at $79.99, has an average rating of 4.86, with 123 lectures, 25 quizzes, based on 354 reviews, and has 1676 subscribers.

You will learn about Cleaning and preparing your data How to create PivotTables Using the fields pane and adding fields and calculated fields How to use the value field settings Formatting numbers in PivotTable Different ways to summarize data Grouping and ungrouping PivotTable data and dealing with errors Using multiple fields and dimension Methods of aggregation Choosing and locking the report layout How to format PivotTables and apply styles Basic to advanced sorting and filtering Creating PivotCharts and adding sparklines and slicers Selecting the right chart to present your data Adding slicers and timelines and applying them to multiple tables Combining data from multiple worksheets for a PivotTable All about the GETPIVOTDATA function How to use 3D maps from a PivotTable Adding new data to the original source dataset Updating your data in a PivotTable and PivotChart Using conditional formatting in a PivotTable How to create amazing dashboards This course is ideal for individuals who are Users with basic knowledge of Excel 2019/365 and those upgrading from previous software versions or Users who have a foundation of Microsoft Excel and seeking to advance their Excel 2019/365 knowledge. or People looking to perform Data Analysis using Excel or Beginner Excel users who want to learn how to use Pivot Tables It is particularly useful for Users with basic knowledge of Excel 2019/365 and those upgrading from previous software versions or Users who have a foundation of Microsoft Excel and seeking to advance their Excel 2019/365 knowledge. or People looking to perform Data Analysis using Excel or Beginner Excel users who want to learn how to use Pivot Tables.

Enroll now: The Complete Excel Pivot Tables Course: Beginner to Advanced

Summary

Title: The Complete Excel Pivot Tables Course: Beginner to Advanced

Price: $79.99

Average Rating: 4.86

Number of Lectures: 123

Number of Quizzes: 25

Number of Published Lectures: 123

Number of Published Quizzes: 25

Number of Curriculum Items: 148

Number of Published Curriculum Objects: 148

Original Price: $129.99

Quality Status: approved

Status: Live

What You Will Learn

Cleaning and preparing your data
How to create PivotTables
Using the fields pane and adding fields and calculated fields
How to use the value field settings
Formatting numbers in PivotTable
Different ways to summarize data
Grouping and ungrouping PivotTable data and dealing with errors
Using multiple fields and dimension
Methods of aggregation
Choosing and locking the report layout
How to format PivotTables and apply styles
Basic to advanced sorting and filtering
Creating PivotCharts and adding sparklines and slicers
Selecting the right chart to present your data
Adding slicers and timelines and applying them to multiple tables
Combining data from multiple worksheets for a PivotTable
All about the GETPIVOTDATA function
How to use 3D maps from a PivotTable
Adding new data to the original source dataset
Updating your data in a PivotTable and PivotChart
Using conditional formatting in a PivotTable
How to create amazing dashboards

Who Should Attend

Users with basic knowledge of Excel 2019/365 and those upgrading from previous software versions
Users who have a foundation of Microsoft Excel and seeking to advance their Excel 2019/365 knowledge.
People looking to perform Data Analysis using Excel
Beginner Excel users who want to learn how to use Pivot Tables

Target Audiences

Users with basic knowledge of Excel 2019/365 and those upgrading from previous software versions
Users who have a foundation of Microsoft Excel and seeking to advance their Excel 2019/365 knowledge.
People looking to perform Data Analysis using Excel
Beginner Excel users who want to learn how to use Pivot Tables

**This course includes downloadable course instructor files and exercise files to work with and follow along.**

Data analysis is essential in today’s data-driven world. Data is crucial in understanding businesses, analyzing trends, and forecasting your business needs. It is crucial that you have the relevant skills to handle and analyze data efficiently.

PivotTable is a vital Excel skill for big data analysis and visualization jobs. PivotTables are an interactive way of quickly summarizing large amounts of data by grouping and aggregating datasets, letting you analyze the information in a clear and effective manner.

This course will discuss the importance of cleaning your data before creating your first PivotTable. You will also learn how to create PivotCharts and format your PivotTables and charts. We teach you how to make the most of this powerful data analysis tool by using some of its advanced features, including advanced sorting, slicers, timelines, calculated fields, and conditional formatting.

This course is aimed at those brand new to PivotTables and also intermediate users looking to expand their Excel skills. You can download the Excel data files that the instructor uses in the tutorials so you can readily follow along.

This course covers:

Cleaning and preparing your data
How to create PivotTables
Using the fields pane and adding fields and calculated fields
How to use the value field settings
Formatting numbers in PivotTable
Different ways to summarize data
Grouping and ungrouping PivotTable data and dealing with errors
Using multiple fields and dimension
Methods of aggregation
Choosing and locking the report layout
How to format PivotTables and apply styles
Basic to advanced sorting and filtering
Creating PivotCharts and adding sparklines and slicers
Selecting the right chart to present your data
Adding slicers and timelines and applying them to multiple tables
Combining data from multiple worksheets for a PivotTable
All about the GETPIVOTDATA function
How to use 3D maps from a PivotTable
Adding new data to the original source dataset
Updating your data in a PivotTable and PivotChart
Using conditional formatting in a PivotTable
How to create amazing dashboards

This course bundle includes:

13+ hoursof video tutorials
100+ individual videolectures
Certificate of completion
Course and exercise files to follow along

Course Curriculum

Chapter 1: Beginner: Introduction

Lecture 1: Course Introduction

Lecture 2: WATCH ME: Essential Information for a Successful Training Experience

Lecture 3: DOWNLOAD ME: Course Exercise Files

Lecture 4: DOWNLOAD ME: Course Support Files

Lecture 5: What are Pivot Tables and Why are They Useful?

Chapter 2: Beginner: Preparing Data for Analysis

Lecture 1: The Importance of Cleaning Data

Lecture 2: Removing Blank Rows

Lecture 3: Removing Duplicate Rows

Lecture 4: Clearing Formatting

Lecture 5: Applying Number Formatting

Lecture 6: Changing the Case

Lecture 7: Removing Spaces and Non-printing Characters

Lecture 8: Merging and Splitting Columns

Lecture 9: Convert Numbers Stored as Text

Lecture 10: Finding and Replacing Text

Lecture 11: Spell Check

Lecture 12: Exercise 01

Chapter 3: Beginner: The Importance of Excel Tables

Lecture 1: Excel Tables vs Pivot Tables

Lecture 2: Format Data as a Table

Lecture 3: Exercise 02

Chapter 4: Beginner: Creating a Basic Pivot Table Report

Lecture 1: Using Recommended Pivot Tables

Lecture 2: Creating a Pivot Table from Scratch

Lecture 3: Pivot Table Ribbons and Fields

Lecture 4: Pivoting the Fields

Lecture 5: Adding Multiple Dimensions

Lecture 6: Deleting Fields and Locking the Report Layout

Lecture 7: Exercise 03

Chapter 5: Beginner: Aggregation and Grouping

Lecture 1: Methods of Aggregation

Lecture 2: Combining Methods of Aggregation

Lecture 3: Grouping and Ungrouping Data

Lecture 4: Exercise 04

Chapter 6: Beginner: Formatting Values

Lecture 1: Applying Number Formatting

Lecture 2: Handling Cells with No Data

Lecture 3: Exercise 05

Chapter 7: Beginner: Layout Options

Lecture 1: Subtotals and Grand Totals

Lecture 2: Choosing a Report Layout

Lecture 3: Inserting Blank Rows

Lecture 4: Exercise 06

Chapter 8: Beginner: Formatting Pivot Tables

Lecture 1: Applying Pivot Table Styles

Lecture 2: Modifying Pivot Table Styles

Lecture 3: Creating a Custom Pivot Table Style

Lecture 4: Exercise 07

Chapter 9: Beginner: Sorting and Filtering

Lecture 1: Sorting Pivot Table Data

Lecture 2: Filtering Pivot Table Data

Lecture 3: Top 10 Filter

Lecture 4: Exercise 08

Chapter 10: Beginner: Creating Pivot Charts

Lecture 1: Selecting the Right Chart Type

Lecture 2: Clustered Column and Bar Charts

Lecture 3: Line Charts

Lecture 4: Pie and Donut Charts

Lecture 5: Map Charts

Lecture 6: Applying Chart Layouts

Lecture 7: Exercise 09

Chapter 11: Beginner: Formatting Pivot Charts

Lecture 1: Adding a Slicer

Lecture 2: Formatting a Slicer

Lecture 3: Adding a Timeline

Lecture 4: Connecting Slicers and Timelines

Lecture 5: Exercise 10

Chapter 12: Beginner: Applying Conditional Formatting

Lecture 1: Highlight Cell Rules

Lecture 2: Data Bars

Lecture 3: Color Scales

Lecture 4: Icon Sets

Lecture 5: Exercise 11

Chapter 13: Beginner: Updating Pivot Tables and Pivot Charts

Lecture 1: Adding Data to the Dataset

Lecture 2: Updating Pivot Tables and Pivot Charts

Lecture 3: Exercise 12

Chapter 14: Beginner: Course Close and Next Steps

Lecture 1: Course Close and Next Steps

Chapter 15: Advanced: Introduction

Lecture 1: Introduction to Advanced Pivot Tables

Lecture 2: WATCH ME: Essential Information for a Successful Training Experience

Lecture 3: DOWNLOAD ME: Course Exercise Files

Lecture 4: DOWNLOAD ME: Course Support Files

Lecture 5: PivotTables Recap

Instructors

Simon Sez IT
870,000+ Students, 260+ Courses, Learners in 180+ Countries

Rating Distribution

1 stars: 4 votes
2 stars: 2 votes
3 stars: 17 votes
4 stars: 127 votes
5 stars: 204 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu