Data analysis with Excel pivot tables

Learn how to work with pivot tables and create world-class business analysis and reporting
Hours

1

 Lessons

17

 Quizzes

0

 Assignments

0

Course description

Working with pivot tables is one of the most useful data analysis capabilities in Excel. In this course, you will learn how tow work with pivot tables and you will understand their elegance in terms of reporting capabilities.

1

Introduction to pivot tables

This section is fundamental for those of you who have never used worked with pivot tables so far. We will start from the very basics: how to create a pivot table, how to modify it, how to change its formatting, and how to carry out other operations with it.

Lessons

6

 Quiz

0

 Assignments

0

Expand all
2

Building a world-class report with GETPIVOTDATA (practical exercise)

Once you are familiar with the basic pivot table operations, we will be ready to learn how to build a world-class financial report using pivot tables, the GETPIVOTDATA function, and slicers.

Lessons

11

 Quiz

0

 Assignments

0

Expand all