Demo: Create formulas with Formula AutoComplete

Formula building on worksheet Play Demo Demo button

Or Down arrow download the demo.

(You may experience a delay while the demo is loading.)

The Formula AutoComplete feature in Office Excel 2007 helps you avoid gotchas — those little syntax or typing mistakes that can break your formula and display an error in the cell. Every step of the way, Formula AutoComplete guides you with ScreenTips that show you how to build your formula. The ScreenTips also point you to Help articles for more information about the functions you're using. And you can save time by using defined names in Formula AutoComplete. Watch the demo and then try it yourself.

How to do it (text version):

Assistance Problems watching the video? Try our troubleshooting tips.

 
 
Applies to:
Excel 2007