Office Fundamentals PivotTables in Microsoft Excel

Learn everything about creating and using PivotTables in Excel to analyze data and plot with PivotCharts & dashboards
Office Fundamentals PivotTables in Microsoft Excel
File Size :
4.28 GB
Total length :
5h 43m


Johannes Ruof


Last update




Office Fundamentals PivotTables in Microsoft Excel

What you’ll 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

Office Fundamentals PivotTables in Microsoft Excel


Microsoft Excel


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!


Section 1: Einführung

Lecture 1 Welcome to the course!

Lecture 2 Why PivotTables? What are they good for?

Section 2: PivotTable Fundamentals – Learning the basics

Lecture 3 Overview and download of the example data file

Lecture 4 Structuring the source data

Lecture 5 Creating and inserting PivotTables in Microsoft Excel

Lecture 6 The PivotTable fields explained

Lecture 7 PivotTable tabs in the Excel ribbon

Lecture 8 PivotTable actions and how we can use them

Lecture 9 Refreshing and Changing the data source for PivotTables

Lecture 10 Tips for working with growing source data

Lecture 11 The PivotTable Cache explained

Lecture 12 Pro tip for generating filtered subsets of data

Section 3: Formatting PivotTables

Lecture 13 Intro – Formatting PivotTables

Lecture 14 Number formatting with PivotTables

Lecture 15 Table layout and customizing the view

Lecture 16 Using tabular layout to create exportable data sets

Lecture 17 Creating custom PivotTable styles

Lecture 18 Changing labels inside of a PivotTable

Lecture 19 Conditional formatting to show the highest values

Lecture 20 Highlighting top and bottom values using conditional formatting

Lecture 21 Visualization with data bars

Lecture 22 Visualization with icon sets and color scales

Lecture 23 Conditional formatting specifically for PivotTables

Lecture 24 Preventing PivotTables from resizing on update

Section 4: Sorting, Filtering and Grouping with PivotTables

Lecture 25 Intro – Sorting, Filtering and Grouping

Lecture 26 Overview of the different sorting options

Lecture 27 Sorting by custom lists

Lecture 28 Filtering with manual selections and label filters

Lecture 29 Pro tip for faster manual selection filters

Lecture 30 Filtering with wildcards

Lecture 31 Using value filters

Lecture 32 Using multiple filters simultaneously

Lecture 33 Creating custom groups in a PivotTable

Lecture 34 Automatic date grouping and options

Lecture 35 Visual filtering using slicers

Lecture 36 Visual date filtering using timelines

Lecture 37 Creating and showing report filter pages

Section 5: Working with values in PivotTables

Lecture 38 Intro – Working with values

Lecture 39 Summarizing values by different methods

Lecture 40 “Show values as…” options

Lecture 41 Show values as % of parent total

Lecture 42 Show values as difference

Lecture 43 Show values as running totals

Lecture 44 Show values as rank

Lecture 45 Visual improvements for large PivotTables

Lecture 46 Show values as index with example

Section 6: Working with calculated fields in PivotTables

Lecture 47 Intro – Calculated Fields

Lecture 48 Using calculated fields in PivotTables

Lecture 49 Using count in calculated fields

Section 7: Visualizing data analysis with PivotCharts & Dashboards

Lecture 50 Intro – PivotCharts and Dashboards

Lecture 51 Creating PivotCharts

Lecture 52 Pie Charts and using multiple PivotCharts

Lecture 53 Visually improving PivotCharts

Lecture 54 Multiple dimensions in PivotCharts

Lecture 55 Filtering PivotCharts using timelines and slicers

Lecture 56 Creating a dashboard from PivotCharts

Lecture 57 Visually improving the dashboard

Lecture 58 Printing the dashboard

Excel beginners,Advanced Excel users

Course Information:

Udemy | English | 5h 43m | 4.28 GB
Created by: Johannes Ruof

You Can See More Courses in the Office Productivity >> Greetings from

New Courses

Scroll to Top