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.
18 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) Free11 Lesson 33 MinIntroduction to the case study Free Working with an SAP data extraction Free Preliminary mapping of the data extraction Free Creating an output structure of the FMCG model Free Improving the layout and appearance of the FMCG report Free Inserting formulas and automating calculations Free Creating a Master Pivot Table: The main data source for the FMCG report Free GetPivotData is great! Extracting data from the Master Pivot Table Free Combining Slicers and GetPivotData: The key to our success Free Getting fancy with Excel slicers Free This is how the report can be used in practice by high-level executives Free
“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 Iliya Valchanov, Martin Ganchev
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 Martin Ganchev, Ned Krastev
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