iWork The book that should have been in the box® Jessica Thornsby & Josh Clark Beijing | Cambridge | Farnham | Köln | Sebastopol | Tokyo iWork: The Missing Manual by Jessica Thornsby and Josh Clark Copyright © 2014 Jessica Thornsby. All rights reserved. Printed in the United States of America. Published by O’Reilly Media, Inc., 1005 Gravenstein Highway North, Sebastopol, CA 95472. O’Reilly books may be purchased for educational, business, or sales promotional use. Online editions are also available for most titles (http://my.safaribooksonline.com). For more information, contact our corporate/institutional sales department: (800) 998-9938 or [email protected]. March 2014: First Edition. Revision History for the First Edition: 2014-03-11 First release See http://www.oreilly.com/catalog/errata.csp?isbn=0636920012832 for release details. The Missing Manual is a registered trademark of O’Reilly Media, Inc. The Missing Manual logo, and “The book that should have been in the box” are trademarks of O’Reilly Media, Inc. Many of the designations used by manufacturers and sellers to distinguish their products are claimed as trademarks. Where those designations appear in this book, and O’Reilly Media is aware of a trademark claim, the designations are capitalized. While every precaution has been taken in the preparation of this book, the publisher assumes no responsibility for errors or omissions, or for damages resulting from the use of the information contained in it. ISBN-13: 978-1-4493-9331-1 [M] Contents The Missing Credits ........................................ xi Introduction .............................................. xiii The Three Parts of iWork .......................................... xiv The Three Flavors of iWork ..........................................xv What’s New in iWork ..............................................xvii The Very Basics .................................................. xviii About This Book .................................................. xix About the Outline ..................................................xx About the Online Resources ........................................ xxi Safari® Books Online ..............................................xxii Part One: Pages for Mac CHAPTER 1: Creating a Pages Document................................ 3 Getting Started with Pages ..........................................3 Creating Pages Documents ..........................................5 Opening an Existing Document ...................................... 17 Controlling the Document Window ..................................19 CHAPTER 2: Editing Text in Pages. ...................................... 31 Word-Processor Text vs. Text Boxes .................................31 Basic Text Editing in iWork ..........................................32 Undoing and Backing Up ...........................................37 Changing Font Styles and Appearance ...............................39 Formatting Paragraphs .............................................47 Spaces, Invisibles, and Special Characters ............................62 Working with Lists .................................................66 CHAPTER 3: Creating and Using Styles. ................................ 75 When You Need Styles .............................................76 Style Central: The Text Tab ..........................................77 Creating Styles ....................................................80 Changing the Default Font ..........................................82 iii CHAPTER 4: Typo-Busting Power Tools. ............................... 85 Changing Your Mind: Find & Replace .................................85 Spell Checking .....................................................89 Reference Tools ....................................................94 Auto-Correction and Text Substitution ...............................97 Tracking Changes ..................................................98 CHAPTER 5: Formatting and Organizing Documents. ................. 105 Document Formatting .............................................105 Organizing Your Document with Sections .............................113 Auto-Entry: Formatted Text Fields .................................. 119 Adding a Table of Contents ........................................122 Hyperlinks .......................................................126 CHAPTER 6: Beyond Text: Laying Out Documents .................... 129 Templates: The Key to Prefab Page Designs ..........................130 Planning a Layout from Scratch .....................................133 Creating a Page-Layout Document ..................................139 CHAPTER 7: Objects Up Close: Adding, Modifying, and More ......... 143 Floating vs. Inline Objects ..........................................143 Adding Objects ...................................................148 Working with Objects .............................................178 Modifying Object Styles ........................................... 191 Copying Objects and Graphic Styles ................................203 CHAPTER 8: Building Tables and Charts. .............................. 205 Creating Tables ...................................................205 Making Mini-Spreadsheets with Formulas ............................228 Creating Charts ...................................................233 CHAPTER 9: Sharing Pages Documents ............................... 243 Password-Protecting Documents ...................................243 Printing Your Documents ..........................................245 Exporting Documents ............................................ 250 Emailing Your Document ..........................................256 Sharing via iCloud .................................................256 CHAPTER 10: Creating Templates to Streamline Projects .............. 263 Template-Building Basics ..........................................263 Modifying an Existing Template ....................................265 Creating Templates from Scratch ...................................267 Deleting Templates ................................................275 Sharing, Exchanging, and Buying Templates .........................276 iv COntents Part two: Keynote for Mac CHAPTER 11: Creating a Keynote Slideshow ........................... 279 Themes = Templates ............................................. 280 Your First Keynote Slideshow ......................................282 Browsing and Organizing Your Slides .............................. 296 Saving Your Slideshow ........................................... 306 Opening an Existing Slideshow .....................................307 CHAPTER 12: Laying Out Slides ........................................ 309 Setting Up the Keynote Document ..................................310 Working with Objects .............................................312 Adding and Formatting Text Boxes .................................321 Inserting Photos and Other Graphics ................................327 Adding Shapes ...................................................335 Building Tables and Charts .........................................335 Adding Movies. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .336 Making Noise: Sounds and Soundtracks .............................339 Working with Hyperlinks ...........................................343 Note to Self: Adding Comments ....................................345 Changing Slide Backgrounds .......................................347 Adding Slide Numbers ............................................ 349 CHAPTER 13: Animating Slides. ........................................ 351 Adding Transitions ................................................351 Adding Object Builds ..............................................358 Ordering and Automating Builds ....................................367 Adding Animations with Action Builds ...............................371 Copying Builds to Other Objects ....................................376 CHAPTER 14: Sharing Your Slideshows. ................................ 377 Setting Up the Presentation ........................................377 Playing Keynote Slideshows ....................................... 390 Creating Self-Playing Slideshows ...................................393 Setting Up Hyperlinks-Only Slideshows. . . . . . . . . . . . . . . . . . . . . . . . . . . . . .398 Printing Slides and Handouts .......................................399 Exporting to Other Formats ........................................401 Emailing Slideshows .............................................. 408 Sharing Your Slides Online ........................................ 408 Send a Copy ......................................................410 COntents v CHAPTER 15: Customizing Keynote Themes ........................... 415 Keynote Theme Basics ............................................416 Modifying a Theme ................................................416 Building Themes from Scratch ......................................421 Saving Custom Themes ............................................425 Sharing and Buying Themes ........................................426 Part three: Numbers for Mac CHAPTER 16: Creating a Numbers Spreadsheet. ....................... 431 Picking a Numbers Template .......................................433 Your First Spreadsheet ........................................... 434 Fancy Formulas and Glitzy Graphics ............................... 444 Organizing Data with Sheets ...................................... 446 Saving Your Spreadsheet ......................................... 448 Opening an Existing Spreadsheet .................................. 448 Previewing Your Printed Spreadsheet .............................. 450 CHAPTER 17: Editing Tables in Numbers ............................... 453 Working with Table Objects ........................................453 Navigating Table Cells .............................................461 Editing Table Cells ................................................462 Using Different Types of Data ......................................470 Add It Quick: Data-Entry Shortcuts ................................ 483 CHAPTER 18: Organizing Tables in Numbers. .......................... 489 Working with Rows and Columns .................................. 489 Sorting and Filtering Data ......................................... 500 Find & Replace .................................................. 505 Make It Pretty: Borders and Backgrounds ........................... 506 Conditional Formatting ............................................510 Working with Table Styles .........................................512 CHAPTER 19: Using Formulas .......................................... 515 Formula Basics ...................................................516 Instant Calculations ...............................................517 Adding Quick Formulas ............................................521 Editing Formulas ..................................................522 Copying and Moving Formulas .....................................534 Coping with Formula Errors ........................................537 vi COntents CHAPTER 20: Advanced Data Crunching with Functions ............... 539 How Functions Work ..............................................539 Adding Functions with the Functions Tab ............................542 Using Cell Ranges in Functions .....................................545 Common Math Functions ......................................... 548 Transforming Text in Formulas .....................................556 Working with Dates and Times .....................................563 What IF: Adding Logic to Formulas .................................569 Looking Up and Fetching Cell Data ..................................582 CHAPTER 21: Charts: Giving Shape to Data ............................ 595 Adding a Chart to Your Spreadsheet ................................596 Working with a Chart’s Table Data ..................................610 Editing Chart Text and Labels ......................................618 Formatting Charts ................................................626 Avoiding Chartjunk ............................................... 640 CHAPTER 22: Designing Your Spreadsheet Report. .................... 645 Working with Objects ............................................ 646 Identifying “Back Page” Data .......................................647 Adding Text ..................................................... 650 Drawing Shapes ..................................................651 Inserting Pictures ................................................ 654 Adding Movies and Sound .........................................656 Creating Custom Numbers Templates ...............................657 CHAPTER 23: Sharing Your Spreadsheets .............................. 661 Printing Your Spreadsheet .........................................661 Exporting to Other Formats ........................................663 Sharing with Pages and Keynote ................................... 669 Distributing Spreadsheets Online .................................. 669 Sending a Copy of Your Document ..................................673 Part Four: iWork for iOS CHAPTER 24: Pages for iOS ............................................ 677 Creating Your First Document ......................................678 Adding Objects ...................................................681 General Object Edits ..............................................683 Working with Text ............................................... 688 Working with Shapes ............................................. 694 Working with Images ............................................. 694 Working with Tables ..............................................695 Working with Charts ............................................. 699 COntents vii Working with Audio and Video .................................... 704 Sharing Your Documents ..........................................705 CHAPTER 25: Keynote for iOS. ......................................... 709 Creating Presentations ........................................... 709 Animating Slides ..................................................715 Creating Hyperlinks ...............................................722 Using Presenter Display ...........................................725 CHAPTER 26: Numbers for iOS ......................................... 727 Creating a Spreadsheet ...........................................727 Working with Objects .............................................729 Working with Sheets ..............................................730 Adding Data to a Table ............................................730 Working with Data ................................................735 Using Forms to Supercharge Data Entry ............................742 Converting Tables into Charts ......................................745 Part Five: iWork for iCloud CHAPTER 27: An Intro to iCloud. ....................................... 749 Getting Started with iWork for iCloud ...............................750 Connecting iWork for Mac to iCloud .................................752 CHAPTER 28: Pages for iCloud ......................................... 755 Accessing Pages for iCloud ........................................756 Documents View ..................................................756 Creating a Pages Document ....................................... 760 Working with Text ................................................761 Working with Objects .............................................765 Printing Your Document ...........................................770 Password-Protecting Your Document ...............................770 CHAPTER 29: Keynote for iCloud. ...................................... 771 Creating a Presentation ............................................772 Working with Objects 101 ..........................................774 Transitioning Between Slides .......................................777 Sharing, Protecting, and Printing Your Presentations ..................779 viii COntents