If you want to learn about Excel pivot tables, you've come to the right place. AccountingWEB has built up a wealth of learning resources over the past six years.
David Carter
In the tutorial Create a P&L from a monthly balances with a pivot table we imported a set of monthly bal
1
Written by David Carter and Simon Hurst, ExcelZone's series of Five Minute tips aims to develop your skills at using Excel pivot tables.
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
Reader Ray Yaukip needed a pivot table that gave the total of stock movements or of stock value between two dates.
3
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.
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
David Carter writes...... A small point, but I've just been downloading my bank statement from Lloyds into Excel and noticed that they've improved it.
Pages
Most read: David Carter
- Want to learn about Excel pivot tables? Start here. By David Carter 108,545 6
- ExcelZone's Five Minute Pivot Table Tips - Index 83,829
- Tutorial. MS Query and Sage #1 - how to setup Import External Data. By David Carter 41,732 2
- Improve your reporting skills with self-teach tutorials. 32,478
- Tutorial: Budgeting with Pivot Tables #2 - report actuals against budget 31,140 1
