Google Sheets in 8 Hours, For Beginners, Learn Coding Fast: Google Sheets, Crash Course Textbook & Exercises

by Ray Yao, Ada C. Dom (Illustrator), Kafka R. Ant (Editor)

About This Book
"Google Sheets Programming" 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 Programming" 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.



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 Q & A
Questions
Answers


The paperback edition of this book is displaying in the lower section of this page, please click the book link for purchase.

132 pages, Kindle Edition

Published February 28, 2023

Reviews

[Shirin Reh · Rating 5 out of 5]

get this book!!!
it is really good teaches your everythijg except making charts,graphs and currency conversion.