Most people who tell me they “don’t really get pivot tables” actually do get them. They can drag a field into Rows and another into Values and produce a total. Where it falls apart is the second week — new data comes in, the pivot doesn’t pick it up, the numbers look wrong, and they quietly go back to writing SUMIFS formulas by hand.

Pivot tables are still the fastest way to go from a raw export to an actual answer in Excel. No formulas, no macros, no AI required. Here are two things you can do this afternoon that fix most of the frustration.

Tip 1: Make your data a real Table first (Ctrl + T)

This is the single biggest fix, and almost nobody does it.

When you build a pivot table off a plain range like A1:H4500, Excel locks in those exact cells. Next month you paste in 800 new rows, hit Refresh, and… nothing changes. The pivot is still looking at row 4500.

Instead, do this before you insert the pivot:

Click any cell inside your data
Press Ctrl + T and confirm “My table has headers”
On the Table Design tab, rename it something meaningful in the Table Name box — tblSales, not Table1
Now insert your pivot table (Insert > PivotTable)

A Table auto-expands. Paste 800 new rows at the bottom, right-click the pivot, choose Refresh, and the new rows are in. That’s it. You never touch the data source range again.

Bonus from the same habit: because the source has a real name, your pivot’s field list stays clean even after you add columns, and any chart or formula pointed at that Table updates too.

One thing to clean up first: your header row needs a real, unique name in every single cell. One blank header will stop the pivot cold, and Excel’s error message won’t tell you which column it was.

Tip 2: Stop writing percentage formulas — use “Show Values As”

Here’s the scenario I see constantly. Someone builds a pivot showing Sales by Region. Then their boss asks, “OK, but what percent of total is each region?” So they copy the pivot results into a blank area of the sheet and start dividing.

You don’t need to. Excel will do it inside the pivot:

Right-click any number in the Values area
Choose Show Values As
Pick % of Grand Total — or, if you have two fields in Rows, pick % of Parent Row Total

That “% of Parent Row Total” option is the one worth remembering. If you have Region in Rows with Salesperson nested underneath, it shows you each salesperson’s share of their own region, not of the company. That is almost always the number people actually wanted.

A useful trick here: drag your Sales field into the Values area twice. Leave the first one as a plain dollar total and set the second one to % of Grand Total. Now you have dollars and share side by side in one pivot, and both refresh together. Double-click the column heading to rename it from “Sum of Sales2” to something a human would read.

Quick bonus: group your dates instead of adding helper columns

If you have a date field in Rows and you want it summarized by month or quarter, don’t build a helper column with =TEXT(A2,"mmm"). Right-click a date inside the pivot, choose Group, and check Months and Years. Excel builds the grouping for you and it survives refreshes.

Small warning worth knowing: this only works if every value in that column is a genuine date. If some of them are text that merely looks like a date — very common in system exports — the Group option will be greyed out. That’s actually a helpful signal that your data needs cleaning.

Want to go deeper? Join me live on September 17

I’m teaching a full live session called Excel Pivot Tables on Thursday, September 17, 2026 at 1:00 PM Eastern.

It’s a working session, not a lecture. We go well past the two tips above and cover things like:

Building a pivot table from scratch on messy real-world data
Slicers and timelines, so non-Excel people can filter your report without breaking it
Calculated fields — adding your own math inside the pivot
Pivot charts that update when the pivot updates
Formatting that actually survives a refresh (the number formats that stick, and the ones that don’t)
Pulling multiple sheets or files into one pivot
The most common pivot table errors and how to fix each one

The session is live so you can ask questions about your own data, and it’s recorded in case you can’t make the whole thing. Dates, times, and registration links are always up to date at PCWebinars.com.

My other upcoming webinars

Pivot tables are one piece of a much bigger schedule. Here’s some of what else is coming up:

Excel and reporting: Microsoft Copilot for Advanced Excel Automation • Using ChatGPT with Excel • Using CoPilot with Excel • Using Claude to be More Productive in Excel • Claude for Excel • AI for Dashboard Creation in Excel

Power BI: Microsoft Power BI for Beginners & Excel Users • Mastering Power BI: A Comprehensive Guide for Beginners • Power BI Financial Reporting & Financial Analysis • Using CoPilot with Power BI • Microsoft Copilot for Power BI: Advanced Analytics • AI-Powered Dashboards with Power BI

AI tools and comparisons: ChatGPT vs Copilot vs Claude: The Best AI Tool for Your Business • Claude vs. ChatGPT: The Complete AI Comparison Guide • Claude AI for Modern Professionals: Work Smarter in 2026 • Claude + Microsoft 365 • Microsoft Copilot Across Excel, Word, Outlook, Teams & PowerPoint • Claude for Non-Tech Professionals and Businesses • Use Claude for Word • How to Use Claude for Data Analysis and Organization • Using Claude to Research Competitors & Summarize Industry Trends

By role: AI for Project Managers • Copilot and Project Management • ChatGPT and CoPilot for Project Management • Using Claude for Project Management • Copilot for HR Professionals • AI for HR Operations • ChatGPT and CoPilot for HR • Claude For HR • AI for Sales Productivity • ChatGPT and CoPilot for Salespeople • CoPilot for Business Professionals • AI Tools for Administrative Professionals • Claude for Customer-Facing Teams

3-hour virtual seminars: Using Claude To Be More Productive In Microsoft 365 • Using ChatGPT and Copilot to be More Productive in Microsoft 365 • ChatGPT & Copilot for Productivity • How to Use Claude AI Like a Pro: Complete Beginner to Advanced Guide

The full schedule with dates, times, and registration links is always at PCWebinars.com. Every session is live, recorded, and hands-on.

About your trainer

I’m Tom Fragale. I’ve been a computer professional for over 30 years and a full-time corporate trainer for more than 20 of them. I’ve trained well over 30,000 people — in classrooms, onsite at companies, and now mostly in live online webinars — on Microsoft Excel, Access, Power BI, Word, Outlook, PowerPoint, SQL Server, and the AI tools that are changing all of them: ChatGPT, Microsoft Copilot, and Claude.

I also build real solutions for clients: Excel models, Access and SQL Server databases, and Power BI dashboards. That matters, because it means what I teach comes from work I actually do — not from a textbook. I’ve written several books on Excel, and I run a YouTube channel with hundreds of free tutorials.

My whole approach is simple: no jargon, no theory for its own sake, and you should be able to use what you learned the same afternoon.

Come join me live at PCWebinars.com — or scan the QR code on the image above.