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 receive download instructions by return email.
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 Twitter, or share a tweet Follow me at Google+ 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.
21st Century Business TravelAre your business trips long chains of stressful misadventures? Have you ever wondered if there's a better way to get from here to there relaxed and refreshed? First class travel is one alternative, but you can do almost as well (without the high costs) if you know the tricks of the masters of 21st-century e-enabled business travel…
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.
Credit cards we accept