A pivot table is a tool that summarises a large table by category. Build a pivot table, refresh the pivot table, a pivot table of sales.
It answers questions like the total by region and month without writing a formula, which is why it is the single most useful thing to learn in a spreadsheet. The name was Microsoft's and was a trademark until 2020.
1nounpivot tableA tool that summarises a large table by category.
“I made a pivot table to show total sales for each region.”
pivot table is a tool.
Named by Microsoft in 1994 as PivotTable, though the idea was older; the trademark lapsed in 2020.
Introduced by Microsoft in 1994 as "PivotTable" (though the concept was older); their trademark was active until 2020.
Etymology from Wiktionary, CC BY-SA
Practised in Office & Admin