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