Spreadsheet Models for Managers

Getting Access to Spreadsheet Models for Managers

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.

As a stand-alone Web site: It resides on your computer, and you can use it anywhere. No need for Internet access.
At this Web site: If you have access to the Internet whenever you want to view this material, you can purchase on-line access. Unlimited usage. I'm constantly making improvements and you'll get them as soon as they're available.

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.

Add this item to your order

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.

Add this item to your order

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.

Add this item to your order

Or order via Google Checkout.

To Order by Mail

Make your check payable to Chaco Canyon Consulting, for the amount indicated:

For the download: USD 199.00
For access online for three months: USD 199.00
For access online for one month: USD 69.95

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.

Spreadsheet Models for Managers

This reading is especially relevant for Session 1Worksheet Functions

A worksheet function is similar to a mathematical function. It accepts arguments, and returns a value or values. You can use a variety of worksheet functions in cell formulas. This page describes their use, how to determine which ones to use, and the language we use to discuss them.

ells in a worksheet can contain formulas that are used to determine the value of the cell. Perhaps the simplest formula is a simple number or string of text. More complex formulas can combine the values of other cells, or the results of functions, which in turn can depend on the values of other cells. These more complex formulas must begin with an equal sign. For example, a cell that contains the formula

=D5+D4

computes its own value by adding together the values of D5 and D4.

This page has a variety of information about worksheet functions:

How we talk about worksheet functions
How to enter a worksheet function into a formula
Which worksheet functions will you need?
How to learn about these worksheet functions
A complete list of Excel's worksheet functions

How we talk about
worksheet functions

Since the language we use to talk about worksheet functions can affect how we understand them, it's important that we speak about them in a consistent way. You can find a variety of "dialects" of pseudo-mathematical language floating about, and probably one isn't much better than another. In this course, though, we'll agree to use certain standard terminology, described here.

To invoke a worksheet function in the context of a cell formula, one calls a worksheet function. Often, you hear this described as "applying a worksheet function." Do not use that terminology. For example, we will speak of "calling a function on its arguments," or "calling a function with its arguments." We do not say that we "apply a function to its arguments.".

When Excel calculates the value of a cell, and that cell's formula contains a call to a worksheet function, that function call is evaluated. Its value is then returned to the formula, which uses it, in turn, to compute its own value.

Sometimes you hear worksheet functions referred to as commands. They aren't commands. Commands are found on Excel's menus, or perhaps in some dialog boxes. Commands do things, like format a cell, or sort a range. Commands don't return values — functions return values.

How to enter
a worksheet function
into a formula

Formulas in Excel worksheet cells can include calls to worksheet functions. The syntax of worksheet functions is

<snip>…

Some of the page you've been reading has been suppressed from this sampler. To see the complete version of this article, why not order the full course? It's available at this Web site or in downloadable format.

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.

Add this item to your order

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.

Add this item to your order

Or order via Google Checkout.

More Info

…<end snip>

Excel's worksheet functions

A complete list of worksheet functions, with links to detailed help on each one, is available at Microsoft's Web site.

For more about my spreadsheet consulting and training services, visit SpreadsheetAce.com.

Feeling queasy about spreadsheets?

We run our companies, in part, based on spreadsheets, yet we often wonder if they're really right. Learn more about improving the reliability and effectiveness of your financial models.

With dozens of solved problems and special course tools, this course can dramatically increase your spreadsheet skills. For just USD 199.00 you receive three months of access with unlimited email support. Learn more about improving your spreadsheet sophistication and effectiveness.

Get the Hyperbook Edition of This Course

Identical to the edition you're viewing, but with dozens of solved problems and special course tools, and it stands alone — no Internet connection required. For just USD 199.00, it includes three months of unlimited email support. Learn more about improving your spreadsheet sophistication and effectiveness.

Spreadsheet Models for Managers

Getting Access to Spreadsheet Models for Managers

Spreadsheet Models for Managers

This reading is especially relevant for Session 1Worksheet Functions

Instructor Contact Information

Author Contact Information