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

Pivot table basic count

Pivot table basic sum

Pivot table calculated field example

Pivot table calculated item example

Pivot table conditional formatting

Pivot table count birthdays by month

Pivot table count blanks

Pivot table count by month

Pivot table count by year

Pivot table count with percentage

Pivot table display items with no data

Pivot table filter by weekday

Pivot table group by age

Pivot table group by custom

Pivot table group by day of week

Pivot table group by quarter

Pivot table issue count by priority

Pivot table last 12 months

Pivot table last 4 weeks

Pivot table last 7 days

Pivot table latest values

Pivot table list unique values

Pivot table month over month

Pivot table months with no data

Pivot table most frequently occurring

Pivot table project estimate

Pivot table rank example

Pivot table remove deleted items

Pivot table running total

Pivot table show duplicates

Pivot table show top 3 values

Pivot table sum by month

Pivot table two-way average

Pivot table two-way count

Pivot table two-way sum

Pivot table unique count

Pivot table year over year

Pivot table year over year by month

Cover art for 101 Excel Functions You Should Know

Download 100+ Important Excel Functions

I have to say that I knew practically nothing about Excel when I started using VBA about 6 years ago. However, your newsletter (weekly), which I started using about four years ago has really allowed me to appreciate Excel - I don't use VBA because of the learning from your site/weekly email. Thank you for being such an amazing teacher.

Adrian

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