# Working with Pivot Tables in Excel

Learn how to organize rows and columns, add values, find the sum of a value, and apply filtering to select a subset of a given dataset. We’ll learn how to apply this in Excel with a retail dataset example.

Mar 16, 2023 · 9 min read

## Learn Excel Fundamentals

Gain skills to use Excel effectively—no experience required.

## Advance Your Career with Excel

Gain the skills to maximize Excel—no experience required.

RelatedSee MoreSee More

tutorial

### Pivot Tables in Spreadsheets

Learn how to organize rows and columns, add values, find the sum of revenue, and finally apply filtering to select a subset of data from a given dataset.

Aditya Sharma

10 min

tutorial

### How to Use SQL PIVOT

Enhance your SQL skills with the SQL PIVOT operator. Learn to convert rows into columns to create pivot tables in SQL Server and Oracle.

Allan Ouko

10 min

tutorial

### Visualizing Data in Excel

Learn about Excel's various data visualization options that can help you analyze and interpret your data.

Jess Ahmet

12 min

tutorial

### Spreadsheets with Tableau

In this tutorial, you will learn how to analyze and display spreadsheet data using Tableau and make more data-driven decisions.

Parul Pandey

14 min

tutorial

### Getting Started with Spreadsheets

This tutorial will give you a basic understanding of the terminology in spreadsheets along with learning how to create a basic table.

Ryan Sheehy

5 min

code-along

### Visualizing Sales Data with PivotCharts in Excel

In this code along, we delve into the world of data analysis and visualization using PivotCharts and PivotTables on a sales dataset.

Agata Bak-Geerinck