Data Analysis with Excel Pivot Tables
Learn how to work with pivot tables and create world-class business analysis and reporting.
with Ned Krastev
Start CourseCourse 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 Free7 Lesson 20 Min
- Building a world-class report with GETPIVOTDATA (practical exercise)12 Lesson 34 MinIntroduction 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
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
Statistics
with Iliya Valchanov
12 lessons 1 hours
Mathematics
with Iliya Valchanov
83 lessons 4 hours
Introduction to Excel
with Ned Krastev
47 lessons 4 hours
Probability
with Viktor Mehandzhiyski
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