Do not know about a particular function?

What do you do when you do not know about a specific function?

One of the most common tecniques which one applies is - search on google (if one has internet connection). Right? Or, in case you do not have the internet, you would go to Excel's 'Help' section and find out how to use the function. (The second option is the best if someody ask me)

But what if you do not have time to go through the Excel's documentation to read the whole content and understand the stuff that Microsoft has written for you. And, all what you want to know is just what all arguments go into a function. (You can also refer to Excel Math Functions explained by Excel Matic)

Microsoft has taken care of this also. They have integrated in Excel something which I call as short-cut Help. Whenever you are writing a function, which you do not know about, you can acces this help.


How to get this help

Start writing the function, write the name of the function and only the opening brackets (to input the arguments, but do not input any arguments)

It should look like this -

= FunctionName(

After you have written this much, press CTRL+A. On pressing these key combinations the function wizard will pop up and will guide you through writing that particular function. You can also get this wizard by using the Menu bar (Menu Ribbon for Office 2007).

Whenever you use the menu bar to insert the function, the function wizard pops up and guides you through writing the function.

Share on Google Plus

About Rishie Khurana

This is a short description in the author block about the author. You edit it by entering text in the "Biographical Info" field in the user admin panel.
    Blogger Comment
    Facebook Comment

0 comments:

Post a Comment

Sunday, May 24, 2009

Do not know about a particular function?

What do you do when you do not know about a specific function?

One of the most common tecniques which one applies is - search on google (if one has internet connection). Right? Or, in case you do not have the internet, you would go to Excel's 'Help' section and find out how to use the function. (The second option is the best if someody ask me)

But what if you do not have time to go through the Excel's documentation to read the whole content and understand the stuff that Microsoft has written for you. And, all what you want to know is just what all arguments go into a function. (You can also refer to Excel Math Functions explained by Excel Matic)

Microsoft has taken care of this also. They have integrated in Excel something which I call as short-cut Help. Whenever you are writing a function, which you do not know about, you can acces this help.


How to get this help

Start writing the function, write the name of the function and only the opening brackets (to input the arguments, but do not input any arguments)

It should look like this -

= FunctionName(

After you have written this much, press CTRL+A. On pressing these key combinations the function wizard will pop up and will guide you through writing that particular function. You can also get this wizard by using the Menu bar (Menu Ribbon for Office 2007).

Whenever you use the menu bar to insert the function, the function wizard pops up and guides you through writing the function.

Do not know about a particular function?SocialTwist Tell-a-Friend

0 comments:

Post a Comment