Data Analysis with Excel Pivot Tables

with Ned Krastev

4.8/5

(1937)

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

19 lessons 1h

Start course

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 Hour 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

Student feedback

4.8/5

1937 ratings

5 stars

1661 (86%)

4 stars

217 (11%)

3 stars

51 (3%)

2 stars

5 (0%)

1 star

3 (0%)

Fritz Nanab

06.01.2023

I am thoroughly impressed with the material and the instructor. The course is well-structured and easy to follow, covering everything from basic spreadsheet formatting and organization to more advanced functions and formulas. The instructor was knowledgeable and patient, taking the time to explain concepts in detail and providing helpful tips and tricks along the way. One of the things I appreciated most about the course was the variety of exercises and projects that were included. These allowed me to practice what I had learned and apply the skills to real-world situations.

Ogundiji Tomisin

17.11.2022

Well, it's a great course and I learned something new. But I'll prefer if the practical aspect and dataset used would be one that everyone can relate to - whether an economist or not or an accountant or not. I didn't relate well with the practical aspect because I didn't understand those net sales and so on. That wasn't my scope of study in school so I didn't really get along well (or maybe the course can be renamed to "Data Analysis with Pivot Tables For Financial Analysts", lol). But all the same, thanks so much to the instructor. You did a great job. God bless.

Timothy Zajac

13.11.2022

Good information and the presentation style of little chunks is good. These courses don't suit my learning style. It isn't at all clear how these courses work in general. Having to download multiple Excel spreadsheets to practice each task is insane, not to mention that I have to go back to watch the video multiple times to execute the task. The timed practice exams are frustrating- a newcomer can't execute the task and answer questions in the time allotted. I would not pay to have access to these courses.

Rafael Rodrigues de Siqueira

06.09.2022

I was going to vote 3 stars as I was also expecting to see some charts made at the end. But I will give 4 stars and only leave it as a comment, as I could be wrong expecting charts in this contents. I know there is a topic on data visualization where this is taught, but also it wouldn't make this course any uninteresting for having it in here nonetheless. On the contrary, it would have been more complete.

Steven Klassen

24.11.2022

The course is well put together and easy to follow! My only recommendation is to add a bit of a sanity-check quiz question at the end of every couple videos to make sure I absorbed the material. DataQuest did this will, but I switched from them for the quality of the video content.