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
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
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!
Instructor Details
- 4.5 Rating
278 Reviews
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.
More Excel courses
Microsoft Excel Data Analysis - Learn How The Experts Use It (2026)
5.0 (5,696 Reviews)
Provider: Udemy
Time: 3h
$39.99
Microsoft Excel: Advanced Dashboard Design (Project-Based!) (2026)
4.9 (4,868 Reviews)
Provider: Udemy
Time: 6.4h
$99.99
Master NEW Excel Functions in Office 365 & Office 2021+
4.8 (5,262 Reviews)
Provider: Udemy
Time: 7.1h
$15.99
Microsoft Excel Certification Exam Prep: MO-201 Excel Expert (2026)
4.8 (3,239 Reviews)
Provider: Udemy
Time: 8.6h
$119.99
Reviews
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.
Quality Score
No CourseDuck member has rated this course yet. Taken it? Give each part a thumbs up or down.
Overall Score : 90 / 100






