Explore

Google Sheets

Approx. 3 hours to complete

Save Course

Go to Course

Course Summary

Learn how to use Google Sheets to organize and analyze your data. This course covers everything from basic functions to advanced features like macros and add-ons.

Key Learning Points

Create and format spreadsheets in Google Sheets
Use basic functions and formulas to analyze data
Automate tasks with macros and add-ons

Learning Outcomes

Create and format spreadsheets in Google Sheets
Use basic functions and formulas to analyze data
Automate tasks with macros and add-ons

Prerequisites or good to have knowledge before taking this course

Basic computer skills
Familiarity with spreadsheets

Course Difficulty Level

Beginner to Intermediate

Course Format

Online self-paced
Video lectures
Hands-on exercises

Similar Courses

Excel Skills for Business: Essentials
Python for Data Science

Related Education Paths

Notable People in This Field

Chandoo
Google Sheets Tips

Related Books

Description

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.

Knowledge

Add, import, manage, and format data using Google Sheets.
Filter, summarize, and protect data in Google Sheets.
Perform calculations and visualize your spreadsheet data.
Use best practices to share and collaborate in Google Sheets.

Outline

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
Introduction to Google Sheets

Manage data using Google Sheets
Manage data using Google Sheets
Activity 2 explained
Activity 2 Manage data in Google Sheets
Manage data using Google Sheets

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

Basic formulas, functions, and charts
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
Activity 4 Use formulas to perform calculations
Activity 5 Use named ranges
Activity 6 Create a chart
Basic formulas, functions, and charts

Share your Google Sheets spreadsheets
Share your Google Sheets spreadsheets
Activity 7 explained
Activity 7 Explore sharing options
Share your Google Sheets spreadsheets

Collaborate with Google Sheets
Collaborate with Google Sheets
Activity 8 explained
Chat and Gmail integration
Activity 8 Comments and action items
Collaborate with Google Sheets

Business challenge
Business challenge overview
Business challenge explained
Wrap up
Activity 9 Business challenge

Summary of User Reviews

This Google Sheets course on Coursera has received positive reviews from learners. Many users have found it to be a comprehensive and easy-to-follow course that covers a wide range of topics related to Google Sheets.

Key Aspect Users Liked About This Course

The course is well-structured and covers all the important aspects of Google Sheets.

Pros from User Reviews

Comprehensive course content
Easy-to-follow tutorials
Interactive quizzes and assignments
Good for beginners and intermediate users
Flexible schedule and self-paced learning

Cons from User Reviews

Not suitable for advanced users
Some users found the course too basic
Lack of personalized feedback from instructors
No live sessions or interaction with other learners
Limited practical examples or use cases

Recommended for you

Google Sheets: Make a Loan Calculator With Extra Repayments

Build a loan calculator in Google Sheets with extra repayments using INDEX/MATCH, data validation, formatting and more. If so, then this course is for you!...

Save Course

Microsoft Excel: Excel - Beginner to Advanced (Full Excel)

Became in a master of Excel. Microsoft Excel 2010, 2013, 2016, Excel 2019 and Office 365 (Pivot table, formulas, data) LAST UPDATE - 06/17/2020...

Save Course

Inventory Analytics

Inventory analytics is the corner stone of supply chain analytics. A company in trade industries may have 30-50% of their assets tied up in inventory....

Save Course

RShiny for Everyone

Use R’s Shiny package to create data-driven, interactive web applications. Your application will feature an interactive map, biodiversity calculator, trail journal and species images....

Save Course