Here is an excerpt of the articles. Visit the link below for the complete list of cool Excel tricks.
#1: Select All with one click
|Select the entire worksheet by clicking on the gray square above the row numbers (and to the left of the column letters).|
#5: Generate a unique list of entries in a column
|Use the Advanced Filter options to tell Excel whether to filter in-place or to copy the unique records to another location.|
|The Advanced Filter feature copied a sorted list of the unique entries from the source data in Column A.|
You can check out the rest of the Excel tricks here TechRepublic.com - Excel Tricks.
Till the next Excel coolest tricks!