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

7

Pivot magic

This chapter draws together the technical discussion in the previous chapters to arrive at the point where readers will be able to create robust user-friendly spreadsheets that they will be proud of distributing. More importantly readers that follow these instructions will be able to very quickly and accurately interrogate their operational data. This chapter explains step-by-step how to create pivot tables, and explains how to create a template that can be used to manage all your spreadsheets. On completion of this chapter, readers will be able to produce robust spreadsheets that have a consistent look and feel, and from a user’s point of view, look more like a word document than a spreadsheet.

Keywords

Pivot tables; user friendly ...

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