iWork® '09 Portable Genius

Chapter 8. How Can I Make My Spreadsheets Dynamic?

When you've entered all the data the spreadsheet needs, it's time to make the spreadsheet look compelling. Start by using Numbers' table styles to format each table, using conditional formatting to monitor cells for unexpected values, and sorting and filtering each table so that it shows only the data you want to see. You can create powerful charts that draw data from different tables, share them with Pages and Keynote, and even update them from within a document or a presentation. For extra visual impact, you can add images to a sheet, cell, table, or other object; and for convenience, you can add dynamic controls that let the user manipulate values accurately and easily.

Making a Table Look Exactly How You Want It

Creating Charts from Your Table Data

Customizing and Modifying Table Styles

Adding Media with the Media Browser

Adding Controls to Cells

Making a Table Look Exactly How You Want It

This section shows you how to make each table look exactly the way you want it by applying table styles, using conditional formatting to automatically monitor cells for unexpected values, and filtering a table so that it shows only the data you're interested in.

Formatting a table with a table style

A quick way to make a table look good is to apply a table style from the Styles pane. A table style is a complete set of formatting for a table, including ...