This is one of my favorite EVER timesaving Excel Tips Need to quickly select all of the cells that contain data in your worksheet? This could be for formatting, or a a selection of data for a...

Gaps can be good, - sometimes - but not always on the Axis of your Excel chart. I think it looks like something is missing somehow or just downright untidy.  A bit like my example here...

This really was something that annoyed me until I found out how to fix it!  If you have large numbers on your Y axis it can take up waaaay too much space.the sales here may be good but the Y Axis...

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

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