Most Popular Topic of 2015

Of the 30,000+ views this blog received in 2015, the most popular topic was 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 easy-to-answer questions.

Tried and True

This wizard has been around a long time, and has been vital tool for many neophyte and experienced Excel users alike.  The names the functions are not always intuitive, so it can quickly help you zero in one the function you need.

Easy to Find

Whether you are using Excel 2007, 2010, 2013, or 2016, you can find the Insert Function Wizard nestled neatly in the left corner on the Formulas ribbon.  Simply enter a brief description of what you want to do.  For instance, let’s say you want to calculate the Yield of security you are considering, and Bamm, a list is presented for you to choose from.

Easy 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. 

Cheers!