Spreadsheet Models for Managers

Getting Access to Spreadsheet Models for Managers

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

Apparently, you’re using a browser that has JavaScript disabled. This Web site uses JavaScript, especially for
some of its navigation features. If you want to make those features available, you must enable JavaScript. Please open your browser's
preferences dialog and enable JavaScript at your earliest convenience. Instructions: for Internet Explorer 9.x; for Internet Explorer Version 8.x;Internet Explorer Version 7.x;
for Firefox.

Spreadsheet Models for Managers

Gathering and understanding requirements are important parts of your project

Examples of requirements

How to gather requirements systematically

Course project proposals

How to merge workbooks

In our last session, we explored requirements. We talked about how important it is to capture
requirements before you start a piece of work, and once captured, how important it is to
truly understand them. We looked at some examples of converting the prose description of
elements of your project into actual, concise requirements. And we showed you a systematic
method for gathering your project requirements.

We also explored a method for merging two workbooks that have evolved slightly from a shared
ancestor. This technique is important for those of you working on your projects in teams.

We also discussed course project proposals. Remember: you need an approved proposal before you can
proceed with the project.

The purpose of charts is visual communication. Sadly, many charts that contain important
information don’t communicate that information very well. Communicating visually in an
effective manner is probably an art, but it’s an art we can learn.

One way to learn is by bad examples — actually studying examples of bad technique.
Fortunately, bad examples are easy to find. Finding good
examples is more difficult, but there are several excellent references in the class notes. Enjoy!