Office Fundamentals - PivotTables in Microsoft Excel

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


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

Requirements
A PC
Microsoft Excel

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!
Who this course is for:
Excel beginners
Advanced Excel users

More Info