Stop manually reformatting Excel spreadsheets. The Spill Manager add-in makes your formatting move dynamically with expanding arrays.

Many of the Excel formulas I use for lists require supervision. Sometimes, when I add a new row, something breaks or needs adjusting. TAKE and DROP don't have that problem. These two dynamic-array ...

In Microsoft Word, direct formatting is great when used conservatively, but removing it in a document littered with it is difficult. These Word tips might help. There are lots of ways to return the ...

Q. I get a detailed revenue transaction export from the client, and then I get it again, revised, usually after I’ve already filtered, sorted, and documented my selections. I’m tired of reapplying ...