How to create pivot tables in excel?

Question

Hitesh Vohra · Answer 1

A PivotTable is a powerful tool for calculating, summarising, and analysing data, allowing you to spot similarities, patterns, and trends.
PivotTables behave differently depending on the platform on which you're running Excel.
In Excel for Windows, make a PivotTable.
Choose the cells from which you wish to make a PivotTable.
Select PivotTable from the Insert menu.
This will generate a PivotTable from a table or range that already exists.
Choose where the PivotTable report will be displayed. Select New Worksheet to add the PivotTable to a new worksheet, or Existing Worksheet to add the PivotTable to an existing worksheet.
Select OK.

answered 25-Mar-2022 by Hitesh Vohra

Delete Confirmation