Google Sheets Quick Reference Guide

Google Sheets Quick Reference Guide

Subject: Google Sheets
Level: Introductory
Topics Covered: 59
Pages: 4
Dimensions: 11 x 17″ – Folded
Availability: Printed & Laminated or PDF Download
Price: $5.95     Quantity Discounts Available
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

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 Worksheets
Adjusting Page Breaks

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