Data Analysis with Excel Pivot Tables

with Ned Krastev
4.8/5
(2927)

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

1 hour 19 lessons
Start course
  • Courses
  • Data Analysis with Excel Pivot Tables
19 High Quality Lessons
2 Practical Tasks
1 Hour of Content
Certificate of Achievement

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.

Topics covered

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

Student feedback

4.8/5

2927 ratings
5 stars
2516 (86%)
4 stars
337 (12%)
3 stars
62 (2%)
2 stars
8 (0%)
1 star
4 (0%)
Filter by rating
  • 5 stars
  • 4 stars
  • 3 stars
  • 2 stars
  • 1 stars
Clear all
Sort
  • Newest
  • Oldest
Clear all
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.
  • 1
  • 2
  • 3
  • ...
  • 50
  • ...
  • 98
Ned Krastev

“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

Introduction to Tableau

Introduction to Tableau

with Ned Krastev
4.8/5
(1242)
2 hours 39 lessons
Introduction to Data and Data Science

Introduction to Data and Data Science

with Martin Ganchev, Iliya Valchanov
4.8/5
(10303)
3 hours 44 lessons
Statistics

Statistics

with Iliya Valchanov
4.8/5
(3606)
5 hours 44 lessons
Mathematics

Mathematics

with Iliya Valchanov
4.8/5
(1614)
1 hour 12 lessons
Introduction to Excel

Introduction to Excel

with Ned Krastev
4.8/5
(6442)
5 hours 83 lessons
Probability

Probability

with Viktor Mehandzhiyski
4.8/5
(935)
6 hours 47 lessons
Starting a Career in Data Science: Project Portfolio, Resume, and Interview Process

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

with Ken Jee
4.8/5
(600)
4 hours 52 lessons
Power BI

Power BI

with Dimitar Shutev
4.8/5
(1742)
8 hours 76 lessons
Advanced Microsoft Excel

Advanced Microsoft Excel

with Ned Krastev, Martin Ganchev
4.8/5
(1266)
3 hours 64 lessons
Data Strategy

Data Strategy

with Bernard Marr
4.8/5
(2562)
6 hours 81 lessons
SQL for Data Science Interviews

SQL for Data Science Interviews

with Tina Huang
4.8/5
(604)
3 hours 23 lessons
Data Literacy

Data Literacy

with Olivier Maugain
4.8/5
(1377)
5 hours 58 lessons
How to Think Like a Data Scientist to Become One

How to Think Like a Data Scientist to Become One

with Harpreet Sahota
4.8/5
(599)
3 hours 21 lessons
Intro to ChatGPT and Generative AI

Intro to ChatGPT and Generative AI

with Ned Krastev
4.8/5
(3695)
1 hour 16 lessons
Data Analysis with ChatGPT

Data Analysis with ChatGPT

with Ned Krastev
4.9/5
(262)
2 hours 40 lessons

Data Analysis with Excel Pivot Tables

with Ned Krastev

Start Course