What are Pivot Tables in Excel?

TrustPilot

starstarstarstarstar Excellent

Forum home » Topics » What are Pivot Tables in Excel?

What are Pivot Tables in Excel?

A PivotTable report is an interactive table that quickly combines and compares large amounts of data. You can rotate its rows and columns to see different summaries of the source data, and you can display the details for areas of interest.

You can use a PivotTable report when you want to analyse related totals, especially when you have a long list of figures to sum and you want to compare several facts about each figure.

An example would be looking into a sales report, broken down by Region, Product, Sales Person or Quarterly Totals. You are able to expand and contract the detail of each area to focus on the detail that is most important to you.

Related forum posts:

What can a pivot table be used for?

What is a pivot table? and what can it be used for?

Read forum post

 

Excel: Lookup Tables v. Pivot Tables

Can you explain when I should use a Lookup table versus a when I should use a Pivot table?

Read forum post

 

Create pivot tables

How do I create Pivot Tables?

Read forum post

 

Pivot Table - conditional formatting

Can one do conditional formatting in a pivot table? The pivot table I have set up shows allocated days per employee per month and I want to highlight Red; Amber; Green if total days per month are >20 (R); <=19(A) ; =20 (G) Thanks, if not any other suggestions? Macros etc? Thanks

Read forum post

 

pivot tables and graphs

can you add a graph related just to a pivot table?

Read forum post

 

Excel 2010 - Pivot Table - new Worksheets

Martin showed us a really useful way to "Spin off" data contained in the Pivot Table (Report Filter) into separate new worksheets within the main workbook. I can't find this in the reference manual and unfortunately I didn't note down the details. Would someone be able to remind me how to do this, please?

Read forum post

 

Excel pivot tables

How do they work?

Read forum post

 

Related articles

Microsoft Excel Features and Functions for Accountants

Read article

 

Preparing to Pivot: Why all Excel users should know about Pivot Tables

Read article

 

Advanced Excel and PivotTable Reports

Read article

 

Microsoft Excel as a Reporting Tool

Read article

 

Microsoft Access Training Unleashes the Power of the Pivot Table

Read article

 

Creating Tables Automatically In Excel 2010

It used to be the case that users would have to add data to a spread sheet and then manually format the data into a table. This manual process is made far more efficient with the automatic table tool, which can turn the data into a functionality filled and beautifully designed table. This article will examine how to use this functionality.

Read article

 

Discover The Top Ten Changes In Excel 2010

Want to find out the key changes in Excel 2010? This article brings you details of the top ten changes to help you to get to grips with what's new in Excel 2010.

Read article

 

 

Live dates & prices

 

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


TrustPilot
TrustScore 9.6       1034 reviews