MS Excel Secrets - AutoComplete feature

The Auto Complete feature in Excel for formulas will save you  time. When you start typing in an Excel function in a cell, you don’t have to type the entire thing.

You can type the equal sign and begin to type the function name.

Read lots more MS Excel Secrets
As you type in the name, you will see a list of functions appear below the active cell. You should continue to type until you see the name of the function you want to use. You double-click the name of the function to be able to use it in the active cell. 

A Screen Tip will show below the cell and will contain the function and its argument to guide you through the process of entering all of the function information.

Related Posts:
How to Convert PowerPoint to Flash Flipbook