Excel's PivotTable feature is a fantastic option for data analysis, allowing users to consolidate and analyze data from various sources in a single, ...

In the first part of this *Working with accounting data [1]* tutorial series we looked at ways to apply some of the new features in Excel 2010 and 2013 to ...

During the tutorial we will change the structure of one of them and see how this is reflected in the pivot table consolidation. This is an adapted version of a tutorial published by Mr John Lacher, an ...

A pivot table in Microsoft Excel reorganizes data quickly into a meaningful report, and it's easy to use!

How to use Excel's new Cube-based functions and conversion tools to convert a PivotTable to a formula-based report.

Up-to-date information can be critical; these 4 tips will add flexibility and increase efficiency when refreshing pivot tables.