A Pivot table allows a user to summarise and organise large amounts of data. Pivot tables are used to discover sales trends, make comparisons or analyse overall data. Once the data has been analysed and processed, the data can then be extracted to other areas of Excel for further analysis. The easiest way to extract the data from a Pivot table is via the GETPIVOTDATA formula, which is built into Microsoft Excel. Although it is a formula, there is no coding required by the user.
- Skill level:
- Moderately Easy
Other People Are Reading
Type the "=" sign, without the quotes, into an empty cell.
Click on a cell in the pivot table. A formula will appear next to the equal sign.
Press the "Enter" key. The cell will now display the data from the Pivot table.
- 20 of the funniest online reviews ever
- 14 Biggest lies people tell in online dating sites
- Hilarious things Google thinks you're trying to search for