Data Analysis with Excel Pivot Tables

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

Course Overview

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

19 High Quality Lessons

2 Practical Tasks

1 Hours of Video

Certificate of Achievement

Skills you will gain

data analysisexceltheory

What You'll Learn

Pivot tables are essential when working with Excel. This course will teach you how to:

Create and modify pivot tables

Carry out various pivot table operations

How to build a world-class financial report

Curriculum

Introduction to pivot tables Free

7 Lessons 20 Min

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.
Introduction to the course Free Intro to Pivot tables Free Editing a Pivot table Free Formatting a Pivot table Free Adjusting a Pivot table Free GETPIVOTDATA Free Slicers Free
Building a world-class report with GETPIVOTDATA (practical exercise)

12 Lessons 34 Min

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.
Introduction to the case study Working with an SAP data extraction Preliminary mapping of the data extraction Creating an output structure of the FMCG model Improving the layout and appearance of the FMCG report Inserting formulas and automating calculations Creating a Master Pivot Table: The main data source for the FMCG report GetPivotData is great! Extracting data from the Master Pivot Table GETPIVOTDATA - fix Combining Slicers and GetPivotData: The key to our success Getting fancy with Excel slicers This is how the report can be used in practice by high-level executives

“This course is entirely focused on teaching you how to use one of Excel’s most powerful and user-friendly tools - pivot tables. But I will also take you a few steps further and combine pivot tables with slicers using the gap pivot table function, providing you with the skills you need to build world-class business intelligence reports.”

Ned Krastev

CEO at 365 Data Science

Courses You May Like

40 lessons 2 hours

Introduction to Tableau

with Ned Krastev

44 lessons 2 hours

Introduction to Data and Data Science

with Martin Ganchev, Iliya Valchanov

44 lessons 3 hours

12 lessons 1 hours

83 lessons 4 hours

Introduction to Excel

with Ned Krastev

47 lessons 4 hours

Probability

with Viktor Mehandzhiyski

52 lessons 4 hours

Starting a Career in Data Science: Project Portfolio, Resume, and Interview Process

with Ken Jee

76 lessons 8 hours

Power BI

with Dimitar Shutev

64 lessons 2 hours

Advanced Microsoft Excel

with Ned Krastev, Martin Ganchev

81 lessons 5 hours

Data Strategy

with Bernard Marr

23 lessons 2 hours

SQL for Data Science Interviews

with Tina Huang

58 lessons 4 hours

Data Literacy

with Olivier Maugain

Data Analysis with Excel Pivot Tables

with Ned Krastev

Start Course