Excel PivotTables

A PivotTable summarises a large dataset in a few clicks. It gives you summaries of sales, expenses or any list.

You will need

• Excel
• Data in table form (headings in the first row)

Steps

1. Prepare your data

   Make sure the data has headings, no empty rows and the same type of information in each column.

2. Convert it to a table

3. Insert a PivotTable

4. Drag the fields

5. Add columns

6. Filter

7. Refresh

8. Make a PivotChart

The full guide with every step is for members. Try 7 days for €0.99.

People also search for: excel pivot table · how do i create a pivot table in excel · how to summarise data in excel quickly · group and total sales data in a spreadsheet · pivot table tutorial for beginners with an example

More guides on: Digital skills and AI

• Excel's IF function
• Excel's VLOOKUP function
• Spotting phishing
• Backing up your computer
• Choosing a cloud service
• Setting up a printer
• Connecting Bluetooth devices
• Sharing your screen

Digital skills and AI – All guides ›