Abraham Lincoln is thought to have said, “If I had 60 minutes to cut down a tree, I would spend 40 minutes sharpening the ax and 20 minutes cutting it down.” Lincoln also almost cut off a finger chopping wood.
Still sharpening the ax is one of the Steven Covey's 7 Habits* and in the modern age of tools more important than ever. Although I have worked with spreadsheets for many years this blog posting 10 obscure Excel tricks that can expedite common chores by Jeff Davis was very informative. The ten are:
- Select all with one click
- Copy the formatting of one or more cells and apply them to another cell or range
- Preform one-click data mining with AutoFilter
- Press [Ctrl]~ to display formulas
- Generate a unique list of entries in a column
- Let Excel calculate your subtotals for you
- Analyze selections with the AutoCalculate menu
- Love your [Ctrl] key - for three reasons
- Transpose data from row to column
- Convert calculations to literal values
The only one I knew about before reading Davis's posting was number 10 so this posting was well worth reading and my recommendation for anyone who works occasionally or regularly with Excel is to take a look.
