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-inOne 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-inThe 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.
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