Google Sheets Basics 2018: The quick guide to Google Sheets [Unofficial].Use formats, functions, formulas, pivot tables, graphs, and many other functions conveniently!

This textbook will be the first Google Sheet textbook for you.
This quick guide will help you learn Google Sheets basics.
You will learn Formulas, Functions, Pivot Table, Charts, etc…
It’s a very kind Google Sheets tutorial that will help your learning in anywhere.
This book has so many screenshots that demonstrate what should you do.

Contents Table
Chapter1. Let’s use Google Sheet
– Login to your Google Account
– Access “Google Drive”
– Create a folder
– The basic operation of a file
– Create a Google Sheet
– The experience of operating shortcut key
– Relative reference & Absolute reference

Chapter2. The basic operation of Google Sheet
– Add sheets
– Change sheet color
– Copy sheets
– Delete a sheet
– Hide/Unhide Sheets
– Input data to sheet
– The calculation of total with functions
– Vertical align
Setting Bold / Colors / Border / Number Format / Font Size
Italic / Strikethrough / Column Width (Height) / Merging cells
Copy the data to other sheets

Chapter3. Let’s use functions.
– Multiplication of cells side by side
– Create an invoice data
– Functions (SUM / TODAY / ROUND / VLOOKUP / IF)

Chapter4. Find and arrange data
Find data
– Prepare for database
– Let’s use “Filter”!
– Let’s sort data!
– Let’s use “Explore (Google Sheet’s AI)”!

Chapter 5. Let’s use “Pivot table”.
– Let’s use a pivot table!
– Reopen pivot table editor

Chapter 6. Let’s use “Chart”.
– Let’s create a chart!
– A lot of styles of charts

Chapter 7. Let’s use Google Sheet more!
– Let’s set up validation rule (the list of choices).
– Let’s set up validation rule(date).
– The collaboration function with other collaborative editors
– The Comment Function
– The Note Function
– Let’s share the data you made.

#