Packt

Excel Pivot Tables & Analysis

Packt

Excel Pivot Tables & Analysis

Included with Coursera PlusLearn more

Ask Coursera

Gain insight into a topic and learn the fundamentals.
Intermediate level

Recommended experience

5 hours to complete
Flexible schedule
Learn at your own pace
Gain insight into a topic and learn the fundamentals.
Intermediate level

Recommended experience

5 hours to complete
Flexible schedule
Learn at your own pace

What you'll learn

  • Build advanced Pivot Tables using grouping, filtering, slicers, timelines, and calculated fields for analysis.

  • Visualize complex datasets and convert raw spreadsheet information into actionable business insights.

  • Analyze marketing campaign performance, ROI, budgets, engagement, and click-through metrics using Excel.

Details to know

Shareable certificate

Add to your LinkedIn profile

Recently updated!

July 2026

Assessments

5 assignments

Taught in English

See how employees at top companies are mastering in-demand skills

 logos of Petrobras, TATA, Danone, Capgemini, P&G and L'Oreal

There are 4 modules in this course

In this module, we will explore the foundational concepts of Excel Pivot Tables and learn how to build interactive reports from raw datasets. We will work with sorting, filtering, grouping, and multi-category analysis techniques to organize and summarize information effectively. By the end of this module, you will be able to create well-structured Pivot Tables for practical business reporting and analysis.

What's included

12 videos

In this module, we will build upon foundational Pivot Table knowledge by exploring more advanced analytical and interactive features. We will use grouping tools, slicers, and timelines to create flexible reports and improve data exploration capabilities. Through practical exercises and assignments, you will strengthen your ability to analyze and present business data efficiently.

What's included

7 videos1 assignment

In this module, we will focus on advanced Pivot Table calculations and analytical techniques used for deeper business intelligence. We will explore percentage-based calculations, data distribution analysis, and visualization methods for handling complex datasets. By the end of this module, you will be equipped to generate actionable insights and present advanced analytical reports with confidence.

What's included

5 videos1 assignment

In this module, we will apply Pivot Table concepts to a complete marketing analytics project using real-world business scenarios. We will analyze campaign performance metrics, engagement trends, budget allocation, ROI, and audience targeting through practical reporting exercises. By the end of this module, you will be able to transform raw marketing data into meaningful business intelligence and actionable insights.

What's included

12 videos3 assignments

Instructor

Packt - Course Instructors
Packt
2,023 Courses611,541 learners

Offered by

Packt

Explore more from Data Analysis

Why people choose Coursera for their career

Felipe M.

Learner since 2018
"To be able to take courses at my own pace and rhythm has been an amazing experience. I can learn whenever it fits my schedule and mood."

Jennifer J.

Learner since 2020
"I directly applied the concepts and skills I learned from my courses to an exciting new project at work."

Larry W.

Learner since 2021
"When I need courses on topics that my university doesn't offer, Coursera is one of the best places to go."

Chaitanya A.

"Learning isn't just about being better at your job: it's so much more than that. Coursera allows me to learn without limits."

Frequently asked questions