O'Reilly logo

How Libraries Should Manage Data by Brian Cox

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

6

Stop, police!

This chapter explains why it is important to make robust user proof spreadsheets, and how to create spreadsheets that users cannot break. Readers are encouraged to think beyond their own needs for spreadsheets, and to consider the change in approach that is required when creating spreadsheets for wider distribution. There are a number of tools available to maximize data integrity, including data validation, hiding data, tables, and limiting what uses can do with cells. These tools are explained in simple step-by-step terms, using library specific examples. For the readers that are interested in stretching themselves, this chapter also explains the use value of dependent lookups, and explains in detail how these formulas work.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required