pivot tables

ExcelZone's Five Minute Pivot Table Tips - Index

Written by David Carter and Simon Hurst, ExcelZone's series of Five Minute tips aims to develop your skills at using Excel pivot tables.

Pivot tables and stock control (1) - The problem

Reader Ray Yaukip has been experimenting with pivot tables to summarise stock movements in and out. They give him most of what he wants but has come up against a problem.

5
Pivot Tables and Stock Control (2) ' The answer

Reader Ray Yaukip needed a pivot table that gave the total of stock movements or of stock value between two dates.

3
Pivot Table - Auto Update of Data Table

I have several pivot tables linked to my data in the same spreadsheet.

8
Consolidations with pivot tables - putting together a budget

The Multiple Consolidation Ranges feature allows you to pile a lot of similar worksheets on top of each other and summarise the results in a pivot table.

Using Excel's VLOOKUP function to add fields

For anyone who is serious about analysing data and creating pivot table reports, knowing how to use Excel's VLOOKUP function is a must. David Carter explains how.

2
Tutorial: Consolidating multiple worksheets in a Pivot Table

This tutorial is in response to a question posed by reader Mr Tom Trainer, who asked on 1st August: "Can pivot tables be used to manipulate 3-D spreadsheets, (i.e.

1
Modelling and What if? analysis with pivot tables

All accountants use spreadsheets for financial modelling and 'What if?' analysis.

1

Pages

Most read: pivot tables