Software

Let Excel build functions for you

Know a function exists but can't remember its name? Know the function, but need help with its arguments? Don't waste time guessing. Let Excel help.

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:

  1. Click the Insert Function button (fx) on the formula bar.

december2008fig2r.jpg

  1. 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.
  2. 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.

About

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.

1 comments
Nstig8r
Nstig8r

I looked through the list however I did not see a function I am looking for: I want to insert the date the file was created, into a cell. Is this an option?