The default settings for bar chart in Excel mean that they appear on your charts with a lot of space between them.  This default setting is sometimes not the look we want for our charts in...

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...

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...

Most of the time in Excel an AutoFilter would enable you filter lists in the ways you need to,  But, in some cases you may need or want to exert more control of over the way filtering operates....

Recently a colleague was having an issue with their Pivot Table, they claimed some if their data was 'missing', a subscriber to my newsletter also had this issue so I thought I would cover it in...