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

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.