For most of us, Excel is one of those programs where you use 10% of the functionality and only even know of 50% of it. Regardless of whether or not you fall into this category, an brief article you might want to take a look at is “Hidden gems in Excel 2007“.

This points out and walks you through 3 functions which most of us would probably find very helpful:

• Quick worksheet selection.
• Filtering data based on conditions.
• Aggregate grouping setup.

The first entry alone is worth reading if you were not already aware of this.

Anyone else have any Excel tips/shortcuts they would like to share?