Skip to content
UdemyExcelPaid courseAll LevelsCertificate

Office Fundamentals - PivotTables in Microsoft Excel (Udemy.com)

Learn everything about creating and using PivotTables in Excel to analyze data and plot with PivotCharts & dashboards

Created by: Johannes Ruof

Last updated March 2022

icon
What you will learn

  • Properly structure raw data for analysis with Pivot
  • Insert and create PivotTables
  • Editing PivotTable fields
  • Analysis and organization of data
  • Sort, filter, and group pivot data
  • Working with values in PivotTables
  • Calculations with calculated fields
  • Create visual representations with PivotCharts & Dashboards

How it compares

Against the other 355 rated Udemy courses in Excel on CourseDuck:

  • Rating4.5 out of 5higher than 39% of them
  • Reviews278#267 of 356 by number of reviews
  • Length5.7 hourslonger than 50% of them
  • Last updatedMarch 2022earlier than 61% of them

icon
Course Description

Pivot tables are a quick and easy way to organize, summarize, and analyze raw data.


In this course, you'll learn everything you need to know about pivot tables to work with them confidently in everyday life.


We start with the absolute basics and then build on that to learn more advanced and complex topics.


We'll talk about formatting, sorting, filtering, grouping, working with values, calculated fields, and pivot charts, and even build our own dashboard to visualize our data and manipulate and customize these charts live.


The course is designed to be hands-on. We will work with an extensive and practical example that will help you follow and understand the subject matter well. 


Our goal with this course is to make your daily work with Excel easier, and pivot tables are ideal for this.


Since pivot tables are a special sub-topic of Microsoft Excel, it is, of course, helpful if you are already familiar with the program. Ideally, you should already know the basics of Excel if you want to work with pivot tables.


We have already helped thousands of people to become office professionals in our courses, and I would be more than happy to welcome you to the course!


icon
Udemy Discount

The discount is applied through our link. Open the course from here and Udemy's current promotional price is applied at checkout on most courses, no code to type.

Some courses are excluded from Udemy's promotions. If the price does not drop, clear your browser cookies and use the button again.

icon
Instructor Details

Johannes Ruof

English Version below


Hi, ich bin Johannes.

Zusammen mit Timothy Meixner bin ich seit 2015 auf Udemy als Dozent vertreten und gehöre zu den erfolgreichsten deutschen Dozenten der Plattform.

Als offizieller Partner von Udemy konnten wir in dieser Zeit einige Erfolge verbuchen.


Unter anderem:

Den erfolgreichsten deutschsprachigen Digital Marketing Kurs aller Zeiten

Den erfolgreichsten deutschsprachigen Social Media Marketing Kurs aller Zeiten

Den erfolgreichsten deutschsprachigen SEO Kurs aller Zeiten

Den erfolgreichsten deutschsprachigen iOS Development Kurs aller Zeiten

Den erfolgreichsten deutschsprachigen Instagram Marketing Kurs aller Zeiten


Zusammen mit Timothy habe ich außerdem den offiziellen Udemy Instructor Award für das beste Dozententeam auf der gesamten Plattform erhalten.


Seit 2019 sind wir außerdem Partner der Google Zukunftswerkstatt. Auf dieser kostenfreien Plattform unterrichten wir drei Kurse und möchten so Menschen dabei helfen, die Herausforderungen des digitalen Wandels zu bewältigen.


Wir konnten bereits mehr als 78.000 Menschen dabei helfen, ihre Ziele zu erreichen und ich würde mich freuen dich in einem unserer Kurse begrüßen zu dürfen.


icon
More Excel courses

$39.99

Free

$99.99

Free

$15.99

$119.99

icon
Reviews

4.5

278 ratings on Udemy

Select a bar to show only those reviews.Select the bar again to show every rating.

By Ashlie Greene on 7/18/2026

Drawn out a bit

By Alfredo Pedroza on 4/16/2025

I like the content, the examples used, and also the focus to a clean view of data in worksheets.

By Ricardo Casiano on 12/2/2024

The trainer does a great job in explaining everything very clearly.

By Carole Weiss on 9/10/2023

Training is thorough.

By Jose Guasco on 6/29/2023

I see this course is clear so far and give good information to improve my daily work with excel. I am finding some good and realistic examples also that help us to understand better.

By Anonymized User on 5/24/2023

Very slick and well presented. Had a lot of knowledge and delivered the content I was interested in via engaging examples.

By Patricia Ann Aymond on 3/5/2023

For me this has been a very thorough refresher. The instructor is very upbeat and provides examples of everything. I appreciate his attention to detail and the many scenarios he uses to demonstrate what he is teaching.

By Pamelia Glass on 9/15/2022

This class was very thorough and the teacher explained everything clearly.

By Donaldo Diaz Madriz on 8/8/2022

Speaker sometimes gets stuck.

By Uni Vandevander on 6/5/2022

the visual walk throughs were great way to learn and practice.

Showing all 10 reviews on CourseDuck

Read all 278 reviews on Udemy

icon
Quality Score

No CourseDuck member has rated this course yet. Taken it? Give each part a thumbs up or down.

Content Quality
/
Video Quality
/
Qualified Instructor
/
Course Pace
/
Course Depth & Coverage
/

Overall Score : 90 / 100