Excel Formula Auto Complete Feature

Auto Complete feature is a useful one that is a great help when you develop spreadsheets. Select the cell that you want to put the function and start with an equal sign "=" and the first letter of the function. Excel automatically opens up a drop-down list that show all the possible functions that begin with the letter you typed.  There is also a Screen Tip with a short explanation for the function.

You can use the arrow keys to select the function that you want to input and press Tab or double click to insert the function.