10 obscure Excel tricks that can expedite common chores

The business world is full of users who have neither the opportunity nor the inclination to figure out Excel's timesaving shortcuts. They end up wasting a lot of time (and adding to your support burden) because they just don't know the smartest ways to work with spreadsheet data.

IT consultant and TechRepublic HelpDesk blogger Jeff Davis has put together this collection of essential tips for working more efficiently in Excel. Techniques include transferring formatting from one range to another, one-click data mining with AutoFilter, generating a list of unique entries in a column, and taking advantage of Excel's Subtotals and AutoCalculate features.

This download is also available as an article. Join the discussion and share your experiences and opinions.