How to use Google Sheets – Tutorial for Beginners

In this step-by-step tutorial, learn how to use Google Sheets. Google Sheets is completely free to use, and you can use it to get insights from your data. We begin with the absolute basics of how you can even get started in Sheets. Once we cover the basics, we advance to entering formulas and functions, inserting charts, using pivot tables, collecting data from a form, and so much more. By the end of this video, you’ll be proficient in using Google Sheets.
This video is sponsored by Google.

• FREE TRAINING OFFERED BY GOOGLE
  Google Sheets Getting Started course
  Google Sheets Advanced Topics course
  Google Sheets Functions, Formulas, and Charts course
• RESOURCES
  Google Sheets Start Page
  Google Sheets New Blank Spreadsheet
  How to use Google Forms video
  Sample Workbook Used in Video
• TIMESTAMPS
  00:00 Introduction
  00:46 Official Google Sheets training
  01:43 What is Google Sheets
  02:24 How to get Google Sheets
  03:30 Start page
  04:30 Top bar
  06:26 Cells, columns, & rows
  07:30 Zoom level
  07:46 Enter data & smart fill
  10:04 Format numbers
  11:01 Adjust column widths & row heights
  12:24 Move columns & rows
  12:57 Alternating colors
  13:42 Conditional formatting
  15:07 Hide columns & rows
  15:57 Insert columns & rows
  16:57 Freeze columns & rows
  17:42 Column stats
  19:01 Explore
  19:54 Addition
  21:52 Subtraction
  22:13 Multiplication
  22:35 Division
  22:54 Functions
  23:40 SUM function
  25:53 Relative & absolute references
  28:20 Named ranges
  29:32 VLOOKUP function
  31:57 Multiple worksheets
  33:57 Sort & filter
  35:30 Filter views
  36:39 Charts
  39:09 Pivot tables
  42:49 Create a new form
  44:23 Share & collaborate with others
  47:24 Version history
  48:02 Publish, email, & print
  48:31 Wrap up