Excel custom number formatting
Jan 16th
Do you want to enter data in to cells in a specific format but Excel won’t let you?
In this tutorial we will look at formatting cells to accept data in specific formats without Excel mucking them up.
Excel handy keyboard shortcuts
Jan 16th
There are hundreds of keyboard shortcuts in Excel all peforming some very specific tasks. So which ones are useful and which ones aren’t?
In this short guide we have selected some of the handiest keyboard shortcuts, which will save you loads of time and effort.
Excel VLOOKUP tutorial
Jan 11th
Note – Although this tutorial is based on Excel 2007, the majority of this tutorial will apply to earlier versions of Excel.
VLOOKUP stands for vertical lookup and it is a great way of finding related information in an Excel table. For the purposes of this tutorial we are going to use a simple price list as an example.
In this exercise we are going to find the cost of individual items using just a formula.
More >
List unique values in an Excel range
Jan 11th
No matter what you use Excel for, you will always come across the need to generate a list of unique values from a range. Or in other words the need to get rid of duplicates in a list.
The following trick is a quick and easy way of getting a list of unique values using the “Advanced Filter” function.
