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 Apps Script Project Sheet UI custom Functions

Search Sheet data and select Sheet cells create custom Google Apps Script code to run within your Google Sheets G Suite...

Save Course

The Complete Investor Bootcamp 2021

The Key to Successful, Profitable, and Sustainable Future? Investing. (Learn How to Make Money in the Stock Market) What are your financial goals?...

Save Course

Data Engineering with Google BigQuery & Google Cloud

Building data pipeline with BigQuery, Data Studio, and other Google Cloud. Learn basic BigQuery sql & techniques. BigQuery is Google’s product for data warehouse....

Save Course

Intuit Bookkeeping Professional Certificate

Launch your career in bookkeeping. Gain the professional skills you need to succeed in the bookkeeping field. No degree or prior experience required....

Save Course