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

5

Getting the most out of your raw data

This chapter explains in simple step-by-step terms how to create spreadsheets that will make it easy to extract information from your raw data: information that can be used to drive business decisions. This chapter is targeted at the occasional Excel user, or Excel novice, but covers fundamental principles of good formula writing that even frequent Excel users would benefit from revisiting. A number of key formulas that readers will need to use frequently are explained in detail, using library examples. More sophisticated formulas are also discussed, including dynamic named ranges, how they are structured, and how to write these formulas.

Keywords

Absolute and relative addressing; formula writing; basic formulas; ...

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