Course
Working with PivotTables 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.
Updated Apr 10, 2025 · 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.
Learn Excel with DataCamp
2 hr
67.6K
Course
Data Analysis in Excel
3 hr
87.3K
Course
Power Pivot in Excel
3 hr
7.1K
See More
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
Excel Table: The Essential Tool for Organizing Data
Discover how Excel tables go beyond formatting with powerful features like structured references, automatic expansion, filtering, and integration with PivotTables and charts.
Javier Canales Luna
9 min
Tutorial
SQL Pivot Rows to Columns: A Comprehensive Guide
Learn the art of pivoting rows into columns in SQL in Oracle, MySQL, and SQL Server. Explore practical methods with detailed examples to boost your data engineering skills.
Allan Ouko
9 min
Tutorial
Creating and Customizing Pivot Tables in Power BI
Learn how to create customizable pivot tables in Power BI with advanced conditional formatting and some optimization tips.
Joleen Bothma
9 min
Tutorial
PivotTable Conditional Formatting: Two Good Methods
Learn two reliable methods for applying PivotTable conditional formatting and avoid common pitfalls.
Elena Kosourova
7 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