CompuFiciency — Applied CompuTelligence

Few things add more power to Excel spreadsheets than dynamic named ranges.  Why?  Because they allow you to create highly complex formulas that change as often as necessary using a word (‘Expenses’) instead of hieroglyphics (Sheetxx!A$139:$RJ$125).
And one key to making them dynamic is the =OFFSET( )function.  A bit confusing at first, but very manageable if [...]

The New Guidelines for Writing Spreadsheets
Rule 3: Format for description, not decoration.
A format is descriptive if it gives the reader immediately recognizable information. A format is decorative if it displays no information.
Decoration in a spreadsheet is like crayon in a business letter. Format to explain to the reader, not to impress the reader.Bad. Meaningless colour [...]

The JLD Excel Blog – Tips and Help for MS Excel: May 2006
When you want to protect formulas or data in a worksheet you can hide columns and/or rows, hide formulas and more and then apply the Tools—>Protection menu.But if you want to limit the users to a certain area in the worksheet, that means, [...]

Office Hours: Hidden gems in Excel 2007 – Help and How-to – Microsoft Office Online
So many worksheets, so little space
Have you ever had an Excel workbook with multiple sheets, those sheets having names other than the proverbial Sheet1, Sheet2, and Sheet3? My wife’s business has many great examples of this, where business data is being [...]

Microsoft Excel Tips from Excel Tip .com / Free Excel Spreadsheet Help / MS Excel Tutorial
Separating the addresses shown in column A into three columns, one each for City, State, and Zip Code.
Solution:
Use the LEFT, MID, RIGHT, and FIND functions as shown in the following formulas:
To extract the City: =LEFT(A2,FIND(“,”,A2)-1)
To extract the State: =MID(A2,FIND(“,”,A2)+2,2)
To extract [...]

Hyperlinks in Excel

A hyperlink is a convenient way to allow the user of a workbook to instantly access another place in the workbook, another workbook, or a file associated with another application. A hyperlink can be inserted in a cell or a shape in Excel. Select the cell or shape and select Hyperlink from the [...]

Make a Numerical Constant – PC Magazine

Got one number you use over and over in a spreadsheet? Make it a constant. On the Formulas tab, click Define Name, and give the select cell a name (like “taxrate”). Put a number in that cell. Now you can use the name in a formula (like =(b4*taxrate) instead [...]