Welcome to Chaco Canyon Consulting!

Add-Ins, Spreadsheet Models for Managers

Add-Ins, Spreadsheet Models for Managers

Availability: In stock

Two add-ins from my course 'Spreadsheet Models for Managers' will change your life.


One This item is available in downloadable format only. Since it isn't shipped, be sure before you order that your shipping charges are 0.of the courses/workshops I offer, Spreadsheet Models for Managers, includes two add-ins that -- if you use Microsoft ® Excel — will transform your life. The course is available as a download, or on line, but if you just want the add-ins…

Everyday users of Microsoft Excel face a tedious, complicated, and annoyingly detailed working environment. Life can be better if you take my course, Spreadsheet Models for Managers, either on line, in person, or by download. But I know that some of you might not be able to do that right now, and I want to help anyway. Your life can be very different if you'll just install these two add-ins.

Commands Add-in

One add-in installs a menu with five commands. Just five, but they're very powerful, if your use of Excel is even a little bit higher than the elementary.

Define Above, Below, Left, and Right   This command defines the names Above, Below, Left and Right to be references relative to the cell in which they're used — one cell above, below, left and right, respectively. It also defines the name Me to be the cell in which it is used

Define Local Name…   This command defines a local name, which you provide, to be the selection on the active worksheet. You can choose between defining that name on all worksheets, on the selected worksheets, or on the active worksheet. Local names are especially useful when you want to use identical names on several worksheets

Resize Current Array   This command examines the active cell to determine whether or not it contains an array formula, and then applies that formula as an array formula to the selected range

Tile Top Two Windows   This command arranges the top two Excel windows to cover the screen — one on the top half, the other on the bottom. This is most convenient when you need to look at two windows at the same time

Apply Names to Chart Objects   This command examines all the chart objects on all selected sheets, and modifies the SERIES formulas in each chart so that they use names when possible.

Worksheet Functions Add-in

The second add-in provides two very useful worksheet functions:

MMMult   This function performs matrix multiplication. It's just like Excel's MMULT, except that it can operate on up to ten arguments

Convolve   This function takes two arguments, each of which is a rectangular range. It produces the convolution product of the two ranges. The convolution product is very useful in modeling time behavior.

Details and additional information

More info

This item is available only in downloadable format.

To avoid shipping charges, be sure to select "downloadable" for the shipping method.

Last modified: 22 Feb 2015 21:09 Eastern Time


Product Tags

Use spaces to separate tags. Use single quotes (') for phrases.