Using Google Spreadsheets
- Using Google Spreadsheets
- Table of Contents
- Copyright
- Introduction
- 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