Forum home » Delegate support and help forum » Microsoft Excel Training and help » exce+training - Excel

exce+training - Excel

ResolvedVersion Standard

Wed 28 Nov 2007, 16:40 Delegate Melanie said...

Melanie has attended:
Excel Advanced course

Excel

How to consolidate pivot tables from different sources

Thu 29 Nov 2007, 15:38 Trainer Amanda said...

RE: Excel

Hi Melanie

Thank you for your question.

You can create a pivot table from data that is stored on different sheets, either sheets that are in the same file or sheets that are in different files.

I will refer you to another web site which is helpful as it explains this step-by-step and provides screenshots as well.

Please go to http://www.contextures.com/xlPivot08.html

Amanda

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Showing all menu items

If you go into a pull down menu you usally find that you get a selection of items(this is the default) or sometimes everything. If you only get a selectiopn you have to go to the double arrows at the bottom of the menu and click it to get all of the hidden items.
To turn this off so that you always get everything, go to Tools / Customize / Options Tab / "Always show full menus". Make sure there is a tick in the box and you will always have every item.

View all Excel hints and tips

exce+training - Excel

Excel

RE: Excel

Excel articles

Excel tip:

Showing all menu items