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

If you find that users are consistently entering incorrect data into worksheets then using Data Validation to prevent users entering invalid data and also displaying a message to prevent them is the...

Want to create your own style Excel work book to re use over and over again? It is easy to create your own default template in Excel to fit in with your corporate style or your own personal...

Every four years we get an extra day, how cool is that, so just what will you do with your extra day this February?. You could use it to learn more about date calculations in Excel?...Why...