Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Google

Google Sheets

Google via Google Cloud Skills Boost

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!
In this course we will introduce you to Google Sheets, Google’s cloud-based spreadsheet software, included with Google Workspace. With Google Sheets, you can create and edit spreadsheets directly in your web browser—no special software is required. Multiple people can work simultaneously, you can see people’s changes as they make them, and every change is saved automatically. You will learn how to open Google Sheets, create a blank spreadsheet, and create a spreadsheet from a template. You will add, import, sort, filter and format your data using Google Sheets and learn how to work across different file types. Formulas and functions allow you to make quick calculations and better use your data. We will look at creating a basic formula, using functions, and referencing data. You will also learn how to add a chart to your spreadsheet. Google Sheets spreadsheets are easy to share. We will look at the different ways you can share with others. We will also discuss how to track changes and manage versions of your Google Sheets spreadsheets. Google Workspace makes it easy to collaborate with your team, clients, and others wherever they are. We will look at some of the collaboration options available to you in Google Sheets. Examples include commenting, action items, and notifications.

Syllabus

  • Course introduction
    • Course introduction
    • Agenda
  • Introduction to Google Sheets
    • Introduction to Google Sheets
    • Activity 1 explained
    • Activity 1 Import an Excel spreadsheet to Google Sheets
    • Quiz
  • Manage data using Google Sheets
    • Manage data using Google Sheets
    • Activity 2 explained
    • Activity 2 Manage data in Google Sheets
    • Quiz
  • Format a Google Sheets spreadsheet
    • Format a Google Sheets spreadsheet
    • Format a Sheet
    • Cell types, rows and columns
    • Activity 3 explained
    • Activity 3 Apply formatting to a Google Sheet
    • Manage multiple sheets
    • Quiz
  • Basic formulas, functions, and charts
    • Basic formulas, functions, and charts
    • Basic functions
    • Activity 4 explained
    • Activity 4 Use formulas to perform calculations
    • Summarize data with charts
    • Create a chart
    • Import, export, date types, and more
    • Activities 5 and 6 explained
    • Activity 5 Use named ranges
    • Activity 6 Create a chart
    • Quiz
  • Share your Google Sheets spreadsheets
    • Share your Google Sheets spreadsheets
    • Activity 7 explained
    • Activity 7 Explore sharing options
    • Quiz
  • Collaborate with Google Sheets
    • Collaborate with Google Sheets
    • Activity 8 explained
    • Activity 8 Comments and action items
    • Chat and Gmail integration
    • Quiz
  • Business challenge
    • Business challenge overview
    • Business challenge explained
    • Activity 9 Business challenge
    • Wrap up
  • Your Next Steps
    • Course Badge

Reviews

5.0 rating, based on 3 Class Central reviews

Start your review of Google Sheets

  • Profile image for Ruth Carlie
    Ruth Carlie
    I will sincerely recommend this course to anyone who is a newbie and wants to learn how to edit and work on google sheet. The course comprehensively highlines the steps by step procedure on how to work on a google sheet.
  • Profile image for Deepak Chaudhary
    Deepak Chaudhary
    I will sincerely recommend this course to anyone who is a newbie and wants to learn how to edit and work on google sheet. The course comprehensively highlines the steps by step procedure on how to work on a google sheet. Thnku
  • Anonymous
    I found the course very informative and well-structured and the tutor to give clear instructions. Recommended for everyone.

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.