Using Google Apps

298 Pages·2011·12.95 MB·English

by  Michael Miller

About Your Using Book
USING is more than just a book: it’s the fastest, easiest way to
gain the technology skills you’re looking for!
Don’t just read about it: see it, hear it, with step-by-step video tutorials and
valuable audio sidebars delivered through the Free Web Edition that comes
with every USING book. For the price of the book you get online access
anywhere with a web connection—no books to carry, updated content,
and the benefit of video and audio learning.
About the USING Web Edition
The Web Edition of every USING book is powered by safari
allowing you to access the video tutorials and valuable audio
sidebars. Plus, you can search the contents of the book,
highlight text and attach a note to that text, print your notes
and highlights in a custom summary, and cut and paste
directly from Safari Books Online.
How Do You get Access to the Free Web Edition?
Simply visit quepublishing.com/using for information about how to
register your USING book or eBook.
quepublishing.com
Michael Miller

800 East 96th Street, Indianapolis, Indiana 46240 USA
Using Google® Apps Associate Publisher
Greg Wiegand
Copyright © 2011 by Pearson Education, Inc.
Acquisitions Editor
All rights reserved. No part of this book shall be reproduced, stored in a retrieval
Rick Kughen
system, or transmitted by any means, electronic, mechanical, photocopying,
recording, or otherwise, without written permission from the publisher. No patent Managing Editor
liability is assumed with respect to the use of the information contained herein. Kristy Hart
Although every precaution has been taken in the preparation of this book, the
Project Editor
publisher and author assume no responsibility for errors or omissions. Nor is
any liability assumed for damages resulting from the use of the information Lori Lyons
contained herein. Proofreader

Sheri Cain
ISBN-13: 0-7897-4397-3
Technical Editor
ISBN-10: 978-0-7897-4397-8
Mark Reddin
Trademarks
Publishing Coordinator
All terms mentioned in this book that are known to be trademarks or service marks
have been appropriately capitalized. Que Publishing cannot attest to the accuracy of Cindy Teeters
this information. Use of a term in this book should not be regarded as affecting the Cover Designer
validity of any trademark or service mark.
Anna Stingley
Warning and Disclaimer Interior Designer
Every effort has been made to make this book as complete and as accurate as pos- Ann Jones
sible, but no warranty or fitness is implied. The information provided is on an "as is"
basis. The author and the publisher shall have neither liability nor responsibility to
any person or entity with respect to any loss or damages arising from the information
contained in this book.
Bulk Sales
Pearson offers excellent discounts on this book when ordered in quantity for bulk purchases or special sales.
For more information, please contact
U.S. Corporate and Government Sales
1-800-382-3419
[email protected]
For sales outside of the U.S., please contact
International Sales
[email protected]
Contents at a Glance

Introduction
Chapter 1 Understanding Google Apps and Web-Based Applications
Chapter 2 Using the Google Docs Dashboard
Chapter 3 Using Google Docs
Chapter 4 Using Google Spreadsheets
Chapter 5 Using Google Presentations
Chapter 6 Collaborating with Google Docs
Chapter 7 Using Google Calendar
Chapter 8 Using Gmail
Chapter 9 Using Google Talk
Chapter 10 Using the Google Chrome Web Browser
Chapter 11 Using Google Apps Offline with Google Gears
Chapter 12 Managing Google Apps in the Enterprise
Media Table of Contents
To register this product and gain access to the Free Web Edition and the
audio and video files, go to quepublishing.com/using.
Chapter 1: Understanding Google Apps and Web-Based Applications
Show Me Media 1.1—A Quick Tour of Google Apps
Tell Me More Media 1.2—Web-Based Applications vs. Traditional
Software
Chapter 2: Using the Google Docs Dashboard
Show Me Media 2.1—A Quick Tour of the Google Docs Dashboard
Show Me Media 2.2—Filtering Files
Tell Me More Media 2.3—How Well Does Google Docs Work with
Microsoft Office Files?
Show Me Media 2.4—Importing Files
Chapter 3: Using Google Docs
Tell Me More Media 3.1—Google Docs vs. Microsoft Office
Show Me Media 3.2—Writing and Editing a Document
Show Me Media 3.3—Formatting Text
Show Me Media 3.4—Inserting Images
Chapter 4: Using Google Spreadsheets
Show Me Media 4.1—Navigating Google Spreadsheets
Show Me Media 4.2—Entering Data
Show Me Media 4.3—Entering Formulas and Functions
Show Me Media 4.4—Creating a Chart
Tell Me More Media 4.5—Understanding Gadgets
Chapter 5: Using Google Presentations
Tell Me More Media 5.1—Pros and Cons of Google Presentations
Show Me Media 5.2—Working with Slides
Show Me Media 5.3—Formatting a Presentation
Show Me Media 5.4—Giving a Presentation
Chapter 6: Collaborating with Google Docs
Tell Me More Media 6.1—The Benefits of Web-Based Collaboration
Show Me Media 6.2—Preparing a Document for Group Editing
Show Me Media 6.3—Making a Document Public
Chapter 7: Using Google Calendar
Tell Me More Media 7.1—The Benefits of Web-Based Calendars
Show Me Media 7.2—Displaying Calendar Views
Show Me Media 7.3—Entering Calendar Events
Show Me Media 7.4—Entering Tasks
Chapter 8: Using Gmail
Tell Me More Media 8.1—Web-Based Email vs. Traditional POP Email
Show Me Media 8.2—A Quick Tour of Gmail
Show Me Media 8.3—Reading and Replying to Messages
Show Me Media 8.4—Organizing Email Messages
Chapter 9: Using Google Talk
Tell Me More Media 9.1—The Pros and Cons of Google Talk
Show Me Media 9.2—Conducting a Google Talk Session
Show Me Media 9.3—Managing Your Google Talk Contacts
Show Me Media 9.4—Using Google Talk in Gmail
Chapter 10: Using the Google Chrome Web Browser
Tell Me More Media 10.1—Google Chrome vs. Internet Explorer
Show Me Media 10.2—A Quick Tour of Google Chrome
Show Me Media 10.3—Working with Tabs
Show Me Media 10.4—Managing Bookmarks
Show Me Media 10.5—Using Chrome with Google Apps
Chapter 11: Using Google Apps Offline with Google Gears
Tell Me More Media 11.1—The Downside of Working in the Cloud
Chapter 12: Managing Google Apps in the Enterprise
Tell Me More Media 12.1—Examining Google Apps Premier Edition
Tell Me More Media 12.2—Does Google Apps Make Sense for
Your Organization?
Table of Contents

Introduction
1 Understanding Google Apps and Web-Based Applications
Introducing Google Apps
Computing in the Cloud
Google’s Cloud
Benefits of Web-Based Applications
Privacy and Security Concerns
Understanding Different Versions of Google Apps
Generic Google Apps
Google Apps for Education
Google Apps for Business
Should You Use Google Apps?
Pros
Cons
2 Using the Google Docs Dashboard
Navigating the Google Docs Dashboard
Filtering the Display
Filtering by Type
Sorting Files
Searching for Files
Managing Files
Opening a File
Working with Folders
Using Starred Items
Hiding Files
Viewing File Details
Viewing Revisions
Importing Other Types of Files
Configuring Google Docs Settings
3 Using Google Docs
Getting to Know Google Docs
Creating and Saving New Documents
Creating a New Blank Document
Creating a New Document from a Template
Saving a Document
Importing and Exporting Documents in Other Formats
Importing Documents
Exporting Documents
Changing Page Layout
Entering and Editing Text
Entering Text
Editing Text
Formatting Text
Boldfacing and Italicizing Text
Formatting Paragraphs
Indenting a Paragraph
Changing Paragraph Alignment
Changing Line Spacing
Creating Bulleted and Numbered Lists
Working with Images
Inserting an Image
Positioning an Image
Inserting a Drawing
Inserting Web Links and Bookmarks
Inserting Web links
Inserting Bookmarks
Inserting Comments and Footnotes
Inserting Comments
Inserting Footnotes
Inserting Equations and Special Characters
Creating a Table
Using Tabs
Adding Headers and Footers
Working with Tables of Contents
Preparing for the Table of Contents
Inserting the Table of Contents
Proofing Your Document
Checking Spelling
Using the Dictionary
Calculating Word Count
Printing Your Document
4 Using Google Spreadsheets
Understanding Google Spreadsheets
Navigating the Google Spreadsheets Workspace
Working with Multiple Sheets
Creating and Saving a New Spreadsheet
Creating a New Blank Spreadsheet
Creating a New Spreadsheet from a Template
Saving a Spreadsheet
Importing and Exporting Documents in Other Formats
Importing Documents
Exporting Spreadsheets
Entering and Editing Data
Working with Rows and Columns
Formatting Text and Numbers
Formatting Font, Size, and Color
Aligning Text in a Cell
Formatting Cells
Changing Number Formats
Sorting Data
Working with Ranges
Working with Formulas and Functions
Using Formulas
Using Functions
Charting Your Data
Working with Forms
Creating a Form
Collecting Responses
Completing a Form
Analyzing Responses
Working with Gadgets
Working with Scripts
Printing Your Spreadsheet
5 Using Google Presentations
Getting to Know Google Presentations
Creating and Saving New Presentations
Creating a New Presentation
Creating a New Presentation from a Template
Saving a Presentation