Using Google Spreadsheets

2017-07-07 02:10:07

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

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

Категории