Microsoft

Working with Pivot Tables

Microsoft

Working with Pivot Tables

 Microsoft

Instructor: Microsoft

Included with Coursera PlusLearn 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
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

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

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

There are 3 modules in this course

In this module, you will learn how to create dynamic data blocks using Excel tables, allowing for flexible data organization and analysis. You will learn to create, name, manage, and modify tables, apply formulas within tables, and use table formatting to improve readability.

What's included

3 videos2 readings2 assignments

In this module, you will learn how to create PivotTables, a powerful feature for summarizing and analyzing large datasets efficiently. You will learn what a pivot is, how to work with PivotTables, and how to customize results to answer specific business questions.

What's included

3 videos1 reading3 assignments

In this module, you will learn how to leverage PivotTables and slicers to create dynamic reports that adapt to changing data inputs. You will explore the Show Values As feature, slicers and timelines, the GETPIVOTDATA function, and calculated fields to enhance your reporting capabilities.

What's included

3 videos2 readings3 assignments

Earn a career certificate

Add this credential to your LinkedIn profile, resume, or CV. Share it on social media and in your performance review.

Instructor

 Microsoft
446 Courses2,934,369 learners

Offered by

Microsoft

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