Enterprise Spreadsheet Management: A Hyperbook

It's time once again for Skip to the Details:
How To Order
the annual budget exercise. The templates have gone out, and you wonder — when should I start filling it out? Should I get started right away? Or should I at least wait for the first recall, so I won't waste my time again this year?

Or you're managing the proposal process, and you need inputs from all the task leaders. You send out the templates, hoping that they contain no errors this time. They don't, but then Finance changes some of the enterprise-wide load factors that are built into your templates. And some of the task leaders call to let you know that there aren't enough rows in one of the template sections for their needs. So you give them a special version, and resolve to handle theirs by hand.

It doesn't have to be this way.Enterprise Spreadsheet Management

Enterprise Spreadsheet Management, downloadable hyperbook Edition shows you another approach to gathering and managing enterprise data using spreadsheets.

This Hyperbook — available on line or as a stand-alone Web site that you read with your Web browser — is packed with tips, techniques, tools and dozens of worked examples that show you:

  • How to build templates that prevent user errors
  • How to construct spreadsheets that flex with user needs, without writing complicated macros
  • How to provide users with tools that make everyone's lives — yours and theirs — easier
  • How to avoid recalls, and how to manage them when you can't avoid them
  • How to keep maintenance costs to a minimum

Here's a sampling of topics:

  • Controlling User Input: Styles, validations and templates
  • Filling Your Toolbox: Function macros, command macros and add-ins
  • Taming the Rollup Monster: Architecture for maintenance
  • Agile Spreadsheets: Structuring worksheets for fast-turn maintenance and development
  • Simple Databases: Using worksheets to store data about your system
  • Managing Spreadsheet Development Projects: Spreadsheet inspections
  • Data Migration: Moving data from place to place
  • Managing Orderly Recalls: Techniques for automatic mitigation
  • Accommodating Variation: Providing for idiosyncratic needs of users
  • Quality and Testing: Finding defects before going into production
  • Security: Protecting confidential data
  • Distribution, Release, Training and Customer Support
  • Sharing Assets: Managing shared tools and workbooks

Two formats

This course is available in two formats. Both of them include worked examples and demonstrations, and both have a search capability to help you find exactly what you're looking for.

On line
It's available at this Web site, for those who have good access to the Internet and want to have the benefit of the continuous improvements I'm constantly making to the course.
Downloadable hyperbook
Or order it as a downloadable zip file. It's only about 5.0 MBytes compressed.

Details

Order on line using your credit card, or send a check payable to Chaco Canyon Consulting to the address below. Call for volume or site license pricing at the phone number below.

Order here

Order Enterprise Spreadsheet Management, on-line edition, 3 mos. by credit card, for each, using our secure server, and you'll receive login instructions shortly.
Add to Cart
Order Enterprise Spreadsheet Management, downloadable hyperbook Edition by credit card, for each, using our secure server, and receive download instructions by return email.
Add to Cart

Follow Rick

Send email or subscribe to one of my newsletters Follow me at LinkedIn Follow me at X, or share a post 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!
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.
More Excel-
related resources
Check these out:
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.
Ebooks, booklets and tip books on project management, conflict, writing email, effective meetings and more.
303 Secrets of Workplace PoliticsIs every other day a tense, anxious, angry misery as you watch people around you, who couldn't even think their way through a game of Jacks, win at workplace politics and steal the credit and glory for just about everyone's best work including yours? Read 303 Secrets of Workplace Politics!
101 Tips for Effective MeetingsLearn how to make meetings more productive — and more rare.
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!