One of THE most useful features in Excel is the pivot table which is used to summarize, analyze, explore, tabulate and present your data.  Not just small amounts of data, but we can cope with huge...

I have included this tutorial as part of the Pivot Table Tutorials as I have found to fully understand and get the best out of this fantastic Excel function you need to know the core terminology,...

Some users love merging cells, some don't. I admit I am the latter, in fact I do not like them with a passion. Ok, they can be useful sometimes for example in a template or two, to make them look and...

Using a document theme is a great way to personalise and standardise your own personal or company image for consistency and a professional look.  It is really not complicated to do, and can save you...

If you reuse your pivot tables over and over again but your source data changes then you may find you have old items remaining in the TabLe Field Drop downs.  In Excel 2007 it's really easy to deal...

Sometimes you may want to limit the access of a user to a particular range of cells in a worksheet, for example you may have a worksheet set up that only a certain range can be modified or activated...