Description of the undiscovered tips about Excel

Wha..cool tips for Technical Manager (e.g using excel lots ) :)

		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

Suresh Behera