Data Analysis with Excel Pivot Tables
free
Learn how to work with Excel pivot tables and create world-class reports, interactive dashboards, and insightful analyses
Start for Free
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
free
Start for Free
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
Start for Free
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
- Understand how to build and use basic Excel pivot tables.
- Improve accuracy and confidence using pivot tables.
- Clean and organize data effectively before analysis.
- Format data professionally for clear pivot table reports.
- Use slicers and pivot tables to generate actionable insights.
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

1.1 Introduction to the course
1 min

1.2 Intro to Pivot tables
2 min

1.3 Editing a Pivot table
4 min

1.5 Formatting a Pivot table
2 min

1.6 Adjusting a Pivot table
4 min

1.8 GETPIVOTDATA
3 min
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
Course Requirements
- Microsoft Excel (any recent version, such as Excel 2019, 2021, or Microsoft 365)
- Basic familiarity with Excel
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 Financial Analyst Course Certificate is an excellent addition to your LinkedIn profile—demonstrating your expertise and willingness to go the extra mile to accomplish your goals.

Meet Your Instructor
Ned Krastev is an entrepreneur and educator who has helped over 1.6 million students worldwide gain business, finance, and data skills. After earning his Master's degree in Finance from Bocconi University in Milan, he built a career with leading companies including PwC Italy, Coca-Cola European Partners, and Infineon Technologies. In 2014, Ned published his first online course on financial modeling and valuation, sparking his passion for online education. Today, as Founder & CEO of 365 Careers and Co-founder of 365 Data Science, he leads one of the most successful global providers of professional training, aiming to bridge the gap between academic theory and real-world business application.
What Our Learners Say
365 Financial Analyst Is Featured at
Our top-rated courses are trusted by business worldwide.
