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

It's amazing what a simple command of Copy and Paste can achieve when it comes to Excel. Dig beneath the surface and there is so much more than you would think.  Most people do the CTRL+C - CTRL+V,...

Do you use Excel regularly but are overlooking one of its most powerful features? The LEN function is a great tool for users seeking to calculate the length of text and numbers stored in their...

If you are a casual user, data junkie or number cruncher, from Excel 2007 onwards Microsoft has changed the face of their application. If you or your organisation has just upgraded or is looking to...

You are working on a document with colleagues that contains with multiple worksheets, they ask you to print out the worksheets. As each Excel worksheet has its own Print Setup options (margins,...

Adding a background image to a worksheet or workbook can really spice up a presentation where graphs and charts, let face it, can get a little monotonous.  These background images will really set...