Forum home » Delegate support and help forum » Microsoft Excel Training and help » Pivot Tables

Pivot Tables

ResolvedVersion 2007

Wed 1 Jul 2009, 16:18 Delegate Debbie said...

Debbie has attended:
Excel Advanced course

Pivot Tables

What is the best/quickest way to reconcile two pivot tables with similar data?

Fri 3 Jul 2009, 10:01 Trainer Stephen said...

RE: Pivot Tables

Hi Debbie

Thank you for your question

Could you please clarify what you mean by reconcile for me? Do you wish to compare two pivot tables with the same row and column headings? If so what is the nature of the comparison, e.g. do you wish to see the difference between the values, or perhaps one as the percentage of another

Thanks

Stephen

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Status Bar Functions

When using the SUM, MIN, MAX, AVERAGE and COUNT functions, the result of such calculations are displayed in the worksheet.

However, if a range of cells, containing numbers, is highlighted, and then a right-mouse click is performed at the bottom right side of the status bar, then the result of those functions will be displayed.

View all Excel hints and tips

Pivot Tables

Pivot Tables

RE: Pivot Tables

Excel articles

Excel tip:

Status Bar Functions