Learn everything about creating and using PivotTables in Excel to analyze data and plot with PivotCharts & dashboards
Pivot tables are a quick and easy way to organize, summarize, and analyze raw data.
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.
Course Content
- Einführung –> 2 lectures • 4min.
- PivotTable Fundamentals – Learning the basics –> 10 lectures • 1hr 18min.
- Formatting PivotTables –> 12 lectures • 1hr 8min.
- Sorting, Filtering and Grouping with PivotTables –> 13 lectures • 1hr 15min.
- Working with values in PivotTables –> 9 lectures • 52min.
- Working with calculated fields in PivotTables –> 3 lectures • 15min.
- Visualizing data analysis with PivotCharts & Dashboards –> 9 lectures • 53min.
Requirements
- A PC.
- 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!