What should I practice after reading this tutorial?

Rebuild the main example on a copy of your file, then change one argument at a time to see how the result changes. That builds muscle memory faster than rereading the steps.

Which Excel version do I need for the formulas in this article?

Most steps work in Excel 2016 and later. If the article mentions FILTER, UNIQUE, or XLOOKUP, you need Microsoft 365 or Excel 2021 — check the linked function pages for compatibility.

Why does my Pivot Table show wrong totals?

Refresh the pivot, confirm the source includes new rows (use an Excel Table), and check that numbers are not stored as text.

Tutorials - 2026-01-21

How to Create Your First Pivot Table (Step-by-Step)

New to Pivot Tables? This beginner-friendly guide walks you through creating your first Pivot Table in Excel with clear steps and examples.

Your First Pivot Table in 5 Minutes

Pivot Tables look intimidating, but they're actually easy once you understand the basics. This guide will have you creating your first Pivot Table in just 5 minutes. For the complete guide, see Excel Pivot Tables: Complete Guide.

What You'll Learn

By the end of this tutorial, you'll be able to: Create a Pivot Table from any dataset Summarize data by categories Change calculations (Sum, Count, Average) Sort and filter your results

Step 1: Prepare Your Data

Your data needs to be in a simple table format. Requirements: ✅ Headers in the first row ✅ No blank rows or columns ✅ Each column has one type of data Example Data: Date Salesperson Region Product Amount 1/5/2024 John North Widget A 500 1/5/2024 Sarah South Widget B 750 1/6/2024 John North Widget A 600 1/6/2024 Mike East Widget C 450 1/7/2024 Sarah South Widget A 800

Step 2: Select Your Data

\\\ Click any cell inside your data Excel will auto-detect the entire range (Or manually select all your data including headers) \\\ Tip: If your data is in an Excel Table (Ctrl+T), Pivot Tables work even better!

Step 3: Insert the Pivot Table

\\\ Go to Insert tab Click PivotTable (first button on the left) A dialog box appears \\\ In the dialog: Table/Range: Should show your data (auto-detected) Location: Choose "New Worksheet" (recommended for beginners) Click OK

Step 4: Meet the PivotTable Field List

A new sheet appears with: An empty Pivot Table area on the left The Field List panel on the right The Field List has two parts: Top: Your column names (fields) Date Salesperson Region Product Amount Bottom: Four areas to drag fields into Filters — Filter the whole report Columns — Column headers Rows — Row labels Values — Numbers to calculate

Step 5: Build Your First Report

Let's create a simple report: Total Sales by Salesperson \\\ Drag "Salesperson" to the ROWS area Drag "Amount" to the VALUES area \\\ Result: Row Labels Sum of Amount John 1,100 Mike 450 Sarah 1,550 Grand Total 3,100 🎉 Congratulations! You just created your first Pivot Table!

Step 6: Add More Detail

Let's break it down by Region too: \\\ Drag "Region" to the COLUMNS area \\\ Result: East North South Grand Total John 1,100 1,100 Mike 450 450 Sarah 1,550 1,550 Grand Total 450 1,100 1,550 3,100 Now you can see each salesperson's performance by region!

Changing the Calculation

By default, Pivot Tables SUM numbers. But you can change this: \\\ Click any number in the Pivot Table Right-click → Value Field Settings Choose: Count, Average, Max, Min, etc. Click OK \\\ Example calculations: Sum — Total sales amount Count — Number of transactions Average — Average sale size Max — Largest sale

Sorting Your Results

To sort from highest to lowest: \\\ Click any cell in the "Sum of Amount" column Right-click → Sort → Largest to Smallest \\\ Now your top performers are at the top!

Filtering Data

Quick Filter \\\ Click the dropdown arrow next to "Row Labels" Uncheck items you want to hide Click OK \\\ Using the Filters Area \\\ Drag "Product" to the FILTERS area A dropdown appears above the Pivot Table Select which products to include \\\

Refreshing Your Pivot Table

When your source data changes: \\\ Right-click anywhere in the Pivot Table → Refresh Or: Keyboard shortcut Alt + F5 \\\ Important: Pivot Tables don't update automatically. You must refresh them!

Rearranging Fields

The beauty of Pivot Tables is flexibility: Drag fields between areas to change the layout Remove a field by dragging it out of the area Reorder fields by dragging within an area Try this: \\\ Drag "Region" from Columns to Rows See how the layout changes! Drag it back to Columns \\\

Common Beginner Mistakes

Mistake 1: Data Has Blank Rows Problem: Pivot Table only includes data above the blank row Fix: Delete blank rows before creating Pivot Table Mistake 2: Headers Are Missing Problem: Excel uses "Column1", "Column2" as field names Fix: Add descriptive headers to every column Mistake 3: Mixed Data Types Problem: Numbers show as Count instead of Sum Fix: Ensure number columns contain only numbers (no text) Mistake 4: Forgetting to Refresh Problem: Pivot Table shows old data Fix: Right-click → Refresh after changing source data

Practice Exercise

Using this sample data: Month Category Sales Jan Electronics 5000 Jan Clothing 3000 Feb Electronics 5500 Feb Clothing 3200 Mar Electronics 6000 Mar Clothing 3500 Create these reports: Total Sales by Category Rows: Category Values: Sum of Sales Sales by Month and Category Rows: Month Columns: Category Values: Sum of Sales Average Sales by Category Rows: Category Values: Average of Sales

Next Steps

Now that you've created your first Pivot Table, learn more: Excel Pivot Tables: Complete Guide Pivot Table Calculated Fields Pivot Table Slicers and Timelines Common Pivot Table Mistakes

Apply this tutorial in your workbook

Copy one example from this article into a blank sheet. Change the sample ranges to match your column letters. Press F2 and Enter after edits so Excel recalculates. Compare your result to the expected output in the article. Related hubs: Excel functions directory · Formula guides · Function comparisons \nPivot help: Pivot tables guide · Pivot not updating · Pivot mistakes

Frequently asked questions

What should I practice after reading this tutorial? Rebuild the main example on a copy of your file, then change one argument at a time to see how the result changes. That builds muscle memory faster than rereading the steps.
Which Excel version do I need for the formulas in this article? Most steps work in Excel 2016 and later. If the article mentions FILTER, UNIQUE, or XLOOKUP, you need Microsoft 365 or Excel 2021 — check the linked function pages for compatibility.
Why does my Pivot Table show wrong totals? Refresh the pivot, confirm the source includes new rows (use an Excel Table), and check that numbers are not stored as text.