You probably know already know how to use the Find & Replace function in Excel.  All you need to do is hit CTRL+F and you are able to look for just about anything on your Excel spreadsheet.  I...

In Excel 2007 onwards it really is easy to highlight either the top or bottom 10 values in your data set with some handy conditional formatting, either fill colour or changing the font colour. ...

Need to find duped values in your Excel data?.  Do want them to jump out at you?.  It's very easy  to achive this using Conditional Formatting.   You need to firstly set up the...

This tip really is a fun one for spicing up that boring chart for your presentation, some peoples charts really are snoozy, so here is how to pep yours up a little with a few clicks. First of all...

Suppose you have created a workbook with a a numbers of sheets, typically a number working data sheets and maybe a summary sheet. You may want to monitor the cells on the summary sheet whilst...

It is really easy to change the type of chart you have created if you either selected the incorrect one or changed your mind about it. All you need to do is Click any part of your chart ...