×

Contact Us

Corporate Headquarters

TeachUcomp, Inc.
1140 Abbot Road
#64
East Lansing MI 48823
USA

Phone

Toll Free (U.S. and Canada): 877-925-8080
International:  +1-517-333-2560

Email

sales@teachucomp.com

Hours of Operation

Monday-Friday 9:00-5:00 Eastern.

Policies

Privacy Policy

Terms and Conditions

Google Sheets Quick Reference Guide

$5.95

Available via Printed/Laminated (Shipped/Physical) or PDF (Download Only):

Quantity: Price:
1-49 $5.95
50-99 $4.85
100-499 $4.05
500-999 $3.50
1000+ $3.35

Clear

Description

Subject: Google Sheets
Level: Introductory
Topics Covered: 59
Pages: 4
Dimensions: 11 x 17″ – Folded
Availability: Printed & Laminated or PDF Download
ISBN: 978-1-941854-74-7

Product Description

Designed with the busy professional in mind, this 4-page quick reference guide provides step-by-step instructions in Google Sheets. When you need an answer fast, you will find it right at your fingertips with this Google Sheets Quick Reference Guide. Clear and easy-to-use, quick reference guides are perfect for individuals, schools, businesses, and as supplemental training materials.

Topics Covered:

The Worksheet Environment
The Worksheet Environment

The Google Sheets Home Screen
Accessing Settings and Other Apps
Viewing and Hiding Templates
Using Search
Viewing, Filtering, and Sorting

File Management Basics
Creating New Spreadsheets
Naming Spreadsheets
Opening Spreadsheets
Importing Files Into Google Sheets
Saving, Copying, Exporting, Closing
Deleting Spreadsheets

Data Entry
Selecting Cells
Entering New Data
Using Auto Fill for Data Entry
Using Smart Fill

Formulas
Understanding Formulas
Ranged Formula Syntax
Simple Formula Syntax
Entering a Formula
Understanding 3D Formulas
Ranged 3D Formula Syntax
Simple 3D Formula Syntax
Entering a 3D Formula
Inserting Functions
Editing a Range in a Formula
Viewing and Hiding Formulas
Using Auto Calculate

Copying and Pasting Formulas
Relative vs. Absolute Cell References
Cutting, Copying, and Pasting
Using “Drag and Drop” to Cut and Paste
Auto Filling Formula Cells
Using Undo and Redo

Adjusting Columns and Rows
Selecting Columns, Rows, and Worksheets
Resizing Column Width/Row Height
Inserting and Deleting Columns and Rows
Hiding Columns and Rows
Freezing Columns and Rows

Formatting Worksheets
Formatting Text, Shading, and Borders
Formatting Number Cells
Aligning and Merging Cells
Rotating Text
Copying Cell Formatting
Clearing Cells and Cell Formatting

Inserting Worksheets Objects
Inserting a Link
Inserting Comments
Inserting a Chart

Worksheet Tools
Inserting and Deleting Worksheets
Navigating Worksheets
Renaming Worksheets
Coloring Worksheet Tabs
Moving and Copying Worksheets
Protecting Worksheets and Ranges
Hiding Worksheets

Sorting and Filtering Data
Sorting Data
Filtering Data
Creating Filter Views

Printing
Printing Worksheets
Adjusting Page Breaks

Keyboard Shortcuts
Navigating Worksheets
Selecting Cells, Columns, and Rows
Entering Data
Other Common Functions

You may also like…

TOP