Google Docs 4 Everyone

Steven Holzner is the award-winning author of many books. His books have sold more than two million copies and have been translated into 18 languages around the world. He’s been a contributing editor at PC Magazine and has been on the faculty of MIT and Cornell University, where he got his PhD.  Nancy Holzner writes and edits tech books from her home in central New York state on topics ranging from Google Apps to WAN optimization to Zoho. She is also a novelist (mystery and urban fantasy) and has worked as a medievalist, an English teacher, and a corporate trainer. Nancy holds a PhD from Brown University.

• Introduction............................................................................................ 1A Quick Overview of This Book................................................. 2A Word About Security............................................................ 3Technical Requirements for Using Google Docs......................... 41    Getting Started with Google Docs............................................................. 7A Google Account: Your Passport to All Things Google.............. 8Signing up and Signing in................................................ 8What Can I Do with a Google Account?........................... 10Managing Your Google Account............................................. 11Changing Your Account Information................................ 11Adding and Launching Google Applications..................... 12Getting Familiar with the Google Docs Home Page.................. 12Organizing Your Documents........................................... 13Finding a Document...................................................... 16iGoogle, You Google, Everybody Googles............................... 18What’s an iGoogle Page?.............................................. 19Setting up iGoogle......................................................... 19Customizing Your Page................................................. 20iGoogle and Google Docs.............................................. 242    Starting Word Processing...................................................................... 29Creating Your First Document................................................ 29Naming the Document................................................... 30Entering Text................................................................ 31Saving the Document..................................................... 34Introducing Formatting........................................................... 35Using the Formatting Toolbar.......................................... 35Using Keyboard Shortcuts............................................. 38Printing a Document.............................................................. 39Inserting Headers and Footers........................................ 39Inserting Page Breaks................................................... 40Checking Your Spelling.................................................. 40Choosing Your Print Settings......................................... 40Exporting and Printing the Document.............................. 41Deleting a Document............................................................. 443    Formatting Documents.......................................................................... 45Formatting a Document......................................................... 45Working with Templates......................................................... 47Creating a New Document from a Template..................... 47Saving a Document as a Template.................................. 50Importing and Exporting Documents........................................ 50Importing Documents..................................................... 50Exporting a Document................................................... 54Doing Research.................................................................... 55Using a Dictionary, Thesaurus, or Encyclopedia............... 56Searching the Web from Your Document......................... 57Working Offline..................................................................... 57Downloading and Installing Gears................................... 58Activating Gears............................................................ 60Using Gears to Work Offline........................................... 62Tweaking Your Offline Settings....................................... 634    Taking Your Docs to the Next Level: Lists, Tables, and Insertions.............. 65Working with Lists................................................................. 65Creating a List.............................................................. 66Editing a List................................................................ 67Adding Tables to a Document................................................. 71Creating a Table............................................................ 71Editing a Table.............................................................. 72Inserting and Editing Images.................................................. 78Getting an Image into Your Document............................. 78Editing Images.............................................................. 82Deleting an Image......................................................... 82Working with Hyperlinks and Bookmarks................................. 82Inserting a Hyperlink...................................................... 83Editing a Hyperlink........................................................ 84Inserting a Bookmark..................................................... 85Creating a Table of Contents.......................................... 87Editing a Table of Contents............................................ 895    Sharing and Collaborating on Documents................................................ 91Sharing a Document.............................................................. 92Step 1: Choose Sharers and Set Permissions................. 92Step 2: Send an Optional Email Invitation........................ 93Receiving a Document-Sharing Notification...................... 94Changing a Document’s Ownership................................. 95Emailing All Viewers/Collaborators.................................. 96Removing Sharing......................................................... 98Other Ways to Share a Document.......................................... 99Emailing a Document.................................................... 99Publishing a Document on the Web.............................. 100Collaborating on a Document................................................ 105Collaboration and Offline Editing.................................... 106Using Color-Coded Comments...................................... 106Working with a Document’s Revision History.......................... 109Viewing Revisions........................................................ 109Comparing Versions.................................................... 1106    Introducing Spreadsheets..................................................................... 113Spreadsheet Basics............................................................ 113What Is a Spreadsheet?............................................... 113What Can a Cell Contain?............................................ 114What Makes a Good Spreadsheet Design?.................... 114Creating Your First Google Docs Spreadsheet....................... 117Selecting Cells and Entering Data................................. 118Saving a Spreadsheet.................................................. 118Creating a New Spreadsheet from a Template........................ 119Formatting a Spreadsheet.................................................... 120Formatting Numbers.................................................... 121Formatting Dates and Times......................................... 122Formatting Appearance................................................ 122Creating Formatting Rules............................................ 125Working with Multiple Sheets....................................... 126Working with Data............................................................... 127Importing Data into Google Docs................................... 127Exporting Data from Google Docs................................. 128Exporting as an XLS or ODS File.................................. 129Entering Data.............................................................. 130Clearing Data.............................................................. 133Working with Rows and Columns.................................. 133Sorting Data................................................................ 136Printing and Deleting Spreadsheets....................................... 139Printing a Spreadsheet................................................. 139Deleting a Spreadsheet................................................ 1407    Spreadsheets: Formulas and Charts..................................................... 141Working with Spreadsheet Formulas..................................... 141What Is a Formula?..................................................... 142Creating Formulas: The Basics..................................... 142Supercharging Your Formulas with Functions................. 147Getting the Big Picture with Charts, Graphics, and Gadgets.... 150Kinds of Charts........................................................... 151Creating a Chart.......................................................... 154Editing a Chart............................................................ 156Putting an Image into Your Spreadsheet........................ 159Editing an Image......................................................... 160Google Docs Spreadsheets and Google Gadgets........... 161Editing a Gadget......................................................... 1628    Sharing and Collaborating on Spreadsheets........................................... 167Sharing Spreadsheets.......................................................... 167Publishing a Spreadsheet on the Web........................... 168Embedding a Spreadsheet in Your Web Site or Blog...... 170Inviting Others to Share a Spreadsheet.......................... 170Collaborating on Spreadsheets............................................. 176Working Simultaneously.............................................. 176Chatting as You Work.................................................. 177Commenting on a Spreadsheet..................................... 178Receiving Notifications................................................. 180Creating a Form to Gather Data............................................ 181Creating a New Spreadsheet by Designing a Form......... 181Creating a Form for an Existing Spreadsheet................. 184Emailing a Form.......................................................... 184Embedding a Form in a Web Page or Blog.................... 185Editing a Form............................................................ 186Editing a Form’s Confirmation Message......................... 187Analyzing Form Data................................................... 188Disabling or Deleting a Form......................................... 189Working with a Spreadsheet’s Revision History...................... 1899    Introducing Presentations..................................................................... 191What’s a Presentation?........................................................ 191Why Use Google Docs for Presentations?..................... 192Some Pointers for Designing a Presentation.................. 192Your First Presentation........................................................ 193Starting from Scratch................................................... 193Naming Your Presentation............................................ 194Getting an Existing Presentation into Google Docs......... 195Adding a New Slide..................................................... 196Selecting a Slide and Inserting Text.............................. 197Saving a Presentation.................................................. 198Giving Your Slides Pizzazz.................................................. 199Adding Some Style with a Theme................................. 199Giving Your Slides a Custom Background...................... 200Formatting Text........................................................... 201Adding Images, Shapes, and Videos............................. 204Moving and Resizing Elements..................................... 207Arranging Elements on a Slide...................................... 207Revealing Elements One by One................................... 208Deleting an Element.................................................... 209Working with Slides............................................................. 209Importing Slides.......................................................... 209Copying a Slide........................................................... 210Moving a Slide............................................................. 211Adding Speaker Notes................................................. 211Deleting a Slide........................................................... 211Working with Presentations.................................................. 212Previewing a Presentation............................................ 212Exporting a Presentation.............................................. 213Printing a Presentation................................................. 213Deleting a Presentation................................................ 21410    The Main Event: Sharing and Viewing Presentations............................... 217Sharing a Presentation......................................................... 217Collaborating on a Presentation............................................ 218Giving a Live Presentation.................................................... 219Starting the Show........................................................ 220During the Presentation................................................ 220Ending a Presentation.................................................. 226Publishing a Presentation on the Web................................... 226Making a Presentation Public....................................... 226Embedding a Presentation in Your Web Page or Blog..... 228Working with Revisions........................................................ 230TOC, 1/16/09, 9780789739360