Excel has hundreds of built-in functions — if you can think it, Excel can probably evaluate it. All that power is great, but trying to remember every function is impractical.
Fortunately, Excel can assist you. The next time you need to create a function, let Excel help:
- Click the Insert Function button (fx) on the formula bar.
- When the Insert Function dialog box opens, type a description of what you're trying to do in the Search For A Function text box. It might take a few tries, but that's better than blind guessing.
- Click Go, and Excel will respond with a list of possible functions.
If you know the function name but need help with its arguments, enter the name in the search box. The Or Select A Category drop-down list is helpful for finding a function you can't remember but have used recently.
Susan Sales Harkins is an IT consultant, specializing in desktop solutions. Previously, she was editor in chief for The Cobb Group, the world's largest publisher of technical journals.