Pivot tables are an advanced method of arranging organized data and using formulae in Microsoft Excel. We could use standalone formulae over rows and columns but upon adding or deleting rows these ...

Instead of counting on fingers or editing the table, we can use a pivot table here to find out information. To make a pivot table in Excel, we first highlight the entire table, and then we go to ...

You can delete a pivot table in Excel with a few clicks on a Mac or Windows PC. Here are two ways to do it.

Particularly valuable is the facility to export raw transactions out of a company's accounting system (Sage, Pegasus, Sun etc), import them into Excel, then use pivot tables to analyse the ...

If you've have lots of data and lots of analysis to do, but little time or skill, you need Excel's Power Pivot feature. Here's how to get started with it.

David Carter's first tutorial on pivot tables was the most visited part of AccountingWEB last year, proving the value of an in-depth knowledge of this indispensable Excel tool. His second guide looks ...