You are previewing iWork '09: The Missing Manual.
O'Reilly logo
iWork '09: The Missing Manual

Book Description

With iWork '09, Apple's productivity applications have come of age. Unfortunately, their user guides are stuck in infancy. That's where iWork '09: The Missing Manual comes in. This book quickly guides you through everything you need to know about the Pages word-processor, the Numbers spreadsheet, and the Keynote presentation program that Al Gore and Steve Jobs made famous. Friendly and entertaining, iWork '09: The Missing Manual gives you crystal-clear and jargon-free explanations of iWork's capabilities, its advantages over similar programs -- and its limitations. You'll see these programs through an objective lens that shows you which features work well and which don't. With this book, you will:

  • Produce stunning documents and cinema-quality digital presentations

  • Take advantage of Mac OS X's advanced typography and graphics capabilities

  • Learn how to use the collection of themes and templates included with iWork

  • Get undocumented tips, tricks, and secrets for each program

  • Integrate with other iLife programs to use photos, audio, and video clips

Learn why iWork is the topic most requested by Missing Manual fans. One of the few sources available on Apple's incredible suite of programs, iWork '09: The Missing Manual will help you get the best performance out of Pages, Numbers, Keynote, and more in no time.

Table of Contents

  1. iWork '09: The Missing Manual
    1. SPECIAL OFFER: Upgrade this ebook with O’Reilly
    2. The Missing Credits
      1. About the Author
      2. About the Creative Team
      3. Acknowledgments
      4. Photo Credits
      5. The Missing Manual Series
    3. Introduction
      1. What You Can Do with iWork '09
        1. Pages: Word Processing Meets Graphic Design
        2. Keynote: Presentations with Gusto
        3. Numbers: Crunching Data with Style
        4. A Family Resemblance
        5. How Does It Stack Up Against Microsoft Office?
      2. What's New in iWork '09
        1. New in Pages '09
        2. New in Keynote '09
        3. New in Numbers '09
      3. The Very Basics
      4. About This Book
        1. About → These → Arrows
        2. About
        3. Safari® Books Online
    4. I. Pages '09
      1. 1. Creating a Pages Document
        1. Two Programs in One
          1. Meet Pages, the Word Processor
          2. Meet Pages, the Page-Layout Program
          3. Choose Your Weapon
        2. Using Templates for Ready-to-Go Documents
        3. Your First Word-Processing Document
          1. Integration with Address Book
          2. In Your Own Words
          3. Save and Print
          4. Other Word-Processing Document Types
        4. Your First Page-Layout Document
          1. Working with Text Boxes
            1. Selecting and editing text
          2. Adding Pictures from iPhoto
            1. Coping with snipped images
          3. Adding Pages and New Layouts
            1. Continuing text from a previous page
            2. One page at a time
        5. In the Buff: The Blank Template
          1. Setting Your Default Template
        6. Opening an Existing Document
          1. Importing Files from Another Program
            1. The Document Warnings window
        7. Controlling the Document Window
          1. Using the Toolbar
            1. Customizing the toolbar
          2. Shape Shifter: The Format Bar
          3. Changing Your Page View
          4. Navigating Your Document
            1. Thumbnail view
            2. The Search sidebar
          5. Editing in Full-Screen View
      2. 2. Editing Text in Pages
        1. Word Processor Text vs. Text Boxes
        2. Basic Text Editing in iWork
          1. Inserting Text
          2. Deleting Text
          3. Making a Selection
            1. Using mass selection techniques
            2. Using keyboard selection techniques
          4. Cutting, Copying, and Pasting
            1. Keep your Paste clean: Paste and Match Style
          5. Using Drag-and-Drop Editing
          6. Using Shortcut Menus
        3. Undoing and Backing Up
          1. Backing Up the Previous Version of a Document
        4. Changing Font Styles and Appearance
          1. The Fonts Window
          2. Setting Colors and Character Spacing in the Text Inspector
            1. The Color Picker
            2. Spread the word: Character Spacing
            3. Lifting your letters with Baseline Shift
          3. The Format → Font Menu
        5. Formatting Paragraphs
          1. Aligning Your Text
            1. Align left
            2. Justified
            3. Align right
            4. Centered
          2. Between the Lines: Line Spacing
          3. Spacing Your Paragraphs
            1. Line breaks vs. paragraph breaks
          4. Setting Tabs
            1. Working with custom tab stops
            2. Fine-tuning your tabs in the Text Inspector
          5. Indenting Text
          6. Setting Paragraph Borders and Background Color
            1. Adding borders and rules
            2. Paragraph background color
          7. Coping with Break-Ups
            1. Inserting a page break
            2. Caring for widows and orphans
            3. Keeping lines and paragraphs together
        6. Spaces, Invisibles, and Special Characters
          1. Viewing Invisibles
          2. Inserting Special Characters and Symbols
        7. Working with Lists
          1. Using List Styles
          2. Organizing and Nesting Your Lists
            1. Moving list items
            2. Labeling nested lists
      3. 3. Creating and Using Styles
        1. When You Need Styles: Know the Warning Signs
        2. Style Central: Meet the Styles Drawer
        3. Applying Styles
          1. Style Overrides
        4. Creating Styles by Example
          1. Modifying Existing Paragraph and List Styles
          2. Creating New Paragraph and List Styles
          3. Modifying Existing Character Styles
          4. Creating New Character Styles
        5. Finding and Copying Styles
          1. Copying Styles
          2. Importing Styles from Another Document
        6. Changing the Default Font
      4. 4. Typo-Busting Power Tools
        1. Changing Your Mind: Find & Replace
          1. Find
          2. Find & Replace
            1. Reviewing each change
            2. Replace all automatically
            3. Whole words vs. partial matches
            4. Searching for spaces and invisible characters
            5. Style-conscious searching
        2. Spell Checking
          1. Check Spelling As You Type
          2. Check Spelling in the Document or Selection
          3. Using Foreign-Language Dictionaries
        3. Reference Tools
          1. Look up Words in the Dictionary or Thesaurus
          2. Find It on the Web: Wikipedia or Google Search
          3. Find It on Your Computer: Spotlight Search
          4. For the Obsessive: Document Stats
            1. Word count and other statistics
            2. Author, title, comments, and keywords
            3. File size and dates
        4. The Proofreader
          1. Proofread Your Document
          2. Proofread as You Type
        5. Auto-Correction and Text Substitution
        6. Tracking Changes
          1. Starting and Stopping Change Tracking
          2. Reviewing, Accepting, and Rejecting Changes
          3. Controlling the Markup Display
            1. Showing and hiding changes
            2. Changing your color and name
            3. Changing the style of new and deleted text
          4. Adding Comments
          5. Wiping the Change History
      5. 5. Document Format and Organization
        1. Document Formatting
          1. Password-Protecting Your Document
          2. Page Setup
          3. Adjusting Page Margins
            1. Facing pages
          4. Working with Headers and Footers
            1. Adding a header or footer
            2. First page is different
            3. Left and right pages are different
          5. The Fine Print: Footnotes and Endnotes
            1. Adding notes
            2. Setting your display preferences for notes
          6. Automatic Hyphenation
          7. Using Ligatures
        2. Organizing Your Document with Sections
          1. Adding Sections
            1. Page numbering
            2. Customizing headers and footers
            3. Setting the start page
          2. Rearranging and Deleting Sections
          3. Layouts and Multiple Columns
            1. Adding columns
            2. Adjusting the number of columns
            3. Adjusting column width
            4. Column breaks
            5. Layout breaks
          4. Capturing and Reusing Sections
        3. Auto-Entry: Formatted Text Fields
          1. Page Numbers and Page Counts
            1. Adding a page count
          2. Inserting the Date and Time
          3. Displaying the Filename
        4. Mail Merge with Address Book or Numbers
          1. Using Merge Fields in Templates
            1. Home vs. work addresses
          2. Managing Mass Mailings with Address Book Groups
          3. Merging Data from a Numbers Spreadsheet
          4. Adding Merge Fields to Your Own Documents
        5. Adding a Table of Contents
          1. Modifying a Table of Contents
        6. Hyperlinks and Bookmarks
          1. Adding Bookmark Links
          2. Linking to Another Pages Document
          3. Adding Web Page Links
          4. Adding Email Message Links
        7. Organizing Text with Outlines
          1. Getting Started: Outline Templates
            1. Working with outline topic headings
            2. Working with body text in an outline
            3. Focusing and compressing your outline view
          2. Building an Outline from Scratch
            1. Automatic heading styles
            2. Adding pictures and other objects to your outline
            3. Saving and printing outlines
      6. 6. Beyond Text: Laying Out Pages
        1. Templates: The Key to Prefab Page Designs
          1. Working with Placeholder Text
          2. Working with Media Placeholders
          3. Immovable Objects: Locked, Background, and Master Objects
        2. Planning a Layout from Scratch
          1. More or Less, "Less Is More"
            1. White space
            2. Font restraint
            3. Color palette
          2. Collecting Your Materials
            1. Writing your text
            2. Assembling an album of working images
            3. Building a playlist of music and movies
        3. Creating a Page-Layout Document
          1. Fine-Tuning Your Document Settings
          2. Page Layout vs. Word Processing
        4. Get on the Grid
          1. Using Alignment Guides
          2. Building a Grid of Your Own
      7. 7. Objects Up Close: Adding, Modifying, and More
        1. Floating vs. Inline Objects
          1. Floating Objects
          2. Inline Objects
          3. Converting an Object's Layout Style
        2. Adding Objects
          1. Adding Text Boxes
            1. Linking text boxes
            2. Breaking the link between text boxes
            3. Inserting a text box into a linked chain
            4. Formatting text boxes
            5. Combining text boxes with other objects
            6. Pull quotes and sidebars
            7. Adding columns to text boxes
          2. Adding Images
            1. Meet the Media Browser
            2. Choosing a file from your hard disk
            3. Cropping images with masks
            4. Morphing pictures into new shapes with masks
            5. Removing the background with "instant alpha"
            6. The Adjust Image window
            7. Frame it
            8. Reducing image file sizes
            9. Including or excluding template images
          3. Adding Shapes
            1. The line shapes
            2. The geometric shapes
            3. The arrow shapes
            4. The speech bubbles
            5. Stars and polygons
            6. Drawing custom shapes
            7. Editing shapes point by point
            8. Text in shapes
          4. Adding Sound and Video
            1. Managing movie and sound file sizes
        3. Working with Objects
          1. Selecting Objects
          2. Moving Objects
          3. Resizing Objects
          4. Wrapping Text Around Objects
          5. Rotating and Flipping Objects
          6. Connecting Objects
          7. Distributing and Aligning Objects
          8. Arranging Objects
            1. Layering objects
            2. Sending objects to the background
            3. Repeating elements with master objects
            4. Grouping objects
            5. Locking objects
        4. Modifying Object Styles
          1. Filling with Colors, Gradients, and Images
            1. Choosing colors with the Color Picker
            2. Gradient fills
            3. Filling with Images
            4. Adding Tinted Image Fills
          2. Adjusting Line Styles
          3. Adding Shadows and Reflections
          4. Adjusting Opacity
        5. Copying Objects and Graphic Styles
      8. 8. Building Tables and Charts
        1. Making Tables
          1. Inserting Inline Tables
          2. Inserting Floating Tables
          3. Selecting Tables, Cells, and Text
          4. Typing into Table Cells
            1. Automatically resizing table rows
            2. Moving cell content
          5. Adding and Deleting Rows and Columns
            1. Labeling tables with header rows, header columns, and footer rows
          6. Setting the Data Type with Cell Format
          7. Sorting Table Rows
          8. Formatting Tables
            1. Adding backgrounds
            2. Formatting cell borders
            3. Resizing cells, rows, and columns
            4. Splitting and merging cells
            5. Setting graphic styles
            6. Monitoring cell values with conditional formatting
          9. Autofilling Table Cells
        2. Making Mini-Spreadsheets with Formulas
          1. "Quick Formulas" for Common Calculations
            1. Using header rows and columns with quick formulas
            2. Using a range of cells with quick formula
            3. Adding a quick formula to a single cell
            4. Removing a formula
          2. The Formula Editor
            1. Coping with formula errors
          3. Moving Formulas
          4. Using Numbers Tables in Pages and Vice Versa
        3. Creating Charts
          1. Inserting Charts
            1. Understanding data series and data sets
          2. Entering Data in the Chart Data Editor
            1. Copying spreadsheet or table data into your chart
          3. Using Charts from Numbers
          4. Changing the Type of Chart
          5. Formatting Charts
      9. 9. Sharing Pages Documents
        1. Printing Your Documents
          1. Page Setup
          2. The Print Window
        2. Exporting Documents
          1. Exporting Microsoft Word
          2. Exporting RTF
          3. Exporting Plain Text
          4. Exporting PDF
          5. Saving as iWork '08
          6. Emailing Your Document
        3. Sharing on
          1. Sending Your Document to
          2. Viewing the Document on
          3. Adding and Viewing Comments
          4. Adding Notes to
          5. Downloading the Document
          6. Republishing a Document
          7. Reviewing your Shared Documents
          8. Managing Viewers
        4. Publishing Online with iWeb
      10. 10. Streamline Your Projects: Creating Templates
        1. Template-Building Basics
        2. Modifying an Existing Template
        3. Creating Templates from Scratch
          1. Defining Text Styles
          2. Setting Document Formatting
          3. Defining Object Styles
            1. Text boxes
            2. Shapes
            3. Connection lines
            4. Tables
            5. Charts
            6. Images
            7. Movies
            8. Changing your mind
          4. Making Placeholders
            1. Regular text and placeholder text
            2. Merge and sender fields
            3. Media placeholders for pictures, movies, and sound
          5. Building Multipage Templates
        4. Organizing Templates
        5. Sharing, Exchanging, and Buying Templates
          1. Templates Online
    5. II. Keynote '09
      1. 11. Planning and Giving Great Presentations
        1. Planning the Presentation
          1. The Goals of Your Presentation
          2. Know Your Audience
            1. Tailor the presentation to the audience
            2. Speech vs. performance
          3. The Slideshow's Role in Your Presentation
        2. Building the Presentation
          1. Outline Your Talk
          2. Find Great Images
            1. Copyright and Creative Commons
            2. Free online resources
            3. Commercial stock-photo houses
            4. Organize your materials
          3. Design Your Keynote Slideshow
            1. Your talk is not bullet points
            2. It's about ideas, not special effects
            3. Need handouts?
          4. Practice
            1. The first run-through
            2. Don't stop practicing
          5. Backup
        3. Delivering the Presentation
          1. Handle the Preliminaries
          2. Set the Mood
          3. Give the Presentation
            1. Nerves: Don't throw up
            2. Talk to them
            3. Review
          4. The Day After
        4. Presentation Setting and Gear
          1. Get a Room
          2. The Mighty Dongle
          3. Projectors
            1. Choosing a projector
            2. Renting projectors
            3. Projection screens
          4. Remote Controls
            1. Keynote Remote for iPhone or iPod Touch
            2. The Apple Remote
            3. Other Remote Controls
      2. 12. Creating a Keynote Slideshow
        1. Themes = Templates
        2. Your First Keynote Slideshow
          1. Familiar Faces: The Toolbar, Format Bar, and Inspectors
            1. The toolbar
            2. The Format Bar
            3. The inspectors
          2. Slide Size and Slide View
          3. Adding Your Text
          4. Changing the Slide Layout with Master Slides
          5. Adding an Image
          6. Slide Design Works Just Like Page Layout
            1. Make your text fit with auto-shrink
            2. Add the snapshots
            3. Adding other objects to your slides
            4. Going back to the master slide layout
          7. Adding and Inserting Slides
            1. Creating slides from the Media Browser
            2. A blank slate
          8. Adding Slide Transitions
          9. Changing the Theme
          10. Using the Presenter Notes Pane
          11. Playing the Slideshow
        3. Browsing and Organizing Your Slides
          1. The Slide Navigator
          2. Navigator View
            1. Duplicating slides
            2. Organizing and grouping slides
            3. Deleting slides
            4. Skipping slides
          3. Outline View
            1. Entering outline text
            2. Moving outline text and bullets
            3. Selecting multiple bullet points
            4. Printing the outline
          4. Light Table View
        4. Saving Your Slideshow
          1. Automatic Backups
        5. Opening an Existing Slideshow
          1. Importing Files from Another Program
      3. 13. Laying Out Your Slides
        1. Setting Up the Keynote Document
          1. Choosing a Presentation Style
          2. Password-Protecting Your Slideshow
        2. Working with Objects
          1. Selecting Objects
          2. Moving and Copying Objects
          3. Resizing, Rotating, and Flipping Objects
          4. Connecting Objects
          5. Styling Objects
          6. Copying and Reusing Object Styles
            1. Copy Style and Paste Style
            2. Applying an object style with master slides
            3. Reapply Master
            4. Paste and Match Style
          7. Layering Objects
          8. Aligning Objects
            1. Automatic alignment guides
            2. Using relative sizing and spacing guides
            3. Drawing your own alignment guides
            4. Switching on the master grid
            5. Changing the grid and guide colors
            6. One-click object alignment
          9. Grouping and Locking Objects
        3. Adding and Formatting Text Boxes
          1. Inserting Title and Body Text Boxes
          2. Inserting Free Text Boxes
          3. Editing Text in Keynote
            1. Working with lists and bullets
            2. Clipped text and auto-shrink
            3. Check your spelling
            4. Smart quotes and auto-correction
          4. Formatting Text
            1. The Fonts window
            2. The Text Inspector
            3. The Format menu
            4. Setting margins, indents, and tabs with the ruler
        4. Inserting Photos and Other Graphics
          1. Replacing Media Placeholders
          2. Adding and Editing Pictures
            1. Creating new slides from pictures
          3. Managing File Sizes for Image-Heavy Slideshows
            1. Up with downsampling: Shrinking big images
            2. Reducing file size
            3. Including or excluding theme images
        5. Making Shapes
        6. Building Tables and Charts
          1. Using Numbers Charts in Your Slideshow
        7. Adding Movies
          1. Playing Movies
          2. Managing Multimedia Files
        8. Making Noise: Sounds and Soundtracks
          1. Adding a Soundtrack
          2. Adding Sound to a Single Slide
        9. Working with Hyperlinks
          1. Linking to Slides
          2. Surfing the Web
            1. Automatic hyperlinks
          3. Linking to Other Slideshows
          4. Sending Email
        10. Note to Self: Add a Comment
        11. Changing Slide Backgrounds
        12. Adding Slide Numbers
      4. 14. Animating Your Slides
        1. Adding Transitions
          1. Switching Slides with 2D and 3D Effects
          2. Adding Object Effects
          3. Wordplay with Text Effects
          4. Magic Move Transitions
          5. Old-School Transitions
        2. Adding Object Builds
          1. Creating Build Ins and Build Outs
            1. Building text boxes and shapes
            2. Building tables
            3. Building charts
          2. Controlling Movies and Sounds with Builds
          3. Using Smart Builds for Single-Slide Slideshows
            1. Creating a smart build
            2. Editing smart-build settings
        3. Ordering and Automating Builds
          1. Playing Builds Automatically or Simultaneously
          2. Mingling Builds of Text, Tables, Charts, and Images
        4. Adding Animations with Action Builds
          1. Moving Objects Along a Path
          2. Multiple Action Builds
        5. Copying Builds to Other Objects
      5. 15. Sharing Your Slideshows
        1. Setting Up the Presentation
          1. Setting Slideshow Preferences
          2. Setting Up the Presenter Display
            1. Playing a slideshow from the presenter display
            2. Customizing the presenter display
            3. Using the presenter display during the presentation
            4. Using the edit view during the presentation
          3. Connecting a Second Display
          4. Connecting Your Audio Output
          5. Set Up the Remote Control
        2. Playing Keynote Slideshows
          1. Controlling the Presentation
            1. Navigating through builds
            2. Hopping around the slideshow with the slide switcher
            3. Playing movies
            4. Opening links and other programs
            5. Pausing the show
            6. Calling up the keyboard cheat sheet
          2. Keynote Remote with iPhone or iPod Touch
            1. Linking your iPhone to your computer
            2. Playing the slideshow with Keynote Remote
        3. Creating Self-Playing Slideshows
          1. Timed Slideshows
          2. Recorded Slideshows
        4. Setting Up Hyperlinks-Only Slideshows
        5. Printing Slides and Handouts
        6. Exporting to Other Formats
          1. Saving as PowerPoint
          2. Saving as Keynote '08
          3. Creating a QuickTime Movie
          4. Saving as PDF
          5. Exporting Slides as Image Files
          6. Exporting a Slideshow as a Web Page
            1. Sharing your exported web page
          7. Exporting to iPod or iPhone via iTunes
        7. Emailing Slideshows
        8. Sharing Your Slides Online
          1. Using with Keynote
          2. YouTube
          3. iWeb
        9. Shipping Your Slides to Other iApps
          1. Sharing Slides in iChat Theater
          2. iDVD
          3. iPhoto
          4. GarageBand
      6. 16. Customizing Keynote Themes
        1. Keynote Theme Basics
        2. Modifying a Theme
          1. Importing Master Slides
          2. Modifying Master Slides
            1. The Master Slide Inspector
          3. Adding New Master Slides
          4. Changing Standard Object Styles
            1. Defining standard chart styles
          5. Reverting to the Original Theme
        3. Building Themes from Scratch
          1. Create a "Master" Master Slide
          2. Adding Text and Media Placeholders
            1. Naming placeholders with tags
            2. Adding masks to media placeholders
          3. Adding Object Placeholders
          4. Defining Your Theme's Object Styles
        4. Saving Custom Themes
        5. Sharing and Buying Themes
    6. III. Numbers 09
      1. 17. Creating a Numbers Spreadsheet
        1. Picking a Numbers Template
        2. Your First Basic Spreadsheet
          1. Gimme a Grid
          2. The Toolbar and Inspectors
            1. The toolbar
            2. The Format Bar
            3. The inspectors
          3. Working with Table Rows, Columns, and Cells
            1. Labeling your data in header rows and columns
            2. Selecting and editing cells
            3. Working with Address Book
            4. Adding and removing columns and rows
            5. Sorting your spreadsheet
          4. Fast Math: Quick Formulas and Instant Calculations
          5. Changing the Table Style
        3. Fancy Formulas and Glitzy Graphics
        4. Organizing Your Data with Sheets
          1. Shuffling Sheets in the Sheets Pane
        5. Saving Your Spreadsheet
          1. Automatic Backups
          2. Password-Protecting Your Spreadsheet
          3. Adding Search Keywords
        6. Opening an Existing Spreadsheet
          1. Importing Files from Another Program
        7. Previewing Your Spreadsheet in Print View
          1. Page Setup
          2. Working in Print View
            1. Adding headers and footers to a sheet
          3. Printing Your Spreadsheet
      2. 18. Editing Tables in Numbers
        1. Working with Table Objects
          1. Adding a Table
          2. Selecting Table Elements
            1. Selecting the table object
            2. Selecting cells
            3. Selecting rows or columns
          3. Moving and Copying Tables
          4. Naming Tables
        2. Navigating Table Cells
          1. Hopping Rows with the Return Key
        3. Editing Table Cells
          1. Undoing Your Typing
          2. Handling Data That Doesn't Fit
            1. Letting text content spill into neighboring cells
            2. Sizing rows and columns to fit your values
            3. Merging table cells
          3. Paragraphs, Line Breaks, and Tabs
          4. Formatting Text
            1. The Fonts window
            2. The Text Inspector
            3. The Format menu
            4. Setting margins, indents, and tabs with the ruler
          5. Adding Comments
            1. Adding sticky notes outside of tables
            2. Printing comments
          6. Check Your Spelling
        4. Using Different Types of Data
          1. Choosing Cell Formats
            1. The number cell format
            2. The currency cell format
            3. The percentage cell format
            4. The date and time format
            5. The duration cell format
            6. The fraction cell format
            7. The numeral system cell format
            8. The scientific cell format
            9. The text cell format
          2. Creating a Custom Cell Format
            1. Building a custom number format
            2. Building a custom text format with predefined text
            3. Building a custom date and time format
          3. Managing Custom Cell Formats
            1. Editing a custom format
        5. Add It Quick: Data-Entry Shortcuts
          1. Auto-Completing Entries
          2. Auto-Correction and Smart Quotes
          3. Autofilling Cells
          4. Copying and Moving Cells
            1. Pasting table cells
          5. Adding Special Controls to Cells
            1. Using checkboxes for Boolean values
            2. Using sliders for numbers
            3. Using steppers
            4. Using pop-up menus for predefined values
          6. Using Address Book Info
            1. Creating a new table of contacts
            2. Adding contacts to an existing table
          7. Importing OFX Files for Bank Data
      3. 19. Organizing Tables in Numbers
        1. Working with Rows and Columns
          1. Adding and Deleting Rows or Columns
            1. Deleting rows or columns containing data
            2. Inserting rows or columns
          2. Working with Header Rows and Columns
            1. Freezing header rows and columns
          3. Adding Footer Rows
          4. Resizing Rows and Columns
            1. Making rows or columns the same size
            2. Tailoring row and column size to your content
          5. Moving Rows and Columns
          6. Hiding and Unhiding Rows and Columns
        2. Reorganize: Sort, Filter, Categorize
          1. Sorting Rows
          2. Filtering Rows
          3. Categorizing Rows
            1. Moving rows between categories
            2. Adding more categories
            3. Adding and managing subcategories
            4. Using dates as categories
            5. Editing the category row and adding subtotals
            6. Removing categories
        3. Find & Replace
          1. Finding Data from the Search Pane
          2. The Find & Replace Window
            1. Finding formula elements
        4. Make It Pretty: Borders and Backgrounds
          1. Styling Cell and Table Borders
            1. Selecting table borders
            2. Formatting table borders
          2. Background Colors and Images
            1. Adding images to table cells
            2. Alternating row colors
        5. Conditional Formats for "Content Alerts"
        6. Working with Table Styles
          1. Applying Predefined Table Styles
          2. Creating and Modifying Table Styles
        7. Capturing Reusable Tables
      4. 20. Using Formulas
        1. Formula Basics
        2. Instant Calculations
          1. Creating Formulas from Instant Calculations
        3. Adding Quick Formulas
          1. Using Quick Formulas with Header and Footer Cells
            1. Adding quick formulas to rows
            2. Adding quick formulas directly to footer cells
          2. Using Quick Formulas with Body Cells
            1. Adding a quick formula to a single cell body
            2. Adding a quick formula to a range of cells
        4. Editing Formulas
          1. Anatomy of a Formula
            1. Numbers' arithmetic operators
            2. Understanding the order of operations
          2. Meet the Formula Editor
          3. Using Cell References
            1. Adding cell references to formulas
            2. Viewing and editing cell references
            3. Referencing cells in other tables or sheets
        5. Copying and Moving Formulas
          1. Using Relative and Absolute Cell References
            1. Working with mixed cell references
          2. Copying the Value, Not the Formula
        6. Coping with Formula Errors
        7. Browsing and Searching Formulas
      5. 21. Advanced Data Crunching with Functions
        1. How Functions Work
        2. Adding Functions with the Function Browser
          1. Pasting Examples from the Function Browser
        3. Using Cell Ranges in Functions
          1. Adding Cell Ranges to Formulas
        4. Common Math Functions
          1. The Quick-Formula Functions and Basic Math
            1. SUM: Adding Numbers
            2. COUNT, COUNTA, and COUNTBLANK: How many?
            3. MAX and MIN: Finding the biggest and smallest
            4. LARGE, SMALL, and RANK: Ranking values
            5. AVERAGE and MEDIAN: Finding the middle value
            6. Multiplying with PRODUCT
            7. QUOTIENT and MOD: Divide and conquer
          2. Rounding Numbers
            1. Simple rounding with ROUND, ROUNDDOWN, and ROUNDUP
            2. Lopping off decimal digits with INT and TRUNC
            3. MROUND, CEILING, and FLOOR
        5. Transforming Text in Formulas
          1. Working with Portions of Strings
            1. LEFT, MID, and RIGHT: Extracting text
            2. LEN, FIND, and SEARCH: Counting characters
            3. SUBSTITUTE: Replacing text
          2. Cleaning Up Text
            1. UPPER, LOWER, and PROPER: Changing capitalization
            2. TRIM: Snipping extra white space
          3. Formatting Numbers in Text
            1. FIXED and DOLLAR: Data formats inside formulas
        6. Working with Dates and Times
          1. Doing Math with Dates and Times
            1. Adding or subtracting durations from a date value
            2. WORKDAY: Leave your weekends out of it
            3. Subtracting one date value from another
            4. Using math functions with date values
          2. Building Dates and Times in Formulas
          3. Extracting Date and Time Info
        7. What IF: Adding Logic to Formulas
          1. Setting Conditions with the IF Function
            1. Using comparison operators
            2. Testing multiple conditions with AND and OR
            3. Other condition functions
            4. Nesting IF functions to give multiple instructions
          2. COUNTIF, SUMIF, and AVERAGEIF for Smart Summaries
            1. Adding and averaging a row or column based on values of another
            2. Adding more conditions: COUNTIFS, SUMIFS, and AVERAGEIFS
            3. Pulling it all together: Using IF math to summarize data
        8. Looking Up and Fetching Cell Data
          1. Using VLOOKUP and HLOOKUP
            1. Matching text with VLOOKUP and HLOOKUP
            2. Managing "left lookups"
          2. Using LOOKUP for Easier but Inexact Matches
            1. Doing close-match lookups
          3. Using MATCH and INDEX to Fetch Any Cell
          4. Other Lookup Functions
      6. 22. Charts: Giving Shape to Numbers
        1. Adding a Chart to Your Spreadsheet
          1. Chart Parts
            1. The X-axis and Y-axis
            2. Data series and data sets
            3. The legend
          2. Choosing a Chart Type
            1. Column
            2. Stacked column
            3. Bar
            4. Line
            5. Area
            6. Stacked area
            7. Pie
            8. Scatter
            9. Mixed
            10. Two axis
          3. Switching Chart Types
        2. Working with a Chart's Table Data
          1. Choosing the Charted Cell Range
          2. Removing Data Series from a Chart
          3. Adding Data Series from Other Tables
          4. Changing the Order of Data Series
          5. Working with Scatter Charts
            1. Sharing an X value
        3. Editing Chart Text and Labels
          1. The Chart Title
          2. The Chart Legend
          3. Axis Titles and Labels
          4. Data-Point Labels
          5. Changing Text Styles
        4. Formatting Charts
          1. Adding 3D Effects
          2. Adjusting Color, Shadow, and Opacity
          3. Formatting the X- and Y-Axis
            1. Formatting the value axes for two-axis charts
          4. Working with Pie Charts
          5. Spacing Bar and Column Charts
          6. Formatting Data-Point Symbols
          7. Choosing Chart Types for Mixed and Two-Axis Charts
          8. Adding Trendlines
          9. Adding Error Bars
        5. Beware of Chartjunk
          1. The Right Chart (or Table) for Your Data
      7. 23. Designing Your Spreadsheet Report
        1. Working with Objects
        2. Identifying "Back Page" Data
          1. Hiding Charts' Source Tables
        3. Adding Text Callouts
        4. Drawing Shapes
        5. Inserting Pictures
          1. Adding Pictures to Table Cells
          2. Working with Placeholder Images
          3. Reducing File Size
        6. Adding Movies and Sound
      8. 24. Sharing Your Spreadsheets
        1. Printing Your Spreadsheet
        2. Exporting to Other Formats
          1. Saving an Excel File
          2. Exporting a PDF Document
          3. Exporting a CSV File
          4. Saving Spreadsheets for Numbers '08
        3. Sharing with Pages and Keynote
          1. Using Linked Charts
          2. Mail Merge with Pages
          3. Pasting Tables into Pages or Keynote
        4. Distributing Your Spreadsheet Online
          1. Sharing on
          2. Emailing Your Spreadsheet
          3. Adding Spreadsheets to Your iWeb Site
      9. 25. Creating Custom Numbers Templates
        1. Anatomy of a Numbers Template
        2. Building Your Own Template
          1. Adding Table Styles
          2. Changing Standard Object Styles
            1. Defining standard chart styles
          3. Adding Reusable Tables
          4. Creating the Template Content
          5. Saving and Organizing Your Templates
    7. IV. Appendix
      1. A. Installing and Upgrading iWork
        1. Installing iWork '09
          1. Running the Installer
        2. Keeping iWork Up to Date
    8. Index
    9. About the Author
    10. Colophon
    11. SPECIAL OFFER: Upgrade this ebook with O’Reilly