Excel PivotTable — Sales Summary

Client had raw sales data (14 rows across UK/USA, split by quarter) and needed it turned into something actually usable. I cleaned it up and built a PivotTable that breaks total sales down by rep and country, with grand totals for both.

What I did:

Structured the raw data into a proper table (consistent headers, currency formatting)

Built a PivotTable summarizing Sum of Sales by Last Name and Country

Used SUMIFS so the totals update automatically if the source data changes — nothing hardcoded

Checked every formula for errors before delivery

Delivered as a working .xlsx file, ready to plug into a bigger report or dashboard.

If you've got messy sales/ops data sitting in a spreadsheet and need it turned into something you can actually read at a glance, this is exactly the kind of thing I can help with.

I think one of the strangest parts of doing your own thing is realizing how much of the work happens in your head.

The planning. The second-guessing. The “maybe I should try this instead.” The random idea that shows up when you’re supposed to be doing something completely different.

Sometimes the actual work is the easy part.

Anyway, I’m figuring things out, trying new spaces, meeting new people, and seeing where things go.

Hello, Contra 👋