10.02.2025
Data Analysis with Excel Pivot Tables
with
Ned Krastev
Learn how to work with Excel pivot tables and create world-class reports, interactive dashboards, and insightful analyses
2 hours of content
39278 students
$99.00
Lifetime access
14-Day Money-Back Guarantee
What you get:
- 2 hours of content
- 7 Interactive exercises
- 23 Downloadable resources
- World-class instructor
- Closed captions
- Q&A support
- Future course updates
- Course exam
- Certificate of achievement
Data Analysis with Excel Pivot Tables
A course by
Ned Krastev
$99.00
Lifetime access
14-Day Money-Back Guarantee
What you get:
- 2 hours of content
- 7 Interactive exercises
- 23 Downloadable resources
- World-class instructor
- Closed captions
- Q&A support
- Future course updates
- Course exam
- Certificate of achievement
$99.00
Lifetime access
$99.00
Lifetime access
14-Day Money-Back Guarantee
What you get:
- 2 hours of content
- 7 Interactive exercises
- 23 Downloadable resources
- World-class instructor
- Closed captions
- Q&A support
- Future course updates
- Course exam
- Certificate of achievement
What You Learn
- Master foundational skills for creating basic pivot tables in Excel
- Enhance accuracy and confidence with pivot table precision
- Boost data management by thoroughly cleaning and organizing before pivot table analysis
- Produce professional-looking reports through expert data formatting
- Generate clear reports using Excel for data analysis via pivot tables and slicers
- Develop proficiency in using data analysis Excel pivot tables
Top Choice of Leading Companies Worldwide
Industry leaders and professionals globally rely on this top-rated course to enhance their skills.
Course Description
Learn for Free
![Introduction to the course](https://cf-images.eu-west-1.prod.boltdns.net/v1/jit/6258000438001/ee652074-e8eb-4a04-9aa8-47fd03d7a0c0/main/1280x720/16s439ms/match/image.jpg)
1.1 Introduction to the course
1 min
![Intro to Pivot tables](https://cf-images.eu-west-1.prod.boltdns.net/v1/jit/6258000438001/a305cfdd-b0cf-4842-b3fc-7b71446a8805/main/1280x720/45s70ms/match/image.jpg)
1.2 Intro to Pivot tables
2 min
![Editing a Pivot table](https://cf-images.eu-west-1.prod.boltdns.net/v1/jit/6258000438001/68e8ef0b-f5cf-46f4-9e44-d31c8ae54066/main/1280x720/1m45s140ms/match/image.jpg)
1.3 Editing a Pivot table
4 min
![Formatting a Pivot table](https://cf-images.eu-west-1.prod.boltdns.net/v1/jit/6258000438001/7dabdf19-097a-49fe-9041-0fdd0beca9f1/main/1280x720/58s619ms/match/image.jpg)
1.5 Formatting a Pivot table
2 min
![Adjusting a Pivot table](https://cf-images.eu-west-1.prod.boltdns.net/v1/jit/6258000438001/d021adf4-8a6a-41d1-846e-150a54f15f54/main/1280x720/2m8s116ms/match/image.jpg)
1.6 Adjusting a Pivot table
4 min
![GETPIVOTDATA](https://cf-images.eu-west-1.prod.boltdns.net/v1/jit/6258000438001/83e9ba13-d901-431e-a496-afa7150a4540/main/1280x720/1m44s106ms/match/image.jpg)
1.8 GETPIVOTDATA
3 min
Interactive Exercises
Practice what you've learned with coding tasks, flashcards, fill in the blanks, multiple choice, and other fun exercises.
Practice what you've learned with coding tasks, flashcards, fill in the blanks, multiple choice, and other fun exercises.
![fill-blank-selection exercise](https://365datascience.com/resources/assets/images/fill-blank-selection.webp)
![order exercise](https://365datascience.com/resources/assets/images/order.webp)
![categorize exercise](https://365datascience.com/resources/assets/images/categorize.webp)
![true-false exercise](https://365datascience.com/resources/assets/images/true-false.webp)
![single-choice exercise](https://365datascience.com/resources/assets/images/single-choice.webp)
![multiple-choice exercise](https://365datascience.com/resources/assets/images/multiple-choice.webp)
![flashcards exercise](https://365datascience.com/resources/assets/images/flashcards.webp)
![fill-blank-typing exercise](https://365datascience.com/resources/assets/images/fill-blank-typing.webp)
Curriculum
- 2. Building a world-class report with GETPIVOTDATA (practical exercise)12 Lessons 34 MinOnce 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 study2 minWorking with an SAP data extraction3 minPreliminary mapping of the data extraction2 minCreating an output structure of the FMCG model2 minImproving the layout and appearance of the FMCG report4 minInserting formulas and automating calculations2 minCreating a Master Pivot Table: The main data source for the FMCG report2 minGetPivotData is great! Extracting data from the Master Pivot Table6 minGETPIVOTDATA - fix1 minCombining Slicers and GetPivotData: The key to our success3 minGetting fancy with Excel slicers3 minThis is how the report can be used in practice by high-level executives4 min
Topics
TheoryExcelData AnalysisSpreadsheetsData AnalysisFinance Skills
Course Requirements
- Highly recommended to take the Intro to Excel course first
- You will need Microsoft Excel 2016, 2020, or Microsoft Excel 365
Who Should Take This Course?
Level of difficulty: Intermediate
- Beginner and intermediate Excel students
- Aspiring financial analysts and data analysts
- Graduate students who want to learn how to work with Excel pivot tables professionally
Exams and Certification
A 365 Data Science Course Certificate is an excellent addition to your LinkedIn profile—demonstrating your expertise and willingness to go the extra mile to accomplish your goals.
![Exams and certification](https://365datascience.com/resources/assets/images/exams-and-certification-ds.webp)
Meet Your Instructor
![Ned Krastev](https://365datascience.com/resources/team/ouhwo6me6ea-nedko.jpg)
Nedko earned a Master’s degree in Finance from Bocconi University (Milan, Italy) in 2012. Then, he gained valuable working experience with exciting firms like PwC Italy (Financial Advisory and M&A), Coca-Cola European Partners (Financial Analyst), and Infineon Technologies (M&A). In 2014, he published his first online course on financial modeling and valuation when he realized that creating educational materials is his true calling. The amazing students and content creators in the data science community, the 365 team, and the strong desire to build the perfect learning platform drive Nedko to continue on this exciting journey. His goal is to establish 365 Data Science as the learning platform that bridges the gap between theoretical knowledge and practical business application.
What Our Learners Say
365 Data Science Is Featured at
Our top-rated courses are trusted by business worldwide.