Lesson 4 of 7
Stats & pivots without the syntax
6 min read
"Total sales by region." You know exactly what you want. But building the PivotTable to get it? That's where most people quietly give up.
Grouping is just a sentence now
A pivot takes a long table and boils it down: sales by region, orders by month, average by product. It's one of the most useful things a spreadsheet does — and traditionally the most fiddly, with a wizard of boxes to drag. With AI you skip all that: you write the sentence — "total sales by region" — and the summary table appears.
You don't build the pivot; you describe it. "Average by product", "count by month" — the grouping is just plain words now.
Sum, average, count — say which
The same table can be summarised many ways, and the verb you use picks the maths. Total adds each group up. Average gives the typical value per group. Count tallies how many rows fall in each. Change the word and the summary changes — no formula, no wizard, same table underneath.
A summary hides the rows behind it, so a wrong grouping is easy to miss. Sanity-check one group by hand — does "North: 900" match the North rows you can see?
The shape of it
- —A pivot summarises a long table into groups — by region, month, product.
- —Describe the grouping in words instead of building it by hand.
- —The verb picks the maths: total adds, average typifies, count tallies.
You want the total sales for each region from a long list of orders. What's the AI way?
Continue in the app
Take the whole AI for Spreadsheets course — tracked
Get your personalized path, progress and streaks in the app — this lesson and every next one, in order.