In the 8-year publication of this blog, one
of the most popular topics has been the Insert Function Wizard. A Wizard is, of course, a help
feature in Excel that automates finding a function by asking the user a series
of rudimentary questions.
It’s Been Around
This wizard has been around a long time,
and has been important tool for newcomers and experienced Excel users
alike. The names Excel functions are not always intuitive, so the
Wizard can be invaluable when searching for what you need.
Where Is It?
In any contemporary versions of Excel,
you can find the Insert Function Wizard nestled neatly in the
left corner on the Formulas ribbon. There you can
enter a brief description of what you want to do, (let’s say you
want to calculate the Yield of security you are
considering), and Presto, a list is presented for you to choose
from.
A Snap to Use
Then is a simple matter to complete
follow the step-by-step instructions of the utensil to complete you
function/formula. The
simplicity and efficacy of this handy wizard is the driving reason it has
remained one of Excel’s favorite Go-To Tools.
Simply
Do the Following
1) Pull up the Insert Function Wizard
2) Type your description in the search textbox (for example, “loan payment”)
3) Select the function (it would likely be PMT)
4) Complete the Function Arguments and click OK
The Insert Function Wizard. Give it a try and find out how easy it is to perform a bit of Magic when you need it.
1) Pull up the Insert Function Wizard
2) Type your description in the search textbox (for example, “loan payment”)
3) Select the function (it would likely be PMT)
4) Complete the Function Arguments and click OK
The Insert Function Wizard. Give it a try and find out how easy it is to perform a bit of Magic when you need it.
No comments:
Post a Comment