pivot tables

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

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

Pivot Tables

resolvedResolved · Low Priority · Version 2003

Gemma has attended:
Excel Advanced course

Pivot Tables

Whats the easiest way to incorporate multiple data worksheets into a Pivot Table?

RE: Pivot Tables

Hi Gemma

I have attached a file that will demo how the multiple data worksheet pivot works. Let me know how you get on.

kind regards, Tanya

Attached files...

MultipleConsolidationPivot.xls

Mon 19 Apr 2010: Automatically marked as resolved.


 

Excel tip:

Enter formulae into multiple cells

If a formula is to be used in a series of cells, select the cells first. Now type in your formula and hold the Ctrl key while you press Enter. This enters the formula in each selected cell.

Just be careful with your absolute and relative cell references.

View all Excel hints and tips


Server loaded in 0.08 secs.