Using Google Spreadsheets

book cover
Using Google™ Spreadsheets
By Michael Miller
Publisher: Que
Pub Date: July 26, 2006
Print ISBN-10: 0-7686-6833-6
Print ISBN-13: 978-0-7686-6833-9
Pages: 50

Table of Contents

Google Spreadsheets is the new web-based spreadsheet application that's giving Microsoft Excel a run for its money. With Google Spreadsheets, you can create complex spreadsheets online, using any web browser, complete with sophisticated formulas and functions. You can even share spreadsheets online and perform collaborative editing on those spreadsheets with other users anywhere in the world. And the best thing is, Google Spreadsheets is completely free!

Using Google Spreadsheets is the first e-book to cover Google's innovative online spreadsheet program. You learn how to create new web-based spreadsheets, upload and work with existing Excel spreadsheets, create complex formulas, apply a variety of formatting effects, and let other users share and edit their spreadsheets. Delivered in Adobe PDF format for quick and easy access, Using Google Spreadsheets includes everything you need to create your own sophisticated online spreadsheets. It also includes a detailed reference to the more than 200 functions included in the program, and a great cheatsheet you can print off and refer to for quick reference.

book cover
Using Google™ Spreadsheets
By Michael Miller
Publisher: Que
Pub Date: July 26, 2006
Print ISBN-10: 0-7686-6833-6
Print ISBN-13: 978-0-7686-6833-9
Pages: 50

Table of Contents

   We Want to Hear from You!
      Section 1.  Introducing Google Spreadsheets
      What's Unique About Google Spreadsheets?
      Comparing Google Spreadsheets to Excel
      Other Web-Based Spreadsheets
      Privacy and Security Concerns
      Should You Use Google Spreadsheets?
      Section 2.  Migrating from Excel to Google Spreadsheets
      Section 3.  Navigating the Google Spreadsheets Workspace
      Understanding Elements of the Workspace
      Navigating with the Keyboard
      Freezing Rows While You Scroll
      Section 4.  Creating, Opening, and Saving Google Spreadsheets
      Creating a New Spreadsheet
      Opening an Existing Spreadsheet
      Importing a Spreadsheet from Excel
      Saving a Spreadsheet
      Saving a Copy of a Spreadsheet
      Renaming a Spreadsheet
      Exporting a Google Spreadsheet to Excel Format
      Deleting a Spreadsheet
      Section 5.  Entering and Editing Data
      Entering New Data
      Editing Previously Entered Data
      Section 6.  Working with Ranges
      Understanding Ranges
      Selecting a Range
      Section 7.  Sorting Data
      Executing a Sort
      Sorting a Range
      Performing Multiple-Column Sorts
      Section 8.  Inserting, Deleting, Moving, and Copying Data
      Inserting Rows and Columns
      Deleting Data
      Moving Data with the Cut and Paste Commands
      Copying Data
      Section 9.  Changing Column Width and Row Height
      Changing Column Width
      Changing Row Height
      Section 10.  Formatting Google Spreadsheets
      Enhancing Text with Bold, Italic, and Other Attributes
      Changing Fonts and Type Sizes
      Aligning Information in a Cell
      Changing Number Formats
      Changing the Background Color of Cells and Ranges
      Section 11.  Entering and Editing Formulas
      Understanding Formulas
      Entering Formulas
      Creating Formulas with Your Mouse
      Editing Formulas
      Section 12.  Using Functions
      Understanding Functions
      Entering Functions
      Using the SUM Function
      Using the COUNT Function
      Using the AVERAGE Function
      Using the MIN Function
      Using the MAX Function
      Using the PRODUCT Function
      Other Google Spreadsheets Functions
      Section 13.  Working with Multiple Sheets
      Adding New Sheets
      Renaming Sheets
      Deleting Sheets
      Section 14.  Printing Google Spreadsheets
      Section 15.  Sharing and Collaborating with Google Spreadsheets
      Sharing a Spreadsheet for Viewing
      Sharing a Spreadsheet for Collaboration
      Chatting with Spreadsheet Viewers
      Rescinding Access
      Versioning Your Work in Progress
      Section 16.  A Final Word
      Command Reference