Spreadsheet Models for Managers

Tedium, Boredom, Wasted Time, Wasted Work, Errors, Recalls, Data Re-entry, Data Re-Re-Entry. The lives of spreadsheet modeler and the lives of the modeler's customers aren't pretty. The tragedy is that most of the pain, waste, and missed deadlines are so unnecessary.

Spreadsheets are wonderful tools. They help us track what is, figure out what was, and they help us predict what will be. Despite the popularity of spreadsheets, despite their wide use, and despite our familiarity with them, most of us receive only a fraction of the benefit we could derive from our work with spreadsheets. Most of us can benefit from using some simple yet sophisticated techniques that remain relatively little known. In the Spreadsheet Models for Managers Workshop, participants learn:

  • How to manage spreadsheet development projects
  • How to build high-reliability and low-maintenance models of businesses and business processes using spreadsheets
  • How to exploit sophisticated mathematical techniques to reduce modeling errors and maintenance problems.

The overall philosophy is that you shouldn't need a Ph.D. to create a high-value business model that lets you predict the performance of a business process. A simple spreadsheet model is probably good enough for most business purposes, given the rapid pace of change in today's markets. But when you do make a model, it should be easy to understand and maintain, and it should be right.

This workshop is based on a course called Spreadsheet Models for Managers, which I began developing at the Harvard Extension School in 1993, and which I taught there for 21 years, until 2014. At Harvard, and wherever I've taught the course, I've had the benefit of questions, praise, complaints, wishes, and criticism from hundreds students.

Workshop Structure

I can customize the structure of the workshop to your needs. I recommend a sequence of two-hour meetings, with homework interspersed, for maximum learning opportunity. But it can also be formatted as a sequence of full-day or half-day workshops for maximum cost-effectiveness.

Topics

Over twenty-four hours of high-value course content is available. Choose the topics most valuable to you:

  • Accumulations and derivations: running sums, running differences
  • Relative and absolute references: what the heck are they good for?
  • Operations on references: unions, intersections, and compound ranges
  • Named parameters, parameter blocks: save time and reduce maintenance costs
  • Drilling down and rolling up: tools for doing either one effectively
  • Array formulas: manipulate whole ranges, not single cells
  • Matrix multiplication: do in one row what others do in twenty
  • Safety margins and crowding: save money by managing your resources
  • Circular reference headaches: how to resolve them
  • Convolution: simplify calculations involving time variation
  • Use convolution for multiple lease events
  • Terminology, styles, and tips for effective charts
  • Using charts to catch errors in models
  • Key practices for organizations that use spreadsheet technology on an enterprise scale
  • Formal technical reviews of spreadsheets: reduce errors and educate your team
  • Writing macros using Visual Basic for Applications
  • Inventory modeling: Economic Order Quantity (EOQ)
  • Purchasing decisions in the context of volume discounting
  • Modeling waiting lines
  • The Fast Food Drive-Thru: How long should the driveway be?

Target audience

Managers of businesses and business units who want to learn best practices of business modeling. Modelers who want to hone their skills and learn new tools.

Workshop requirements

This is a hands-on workshop. To get maximum benefit, each participant should bring their own laptop computer, and their own copy of Microsoft ® Excel 2010 or later. Software specific to the course content is provided.

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

Follow Rick

Send email or subscribe to one of my newsletters Follow me at LinkedIn Follow me at X, or share a tweet Subscribe to RSS feeds Subscribe to RSS feeds
The message of Point Lookout is unique. Help get the message out. Please donate to help keep Point Lookout available for free to everyone.
Technical Debt for Policymakers BlogMy blog, Technical Debt for Policymakers, offers resources, insights, and conversations of interest to policymakers who are concerned with managing technical debt within their organizations. Get the millstone of technical debt off the neck of your organization!
What People Say About Rick's Programs
  • "Rick is a dynamic presenter who thinks on his feet to keep the material relevant to the group."
    — Tina L. Lawson, Technical Project Manager, BankOne (now J.P. Morgan Chase)
  • "Rick truly has his finger on the pulse of teams and their communication."
    — Mark Middleton, Team Lead, SERS
Spreadsheet Models for ManagersA stand-alone Web site you read with your Web browser — is packed with tips, techniques, and dozens of worked examples for people who want their spreadsheet projects to be more reliable, more flexible, and most important: done on time.
More Excel-
related resources
Check these out:
Ebooks, booklets and tip books on project management, conflict, writing email, effective meetings and more.
Go For It: Sometimes It's Easier If You RunBad boss, long commute, troubling ethical questions, hateful colleague? Learn what we can do when we love the work but not the job.
If your teams don't yet consistently achieve state-of-the-art teamwork, check out this catalog. Help is just a few clicks/taps away!