mthomas.co.uk

Not only do spreadsheets excel at calculating numbers, they can also calculate dates too. Imagine that you have taken out a 6-month loan and you want to know when it will be paid off (assuming that it is 6 calendar months from the loan start date) or maybe you have been assigned a project which [...]

Excel allows you to assign a name to an individual cell or a range of cells. That name can be used in a formula and can help to make the formula easier to understand. Names can also make it easier to navigate around a large spreadsheet. In Excel 2007 and 2010, names have a scope [...]