Tuesday, March 7, 2017

Popular Topics

In the 8-year publication of this blog, one of the most popular topics has been the Insert Function Wizard.  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.

No comments: