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
Data Analysis with Excel Pivot Tables
with Ned Krastev