Excel for Beginners: Pivot Tables

Excel for Beginners: Pivot Tables

Instructor: Edward Falzon

What you'll learn

Analyze and summarize data instantly with user-friendly features for pivot tables.
Apply pivot tables in different scenarios using some advanced settings.
Format data generated from the pivot tables into visual graphs for easy readability.

Details to know

Shareable certificate

Add to your LinkedIn profile

Taught in English

No downloads or installation required

Only available on desktop

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

Learn more about Coursera for Business

Learn, practice, and apply job-ready skills in less than 2 hours

Receive training from industry experts
Gain hands-on experience solving real-world job tasks
Build confidence using the latest tools and technologies

About this Guided Project

This 1-hour, project-based course introduces learners to the powerful pivot table feature of most spreadsheet applications. We’ll be using Excel on the Web in this project, which is the free spreadsheet application offered by Microsoft. However, many of the concepts that you will learn in this project will be applicable to other spreadsheet programs, such as LibreOffice Calc and Google Sheets.

We will cover the following concepts in a hands-on manner: - Introduction to the functionality of pivot tables. - Application of pivot tables to quickly summarize large amounts of raw data in detail. - Visualize generated data from pivot tables for accessible information at a glance using charts. Please Note: If you don't have a free Microsoft account, you will need to create one to be able to complete the content.

Learn step-by-step

In a video that plays in a split-screen with your work area, your instructor will walk you through these steps:

Introduction and Logging in
Create our First Pivot Table
Create a Pivot Table of Customers
Design a good format and presentation for a Pivot Table
Try it yourself
Group Sales into Date Ranges
Create Charts from Pivot Tables
Capstone

Recommended experience

Working knowledge of any spreadsheet application. Completion of one or more Excel for Beginners guided projects is recommended for new users.

8 project images

Instructor

Instructor ratings

4.6 (8 ratings)

Edward Falzon

Coursera Project Network

7 Courses49,104 learners

Offered by

Coursera Project Network

How you'll learn

Skill-based, hands-on learning
Practice new skills by completing job-related tasks.
Expert guidance
Follow along with pre-recorded videos from experts using a unique side-by-side interface.
No downloads or installation required
Access the tools and resources you need in a pre-configured cloud workspace.
Available only on desktop
This Guided Project is designed for laptops or desktop computers with a reliable Internet connection, not mobile devices.

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

Learner reviews

4.6

120 reviews

5 stars
69.42%
4 stars
25.61%
3 stars
2.47%
2 stars
0%
1 star
2.47%

Showing 3 of 120

Reviewed on May 24, 2023

Very informative and useful course regarding pivot tables and charts. I just felt that the instructor took a lot of time on formatting of the table. Otherwise it was pretty good.

Reviewed on Apr 3, 2023

Either the course was out dated or the cloud EXCEL works differently with Macs. I did not have the ability to resize the charts.

Reviewed on Nov 21, 2024

A good course but I am using a different version so not all instructions in the video worked. My issue was already on the forum and had been unanswered for months.

View more reviews