Spreadsheet Models for Managers

Session 1

Introduction to Spreadsheet Models
Summary of Pages

hat's a spreadsheet model? What's the role of spreadsheet modeling in a modern organization? An effective modeling capability provides a competitive edge — if an organization can quickly and effectively model its processes, markets, and finances, it can make better decisions faster.

But to be effective, models must be simple, maintainable, and faithful. In this session, we begin a survey of modeling techniques that support these three goals. Our first topics include examples of calculation techniques, development techniques, and Excel technology.

Among the most basic of calculation techniques are two common spreadsheet clichés — running sums and running differences. We also look at parameters and parameter names — a development technique that provides a strong foundation for maintainability. Finally, a bit of Excel technology that is a key to modeling mastery: absolute references and relative references. We'll straighten out any confusion you might have about the dollar sign, and make it your friend.

Below is a summary of pages for Session 1.

1. Contact Info
2. Course Materials
3. Software You Need
4. Your Deliverables
5. Teamwork
6. Grades
7. Session Schedule
8. Homework Guidelines
9. How to Work
10. About the Homework Problems
11. Course Project
12. Learning
13. Course Materials
14. Storing Course Files
15. These Pages
16. The Practice of Business Is Changing
17. How Can Small Business Units Make Complex Decisions?
18. Two Key Messages
19. We Use Microsoft Excel
20. Course Objectives
21. What Is Modeling?
22. Running Sums
23. Running Differences
24. Named Parameters
25. Choosing Names for Parameters
26. Name Scope
27. Relative and Absolute References
28. Advanced Use of Names
29. Readings and References
30. Preview of Next Time

Links to other materials for Session 1.