The Complete Excel Pivot Tables Course: Beginner to Advanced

Learn and Master Pivot Tables in Excel with this Beginner to Advanced course from Microsoft experts, Simon Sez IT!

4.51 (315 reviews)

Udemy

platform

English

language

Microsoft

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

Why take this course?

**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+ hours of video tutorials
100+ individual video lectures
Certificate of completion
Course and exercise files to follow along

Reviews

Annette

October 18, 2023

The presenter's pace is good. She is easy to hear and understand. The onscreen illustrations are easy to see and follow. So far, best online "tutorial" I have seen.

Peter

October 8, 2023

It is a good overall introduction to explain what pivot table can do and provide some basic idea of how to use it.

Zach

September 29, 2023

A great full understanding of Pivot Tables is given. The only tricky part now will be implementing this into my current reporting, but that's on me and the tools I learned here. Worth the money, worth the time. Thank you.

Cornelia

April 23, 2023

Extremely clear and logical presentation. The lecturer speaks clearly and with good intonation to keep the lesson interesting. She also shows multiple examples of using a keyboard shortcut to build up familiarity.

Knetsch

February 6, 2023

Very interesting course content with some good ideas; such as dynamic Grafik titles and graphical maps. Well done and clear explanations.

Saingghech

January 24, 2023

This class is very informative. I learnt a lot of new things about excel after taking this course. Very easy to follow along and highly recommended for those who wants to learn more about excel and how to use a pivot table. Overall, this is awesome!

John

January 23, 2023

The course is a perfect match for my knowledge level. Debra uses a proper pace - not to fast - not too slow. The included sample datasets are great for practicing the information learned.

Joan

January 5, 2023

Not really at first as there was no audio to explain how to unzip files etc. Facilitator said this is how you do it then showed it with no audio. Had no clue and needed to figure it out on my own.

Sachin

December 31, 2022

The course did exactly what it said and it worked for me perfectly besides one small issue of CREATING RELATIONSHIPS in Pivot Table. I have pasted a query but nobody from the course instructor team replied. So, one less star for that.

Sibyl

November 10, 2022

I think this was a great course to learn all the tips and tricks of excel and I learned a lot from this. Thank you!

Dale

June 12, 2022

I found this course to be very easy to follow, everything was explained clearly. Deb is a very good presenter and I will be looking to do more Microsoft courses where she is the presenter.

Chinyere.Chime@mtn.com

February 1, 2022

I am happy the course had downloadable exercises and course support files. I also like the way the course also showed how to download those files.

Charts

Price

Rating

Enrollment distribution

The Complete Excel Pivot Tables Course: Beginner to Advanced - Distribution chart