How to use Google Sheet: The Complete Beginner’s Guide

What is Google Sheets?

How to get started with Google Sheets?

How to create a spreadsheet?

  1. Click the red “NEW” button on your Google Drive dashboard and select “Google Sheets”
  2. Open the menu from within a spreadsheet and select “File > New Spreadsheet”
  3. Click “Blank” or select a template on the Google Sheets homepage

How to add data to the spreadsheet?

  1. Click a cell that’s empty, or double-click a cell that isn’t empty.
  2. Start typing.
  1. Copy and paste a list of text or numbers into your spreadsheet
  2. Copy and paste an HTML table from a website
  3. Import an existing spreadsheet in csv, xls, xlsx and other formats

How to import a file to Google Sheets?

How to Format Data and use other functions?

How to do basic formatting with rows and columns?

  • Click on the existing column or row next to where you’d like to insert a new column or row.
  • Right-click and the options menu will appear
  • Select Insert Before (or Insert After) for Columns, or Insert Above (or Insert Below) for Rows:
  • Click the cell where you want to add an image.
  • Click Insert > Image.
  • Select to place your image in the cell or over the cells. Cells with an image cannot also have text.
  • Choose an image or take a snapshot.
  • Click Open or Select.

How to use Data and basic formulas in Google Sheets?

  • Plain text format
  • Number format
  • Date format
  • Currency
  • Duration and more

How to Add, Average, and Filter Data with Formulas?

How to call a function in Google Sheets?

How can you share your Data?

  • Click either FILE > SHARE or use the blue “Share” button in the top right
  • Click “advanced”, then enter emails of who can view or edit your spreadsheet
  • Select any other privacy options and hit done
  • View-only access, so that person can not change or comment on any data
  • Comment-only access, so that person can add comments but still not make any changes to the data in the Sheet
  • Editing access, so that person can make changes to the sheet (including comments)

Comments (and Notes)

Real-time Sheets using

How to Use Your Spreadsheet in Offline Mode?

  • Google Chrome
  • Google Drive Chrome Web App
  • Google Drive Sync

What is conditional formatting and how you can do that with Google sheets?

How to Sort data in Google Sheets?

How to Filter data in Google Sheets?

--

--

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store