This PC world article shares five advanced techniques to allow improved documentation and other techniques for processing spreadsheet data

http://www.pcworld.com/article/3088207/software/excel-5-timesaving-power-tips.html

There’s no such thing as too fast when you’re crunching numbers on deadline in Excel. Any of these power tips will speed up your tasks.:

1. FORMULATEXT() adds notes to formulas — It’s nice to have notes that explain what your formulas are doing (plus a copy of the formula). Some organizations even require it, especially if you’re a programmer or analyst. This little formula and the +N function are the quick answer to your spreadsheet documentation needs.

2. Adding Notes with N() function: Another way to add notes — For a long, complicated formula, you could add comments that explain what the formula is doing by just entering +N plus the comment, inside quotes inside parentheses

3. Text “Case” Functions — The UPPER() function converts all characters to uppercase. The LOWER() function converts all characters to lowercase. For names or sentences, the Proper case, or PROPER() can be written as a function.

4. Transpose feature to flip columnar data into rows — This feature allows rows/columns of data to be re-formatted into columns/rows. This doesn’t seem like a big deal on a small spreadsheet, but imagine reorganizing 40 columns and 200 rows and you’ll like this tip much better.

5. Autofill blank cells — Everyone who handles series data should use Autofill to save typing and retyping for things that are always the same—for example, a list of consecutive numbers or letters, months of the year, or days of the week.