Develop advanced Microsoft Excel skills for organizing, summarizing, and reporting on large datasets. In this course, you will learn to create and manage dynamic Excel tables, apply formulas within tables, and use formatting to improve data organization and readability. You will also learn to create and customize PivotTables to efficiently summarize data and answer business questions. Building on these skills, you will use PivotTables, slicers, timelines, GETPIVOTDATA, and calculated fields to create dynamic reports that adapt to changing data. By the end of the course, you will be able to structure large datasets and create flexible, interactive reports that support data analysis and business decision-making.

Working with Pivot Tables

What you'll learn
Create a dynamic data block using tables in Microsoft Excel.
Create a PivotTable in Microsoft Excel.
Use PivotTables and slicers to create a dynamic report in Microsoft Excel.  Â
Skills you'll gain
Tools you'll learn
Details to know

Shareable certificate
Add to your LinkedIn profile
Assessments
8 assignments
Taught in English
Recently updated!
September 2026
See how employees at top companies are mastering in-demand skills

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."





