From Excel 2007 onwards you can use the Table command to convert a data list or set into a formatted Excel Table. Once your data is converted into a table you can use their many features such a...

If you have ever used data from Yahoo or Google in a data table have you retyped it in, or tried to copy and paste it? It either takes too long or the formatting appears all over the place.  Google...

Excel 2002 introduced the Text -To - Specch feature.  It's an interesting one, you can get Excel to call out back to you the contents of a range of cells, or call out the cell contents as you type...

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