Skip to main content
  • Login
Cart
Exceljet logo Exceljet
  • Training
  • Videos
  • Functions
  • Formulas
  • Shortcuts
  • Articles
Cart
  • Login
  • Training
  • Videos
  • Functions
  • Formulas
  • Shortcuts
  • Articles
  • Login

Pivot Table Examples

Pivot tables are the fastest and easiest way to quickly analyze data in Excel. These examples can save you time by solving common scenarios.

Quick Links

  • Overview
  • Why Pivot?
  • Tips
  • Training
Pivot table basic count

Pivot table basic count

Pivot table basic sum

Pivot table basic sum

Pivot table calculated field example

Pivot table calculated field example

Pivot table calculated item example

Pivot table calculated item example

Pivot table conditional formatting

Pivot table conditional formatting

Pivot table count birthdays by month

Pivot table count birthdays by month

Pivot table count blanks

Pivot table count blanks

Pivot table count by month

Pivot table count by month

Pivot table count by year

Pivot table count by year

Pivot table count with percentage

Pivot table count with percentage

Pivot table display items with no data

Pivot table display items with no data

Pivot table filter by weekday

Pivot table filter by weekday

Pivot table group by age

Pivot table group by age

Pivot table group by custom

Pivot table group by custom

Pivot table group by day of week

Pivot table group by day of week

Pivot table group by quarter

Pivot table group by quarter

Pivot table issue count by priority

Pivot table issue count by priority

Pivot table last 12 months

Pivot table last 12 months

Pivot table last 4 weeks

Pivot table last 4 weeks

Pivot table last 7 days

Pivot table last 7 days

Pages

  • 1
  • 2
  • next ›
Cover art for 101 Excel Functions You Should Know

Download 100+ Important Excel Functions

Get PDF Guide

just wanted to drop a line and let you know how much I absolutely LOVE your site. You break everything down so well. Even the complex things you make easy to understand. As an Excel professional myself, I find myself coming to your site for continued education.
Derrick
More Testimonials

Get Training

Quick, clean, and to the point training

Learn Excel with high quality video training. Our videos are quick, clean, and to the point, so you can learn Excel in less time, and easily review key topics when needed. Each video comes with its own practice worksheet.

View Paid Training & Bundles
Excel foundational video course
Excel Pivot Table video training course
Excel formulas and functions video training course
Excel Charts video training course
Video training for Excel Tables
Dynamic Array Formulas
Exceljet logo Exceljet
Quick, clean, and to the point

Resources

  • Training
  • Videos
  • Functions
  • Formulas
  • Shortcuts
  • Articles

About Us

  • About
  • Testimonials
  • Topics
  • Contact
  • Donate

Newsletter Sign-up

Work faster in Excel. Join more than 100,000 people who get weekly tips from us.
© 2012-2026 Exceljet. Terms of use
  • Visit our Twitter page