Monthly Subscription Starting at AED 99 + VAT

Google Sheets
  • Level Foundation
  • Duration 3 hours
  • Course by Google Cloud
  • Offered by

About

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.

Modules

Course introduction

    • 2 Videos
Show info about module content

2 Videos

  • Course introduction
  • Agenda

Introduction to Google Sheets

    • 2 Videos
    • 1 Readings
    • 1 Assignment
Show info about module content

1 Assignment

  • Introduction to Google Sheets

2 Videos

  • Introduction to Google Sheets
  • Activity 1 explained

1 Readings

  • Activity 1 Import an Excel spreadsheet to Google Sheets

Manage data using Google Sheets

    • 2 Videos
    • 1 Readings
    • 1 Assignment
Show info about module content

1 Assignment

  • Manage data using Google Sheets

2 Videos

  • Manage data using Google Sheets
  • Activity 2 explained

1 Readings

  • Activity 2 Manage data in Google Sheets

Format a Google Sheets spreadsheet

    • 5 Videos
    • 1 Readings
    • 1 Assignment
Show info about module content

1 Assignment

  • Format a Google Sheets spreadsheet

5 Videos

  • Format a Google Sheets spreadsheet
  • Format a Sheet
  • Cell types, rows and columns
  • Activity 3 explained
  • Manage multiple sheets

1 Readings

  • Activity 3 Apply formatting to a Google Sheet

Basic formulas, functions, and charts

    • 7 Videos
    • 3 Readings
    • 1 Assignment
Show info about module content

1 Assignment

  • Basic formulas, functions, and charts

7 Videos

  • Basic formulas, functions, and charts
  • Basic functions
  • Activity 4 explained
  • Summarize data with charts
  • Create a chart
  • Import, export, date types, and more
  • Activities 5 and 6 explained

3 Readings

  • Activity 4 Use formulas to perform calculations
  • Activity 5 Use named ranges
  • Activity 6 Create a chart

Share your Google Sheets spreadsheets

    • 2 Videos
    • 1 Readings
    • 1 Assignment
Show info about module content

1 Assignment

  • Share your Google Sheets spreadsheets

2 Videos

  • Share your Google Sheets spreadsheets
  • Activity 7 explained

1 Readings

  • Activity 7 Explore sharing options

Collaborate with Google Sheets

    • 3 Videos
    • 1 Readings
    • 1 Assignment
Show info about module content

1 Assignment

  • Collaborate with Google Sheets

3 Videos

  • Collaborate with Google Sheets
  • Activity 8 explained
  • Chat and Gmail integration

1 Readings

  • Activity 8 Comments and action items

Business challenge

    • 3 Videos
    • 1 Readings
Show info about module content

3 Videos

  • Business challenge overview
  • Business challenge explained
  • Wrap up

1 Readings

  • Activity 9 Business challenge

Auto Summary

Unlock the power of Google Sheets with this foundational course designed for IT and computer science enthusiasts. Guided by an expert instructor from Coursera, this course offers a comprehensive introduction to Google’s cloud-based spreadsheet software, part of Google Workspace. You will learn to navigate Google Sheets with ease, creating and editing spreadsheets directly in your web browser without the need for additional software. Master the functionalities that allow multiple users to collaborate in real time, with changes saved automatically. The course covers essential skills such as opening Google Sheets, creating spreadsheets from scratch or templates, and efficiently managing data through importing, sorting, filtering, and formatting. Elevate your data manipulation abilities by learning to craft basic formulas, utilize functions, and reference data effectively. Additionally, you'll discover how to enhance your spreadsheets with charts and share them effortlessly with others, tracking changes and managing versions seamlessly. Google Workspace’s collaborative features are also highlighted, showcasing options like commenting, assigning action items, and setting up notifications to streamline team workflows. Spanning 180 minutes, this course is perfect for beginners aiming to establish a solid foundation in Google Sheets. Available through Coursera’s Starter and Professional subscription plans, it’s an ideal learning opportunity for those looking to enhance their productivity and collaboration skills in a professional setting.

Google Cloud Training
Instructor

Google Cloud Training