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

Working with Pivot Tables
This course is part of Microsoft Excel for Beginners Professional Certificate

Instructor: Microsoft
Included with Learn more
Gain insight into a topic and learn the fundamentals.
Beginner level
Recommended experience
4 hours to complete
Flexible schedule
Learn at your own pace
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.
Details to know

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

Build your Business Essentials expertise
This course is part of the Microsoft Excel for Beginners Professional Certificate
When you enroll in this course, you'll also be enrolled in this Professional Certificate.
- Learn new concepts from industry experts
- Gain a foundational understanding of a subject or tool
- Develop job-relevant skills with hands-on projects
- Earn a shareable career certificate from Microsoft

Explore more from Business Essentials
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."
Advance your career with an online degree
Earn a degree from world-class universities - 100% online






