![]()
f you use Excel to model businesses, business processes, or
business transactions, this course will change your life. You'll learn how to create tools for yourself that will amaze
even you. Unrestricted use of this material is available in two ways.
To Order On Line
| Order "Spreadsheet Models for Managers, on-line edition, one month" by credit card, for USD 69.95 each, using our secure server, and receive download instructions by return email. | Or order via Google Checkout. |
| Order "Spreadsheet Models for Managers, on-line edition, three months" by credit card, for USD 199.00 each, using our secure server, and receive download instructions by return email. | Or order via Google Checkout. |
| Order "Spreadsheet Models for Managers, downloadable hyperbook edition" by credit card, for USD 199.00 each, using our secure server, and receive download instructions by return email. | Or order via Google Checkout. |
To Order by Mail
Make your check payable to Chaco Canyon Consulting, for the amount indicated:
|
And send it to: Chaco Canyon Consulting 700 Huron Avenue, Suite 11J Cambridge, MA 02138 |
To use the course software you'll need some other applications, which you very probably already have. By placing your order, you're confirming that you have the software you need, as described on this site.
![]() |
| Reference Operators | 4/3 Session Links |
These three operators are useful for extracting specific regions. One is very familiar to you: the Colon. The other two, respectively, produce the Union of two ranges and the Intersection of two ranges.
Unlike the Colon operator, the Comma and Space operator are "nary", which means that you can string together an arbitrarily long number of arguments. For example, if RangeA, RangeB, RangeC and RangeD are ranges, then the formula
returns the intersection of all four ranges.
The intersection operator and comma operators don't work with 3-D references.
For more about my spreadsheet consulting and training services, visit SpreadsheetAce.com.
Last Modified: Wednesday, 22-Oct-2008 05:31:20 EDT