It is vital that you get to grips with Excel Named Ranges if you are to Improve Your Excel Skills.
This video is an original Improve Your Excel video and shows 3 great ways to use Excel Named Ranges. It starts by looking at naming cells and using them in equations. Then it looks at naming a group of cells and finally it looks at one of the secrets of Excel named ranges and how to use them with with Data Validation drop down list.
This video was recorded a few years ago – but everything shown works with Excel 2007 and Excel 2010 – however one trick you want to use straight off is that you can name a cell simply by typing the name in the cell name box at the top left of your spreadsheet – a very quick way to name ranges.