“Description of the undiscovered tips about Excel

•	Join text in multiple columns
•	Set the print area
•	Exclude duplicate items in a list
•	Multiply text values by 1 to change text to numbers
•	Use the Text Import Wizard to change text to numbers
•	Sort decimal numbers in an outline
•	Use a data form to add records to a list
•	Enter the current date or time
•	View the arguments in a formula
•	Enter the same text or formula in a range of cells
•	Link a text box to data in a cell
•	Link a picture to a cell range
•	Troubleshoot a long formula
•	View a graphical map of a defined name
•	Fill blank cells in a column with contents from a previous cell
•	Switch from a relative reference to an absolute reference
•	Use the OFFSET function to modify data in cells that are inserted
•	Use the Advanced Filter command
•	Use conditional sums to total data
•	Use conditional sums to count data
•	Use the INDEX function and the MATCH function to look up data
•	Drag the fill handle to create a number series
•	Automatically fill data
•	Use the VLOOKUP function with unsorted data
•	Return every third number
•	Round to the nearest penny
•	Install and use Microsoft Excel Help
•	Do not open and save directly from a floppy disk
•	Use one keystroke to create a new chart or worksheet
•	Set up multiple print areas on the same worksheet”

http://support.microsoft.com/default.aspx?scid=kb;en-us;843504