Referencing in Excel explained simply. This tip of the week explains how to use relative and absolute referencing in Excel.

The Excel Help on the function gives a useful list of the syntax for each of these (except for a cell on another sheet!). The Friendly name is optional and is the string you want to appear as the ...

Keyboard shortcuts can really save you time. Here is the fourth list in a series of eight that refer to referencing and selection.

I have a spreadheet in which coulmn A is a list of location ID numbers and colum B will be the name of those locations. Currently the data was pulled in a maner that only liste the ID# but name ...