Skip to Main Content
iWork '09: The Missing Manual
book

iWork '09: The Missing Manual

by Josh Clark
April 2009
Intermediate to advanced content levelIntermediate to advanced
888 pages
40h
English
O'Reilly Media, Inc.
Content preview from iWork '09: The Missing Manual

Chapter 17. Creating a Numbers Spreadsheet

Don’t be fooled by its name: Numbers has a mind for math, sure, but the iWork spreadsheet program does much more than just crunch digits. If you’ve always thought of spreadsheets as the exclusive and arcane domain of the Accounting Department down the hall, think again. Numbers can juggle figures for the most demanding spreadsheet jockeys, but you can also use it to store and organize just about any kind of information.

A spreadsheet is a list machine: Use it for to-do lists, contact lists, event planning, team rosters, product inventories, invoices—anything you might put into a list or table, you can put in a spreadsheet. And then Numbers can make your list dance. Once you’ve plugged your data into Numbers, you can sort it, filter it, categorize it, or combine it with data from other lists. Numbers isn’t just a fancy calculator, in other words; you can use it as your own private database—a place where you store, manipulate, and view data from all kinds of different angles.

And of course Numbers can do math, too. When your data happens to take the form of digits—class grades, your check register, a valuation of assets minus depreciation—Numbers churns through your calculations, updating your totals as you add and edit data. The program knows more than 250 functions, feats of mathematical gymnastics that range from simple addition to complex accounting algorithms.

But all that is standard stuff, describing the basic work of spreadsheet programs ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

iWork: The Missing Manual

iWork: The Missing Manual

Jessica Thornsby, Josh Clark

Publisher Resources

ISBN: 9780596802073Errata Page