Home > Store > Computer Software > Business Office Software > Spreadsheet Software > Other
Google Docs 4 Everyone
- By Steven Holzner, Nancy Holzner
- Published Feb 9, 2009 by Que.
- Register your product - get bonus material or coupon.
- Book
- ISBN-10: 0-7897-3936-4
- ISBN-13: 978-0-7897-3936-0
Who needs expensive, old-fashioned office software? Now, you can do everything online, free, with Google Docs! Experts Steve and Nancy Holzner offer simple, step-by-step instructions and great insider tips for making the most of Google’s powerful online word processing, spreadsheet, and presentation tools. You’ll get started fast... learn how to create and format professional-quality documents of all kinds... collaborate with colleagues to build better proposals and presentations... use advanced tools like revision history, templates, and charts... discover Google Docs’ latest features and shortcuts... and a whole lot more! No matter what kind of documents you create, this book can help you do the job better, faster, and more efficiently... and you’ll never pay for office software again!
You’ll Learn How To
• Get your free Google account and set up iGoogle for instant access to your documents
• Upload and use the documents you’ve already created with Microsoft Office
• Use Google Spreadsheet to create charts to display spreadsheet data
• Master Google Docs’ easy, powerful document-editing and formatting tools
• Insert images into your documents and presentations
• Share documents securely with your colleagues
• Back up your documents offline and edit them when you don’t have an Internet connection
Steven Holzner, former contributing editor at PC Magazine, is author of 108 computer books
that have sold more than 2.5 million copies. His most recent Pearson book is Facebook Marketing.
Nancy Holzner writes and edits technology books from her home in central New York state.
Her recent publications include books on Intuit QuickBase and Zoho. Nancy has also worked as
a medievalist, a high school teacher, and a corporate trainer.
CATEGORY: Productivity Suites
COVERS: Google Docs
USER LEVEL: Beginning-Intermediate
|
12 of 12 people found the following review helpful
An excellent guide that is still pretty current,
Amazon Verified Purchase(What's this?)
This review is from: Google Docs 4 Everyone (Paperback)
Google Docs started in 2006. This book was written in late 2008. So, it is almost two years out of date. Given that the related programs seemed to be updated every few weeks, I thought this would be a big hurdle for this guide. But, it was not because the programs have not changed that much.This is an excellent guide that beat the Dummies series to the punch. Indeed, the Dummies series released all sorts of guides on Google, Google Apps, etc... but, none focused on Google Docs. There have been a few changes. For instance, within the doc program. The guide mentioned you could save a document as a copy (pg 35); Now, instead you make a copy. Additionally, the document styles are in a completely different area. They were under Edit (pg. 45). It is now located under Format, and it is called Document Settings. After clicking on those menu items, you finally get a Document Styles box that looks the same as in the book. Also, print settings (pg. 41) are a lot... Read more
3 of 3 people found the following review helpful
Keeping Up with Google Docs, By
Amazon Verified Purchase(What's this?)
This review is from: Google Docs 4 Everyone (Paperback)
I bought this in April or May of 2011 and it is, unfortunately, a little outdated, but it is still helpful when you are dealing with procedures Google has not already revised. And it is much better than plowing through thousands of discussions in the Google help section to find the solution to a problem you are having.
1 of 1 people found the following review helpful
Learning the google stuff,
Amazon Verified Purchase(What's this?)
This review is from: Google Docs 4 Everyone (Paperback)
This book was like going back to school again. Lots of good info put it in a manner that you could easily understand it. I'm still learning so the book is on my desk all of the time
|
Online Sample Chapter
Introducing Spreadsheets in Google Docs
Table of Contents
Introduction............................................................................................ 1
A Quick Overview of This Book................................................. 2
A Word About Security............................................................ 3
Technical Requirements for Using Google Docs......................... 4
1 Getting Started with Google Docs............................................................. 7
A Google Account: Your Passport to All Things Google.............. 8
Signing up and Signing in................................................ 8
What Can I Do with a Google Account?........................... 10
Managing Your Google Account............................................. 11
Changing Your Account Information................................ 11
Adding and Launching Google Applications..................... 12
Getting Familiar with the Google Docs Home Page.................. 12
Organizing Your Documents........................................... 13
Finding a Document...................................................... 16
iGoogle, You Google, Everybody Googles............................... 18
What’s an iGoogle Page?.............................................. 19
Setting up iGoogle......................................................... 19
Customizing Your Page................................................. 20
iGoogle and Google Docs.............................................. 24
2 Starting Word Processing...................................................................... 29
Creating Your First Document................................................ 29
Naming the Document................................................... 30
Entering Text................................................................ 31
Saving the Document..................................................... 34
Introducing Formatting........................................................... 35
Using the Formatting Toolbar.......................................... 35
Using Keyboard Shortcuts............................................. 38
Printing a Document.............................................................. 39
Inserting Headers and Footers........................................ 39
Inserting Page Breaks................................................... 40
Checking Your Spelling.................................................. 40
Choosing Your Print Settings......................................... 40
Exporting and Printing the Document.............................. 41
Deleting a Document............................................................. 44
3 Formatting Documents.......................................................................... 45
Formatting a Document......................................................... 45
Working with Templates......................................................... 47
Creating a New Document from a Template..................... 47
Saving a Document as a Template.................................. 50
Importing and Exporting Documents........................................ 50
Importing Documents..................................................... 50
Exporting a Document................................................... 54
Doing Research.................................................................... 55
Using a Dictionary, Thesaurus, or Encyclopedia............... 56
Searching the Web from Your Document......................... 57
Working Offline..................................................................... 57
Downloading and Installing Gears................................... 58
Activating Gears............................................................ 60
Using Gears to Work Offline........................................... 62
Tweaking Your Offline Settings....................................... 63
4 Taking Your Docs to the Next Level: Lists, Tables, and Insertions.............. 65
Working with Lists................................................................. 65
Creating a List.............................................................. 66
Editing a List................................................................ 67
Adding Tables to a Document................................................. 71
Creating a Table............................................................ 71
Editing a Table.............................................................. 72
Inserting and Editing Images.................................................. 78
Getting an Image into Your Document............................. 78
Editing Images.............................................................. 82
Deleting an Image......................................................... 82
Working with Hyperlinks and Bookmarks................................. 82
Inserting a Hyperlink...................................................... 83
Editing a Hyperlink........................................................ 84
Inserting a Bookmark..................................................... 85
Creating a Table of Contents.......................................... 87
Editing a Table of Contents............................................ 89
5 Sharing and Collaborating on Documents................................................ 91
Sharing a Document.............................................................. 92
Step 1: Choose Sharers and Set Permissions................. 92
Step 2: Send an Optional Email Invitation........................ 93
Receiving a Document-Sharing Notification...................... 94
Changing a Document’s Ownership................................. 95
Emailing All Viewers/Collaborators.................................. 96
Removing Sharing......................................................... 98
Other Ways to Share a Document.......................................... 99
Emailing a Document.................................................... 99
Publishing a Document on the Web.............................. 100
Collaborating on a Document................................................ 105
Collaboration and Offline Editing.................................... 106
Using Color-Coded Comments...................................... 106
Working with a Document’s Revision History.......................... 109
Viewing Revisions........................................................ 109
Comparing Versions.................................................... 110
6 Introducing Spreadsheets..................................................................... 113
Spreadsheet Basics............................................................ 113
What Is a Spreadsheet?............................................... 113
What Can a Cell Contain?............................................ 114
What Makes a Good Spreadsheet Design?.................... 114
Creating Your First Google Docs Spreadsheet....................... 117
Selecting Cells and Entering Data................................. 118
Saving a Spreadsheet.................................................. 118
Creating a New Spreadsheet from a Template........................ 119
Formatting a Spreadsheet.................................................... 120
Formatting Numbers.................................................... 121
Formatting Dates and Times......................................... 122
Formatting Appearance................................................ 122
Creating Formatting Rules............................................ 125
Working with Multiple Sheets....................................... 126
Working with Data............................................................... 127
Importing Data into Google Docs................................... 127
Exporting Data from Google Docs................................. 128
Exporting as an XLS or ODS File.................................. 129
Entering Data.............................................................. 130
Clearing Data.............................................................. 133
Working with Rows and Columns.................................. 133
Sorting Data................................................................ 136
Printing and Deleting Spreadsheets....................................... 139
Printing a Spreadsheet................................................. 139
Deleting a Spreadsheet................................................ 140
7 Spreadsheets: Formulas and Charts..................................................... 141
Working with Spreadsheet Formulas..................................... 141
What Is a Formula?..................................................... 142
Creating Formulas: The Basics..................................... 142
Supercharging Your Formulas with Functions................. 147
Getting the Big Picture with Charts, Graphics, and Gadgets.... 150
Kinds of Charts........................................................... 151
Creating a Chart.......................................................... 154
Editing a Chart............................................................ 156
Putting an Image into Your Spreadsheet........................ 159
Editing an Image......................................................... 160
Google Docs Spreadsheets and Google Gadgets........... 161
Editing a Gadget......................................................... 162
8 Sharing and Collaborating on Spreadsheets........................................... 167
Sharing Spreadsheets.......................................................... 167
Publishing a Spreadsheet on the Web........................... 168
Embedding a Spreadsheet in Your Web Site or Blog...... 170
Inviting Others to Share a Spreadsheet.......................... 170
Collaborating on Spreadsheets............................................. 176
Working Simultaneously.............................................. 176
Chatting as You Work.................................................. 177
Commenting on a Spreadsheet..................................... 178
Receiving Notifications................................................. 180
Creating a Form to Gather Data............................................ 181
Creating a New Spreadsheet by Designing a Form......... 181
Creating a Form for an Existing Spreadsheet................. 184
Emailing a Form.......................................................... 184
Embedding a Form in a Web Page or Blog.................... 185
Editing a Form............................................................ 186
Editing a Form’s Confirmation Message......................... 187
Analyzing Form Data................................................... 188
Disabling or Deleting a Form......................................... 189
Working with a Spreadsheet’s Revision History...................... 189
9 Introducing Presentations..................................................................... 191
What’s a Presentation?........................................................ 191
Why Use Google Docs for Presentations?..................... 192
Some Pointers for Designing a Presentation.................. 192
Your First Presentation........................................................ 193
Starting from Scratch................................................... 193
Naming Your Presentation............................................ 194
Getting an Existing Presentation into Google Docs......... 195
Adding a New Slide..................................................... 196
Selecting a Slide and Inserting Text.............................. 197
Saving a Presentation.................................................. 198
Giving Your Slides Pizzazz.................................................. 199
Adding Some Style with a Theme................................. 199
Giving Your Slides a Custom Background...................... 200
Formatting Text........................................................... 201
Adding Images, Shapes, and Videos............................. 204
Moving and Resizing Elements..................................... 207
Arranging Elements on a Slide...................................... 207
Revealing Elements One by One................................... 208
Deleting an Element.................................................... 209
Working with Slides............................................................. 209
Importing Slides.......................................................... 209
Copying a Slide........................................................... 210
Moving a Slide............................................................. 211
Adding Speaker Notes................................................. 211
Deleting a Slide........................................................... 211
Working with Presentations.................................................. 212
Previewing a Presentation............................................ 212
Exporting a Presentation.............................................. 213
Printing a Presentation................................................. 213
Deleting a Presentation................................................ 214
10 The Main Event: Sharing and Viewing Presentations............................... 217
Sharing a Presentation......................................................... 217
Collaborating on a Presentation............................................ 218
Giving a Live Presentation.................................................... 219
Starting the Show........................................................ 220
During the Presentation................................................ 220
Ending a Presentation.................................................. 226
Publishing a Presentation on the Web................................... 226
Making a Presentation Public....................................... 226
Embedding a Presentation in Your Web Page or Blog..... 228
Working with Revisions........................................................ 230
TOC, 1/16/09, 9780789739360
Sample Pages
Download the sample pages (includes Chapter 6 and Index)
This book includes free shipping!
This book includes free shipping!
eBook (Adobe DRM)
$15.99
$12.79
This eBook requires the free Adobe® Digital Editions software.
Before downloading this DRM-encrypted PDF, be sure to:
- Install the free Adobe Digital Editions software on your machine. Adobe Digital Editions only works on Macintosh and Windows, and requires the Adobe Flash Player. Please see the official system requirements.
- Authorize your copy of Adobe Digital Editions using your Adobe ID. If you don't already have an Adobe ID, you can create one here.
- Request an Instructor or Media review copy
- Corporate, Academic, and Employee Purchases
- International Buying Options
Get access to thousands of books and training videos about technology, professional development and digital media from more than 40 leading publishers, including Addison-Wesley, Prentice Hall, Cisco Press, IBM Press, O'Reilly Media, Wrox, Apress, and many more. If you continue your subscription after your 30-day trial, you can receive 30% off a monthly subscription to the Safari Library for up to 12 months. That's a total savings of $199.
