GOOGLE SHEETS, In 8 Hours, For Beginners, Quick Start Guide: GOOGLE SHEETS Crash Course Tutorial & Exercises

by Ray Yao, Pandas C. Perl (Illustrator), Dart R. Swift (Editor)

About This Book
"Google Sheets in 8 Hours" is a textbook for high school and college students; it covers all essential Google Sheets language knowledge . You can learn complete primary skills of Google Sheets programming fast and easily .
The textbook includes a lot of practical examples for beginners and includes exercises for the college final exam, the engineer certification exam, and the job interview exam .
"Google Sheets in 8 Hours" is a useful textbook for beginners . The straightforward definitions, the plain examples, the elaborate explanations and the neat layout feature this helpful and educative book . You will be impressed by its distinctive and tidy writing style . Reading this book is a great enjoyment !

Note
This book is only suitable for Google Sheets programming beginners, high school students and college students; it is not for the experienced Google Sheets programmers .

Cheat Sheet of Google Sheets Available
This book provides a free Cheat Sheet of Google Sheets (PDF) for reference and quick study.




Table of Content
Hour 1
What are Google Sheets?
Start Google Sheets
Description of Spreadsheet
Cell Coordinate
Multiple Sheets
Calculation
Calculate by Coordinates (1)
Calculate by Coordinates (2)
Name Box
Selection

Hour 2
Select a Range (1)
Select a Range (2)
Select a Range (3)
Enlarge Selection
Fill Values
Fill the Sequence
Fill Characters & Numbers
Fill Calculating Results
Quick Menu
Move Data
Copy & Paste Data
Cut & Paste Data
Delete Data

Hour 3
Add a Row
Add a Column
Undo & Redo
Formulas
Show/Hide Formulas
Addition & Substraction
Multiplication & Division
Relative Reference
Absolute Reference

Hour 4
Format
Format Color
Format Border
Format Number
Format Painter
Format Alternating Colors
Remove Formatting

Hour 5
Single Color Formatting
Color Scale Formatting
Remove Gridlines
Sort Sheet in Ascending Order
Sort Sheet in Descending Order
Sort Range in Ascending Order
Sort Range in Descending Order

Hour 6
AND
AVERAGE
AVERAGEIF
COUNT
COUNTA
COUNTBLANK
Review Functions

Hour 7
COUNTIF
IF
IFS
MAX
MEDIAN
MIN
Review Functions

Hour 8
MODE
OR
SUM
SUMIF
SUMIFS
XOR
Review Functions

Google Sheets Questions & Answers
Questions
Answers

123 pages, Paperback

Published July 22, 2022