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. spreadsheets consisting of several ...

Have you found this content useful? Use the button above to save it to your profile. In the first part of this Working with accounting data tutorial series we looked at ways to apply some of the new ...

How to use Excel’s PivotTable tool to turn data into meaningful information Your email has been sent Before Microsoft Excel added the PivotTable tool, you had to use summarizing functions and features ...

Let’s say you have an Excel workbook that contains student grades for multiple sections of a class that you are coordinating. You would like to be able to summarize the grade data by different ...

How to return the first and last times from timestamps in a Microsoft Excel PivotTable Your email has been sent The article How to return first and last times from timestamps in Microsoft Excel uses ...

<B>Background: (Feel free to skip)</B><BR>I'm starting a project here at work to explore using OLAP techniques to start working more intelligently with our data.<BR><BR>Towards this end I got familiar ...