| | 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 |