Google Sheets from Coursera

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.

What's inside

Syllabus

Course Introduction

This module covers the agenda. It also introduces students to On the Rise and the course business challenge.

Introduction to Google Sheets

In this module, we will introduce Google Sheets and discuss how to open and create a new spreadsheet. We will also look at importing an existing spreadsheet into Google Sheets.

Manage data using Google Sheets

In this module, we will talk about adding and organizing data with Google Sheets. You will learn how to add, paste and import data. You will also learn how to sort and filter data in your spreadsheets which is especially useful when working with large datasets.

Format a Google Sheets spreadsheet

In this module, we will explore some of the ways you can format your spreadsheets. This includes some of the basic formatting options, such as cell colors and text wrapping, and options to freeze cells and protect data in your Google Sheet.

Basic formulas, functions, and charts

In this module, we will look at creating a basic formula, using functions, named ranges and referencing data. You will also learn how to create a chart, and be introduced to Google Explore, a powerful tool that can be used to answer questions and make suggestions based on insights gained from your data.

Share your Google Sheets spreadsheets

In this module, we will look at the different ways to share your spreadsheets with others. You will learn how to add collaborators and assign them roles and permissions, and also learn how you can share your Google Sheets spreadsheet with a link. You will understand how to transfer ownership of your spreadsheets to another collaborator, track changes, and manage versions.

Collaborate with Google Sheets

In this module, we will look at some of the collaboration options available to you with Google Sheets. Examples include commenting, action items, and notifications.

Business challenge

In this module, you will put everything you have learned into practice by helping our fictional Google Workspace customer solve their business challenge.

Good to know

Know what's good

, what to watch for

, and possible dealbreakers

Introduces Google's cloud-based spreadsheet software included with Google Workspace

Teaches data importing and exporting, spreadsheet functions, and formulas

Provides collaborative capabilities suitable for team projects and sharing

Appropriate for those without spreadsheet software experience

Suitable for learners looking to improve their data management skills

Prerequisites may be necessary for learners with no spreadsheet experience

Reviews summary

Google sheets: beginner mastery

Learners say Google Sheets is an engaging course that offers a solid foundation in using the software. Interactive assignments and clear instruction help students get the most out of the course. Overall, beginners will find this course particularly useful in building a solid skill set in Google Sheets.

Focuses on foundational concepts.

"Very basic skill building course. This teaches you the absolute basics of Google Sheets."

"The course is very easy and goes over the most basic of Google Sheets features."

"It is good for beginners."

Lessons are well-paced and easy to follow.

"Very clear and concise learning, would recommend"

"Easy to learn and very informative. "

"Easy to learn! Excellent guidance!"

Interactive assignments make learning enjoyable.

"Amazing course! The best feature I loved was the assignments and activities as they allowed me to apply what I've learnt."

"Course was educational and practical enough."

"Practical work was amazing because it helped me to apply what I learned throughout the course."

Well-suited for beginners.

"A good start for beginners. I learnt a lot"

"Great Course for beginner"

"Very much helpful for absolute beginners."

Some lessons rely on static images instead of video demonstrations.

"That is, the videos contain still images instead of any sort of demonstration."

"really to easy and you could at least do real video instead of just explaining click here and there ... showing would be better and more efficient to remember"

"Although the course was good for introduction, the problem is that the steps are not shown in the videos alongside the corresponding narrations."

Activities

Be better prepared before your course. Deepen your understanding during and after it. Supplement your coursework and achieve mastery of the topics covered in Google Sheets with these activities:

Review Basic Spreadsheet Concepts

Show steps

Review the basics of spreadsheet software, such as creating and editing cells, using formulas, and formatting data. This will help you get up to speed quickly and make the most of Google Sheets.

Browse courses on Google Sheets

Show steps

Review the basics of spreadsheet software, such as creating and editing cells, using formulas, and formatting data.

Practice Using Formulas and Functions

Show steps

Practice using formulas and functions in Google Sheets to perform calculations and analyze data. This will help you become more proficient in using the software and improve your problem-solving skills.

Browse courses on Formulas and Functions

Show steps

Review the different types of formulas and functions available in Google Sheets.
Practice using formulas and functions to perform calculations and analyze data.

Create a Practice Spreadsheet

Show steps

Create a practice spreadsheet to apply your skills and experiment with different features of Google Sheets, such as creating charts and graphs, using conditional formatting, and using advanced formulas.

Browse courses on Data Visualization

Show steps

Choose a topic for your spreadsheet.
Gather data for your spreadsheet.
Create your spreadsheet and enter your data.
Format your spreadsheet and add charts or graphs.
Use conditional formatting to highlight important data.

Show all three activities

Career center

Learners who complete Google Sheets will develop knowledge and skills that may be useful to these careers:

Data Analyst

A Data Analyst gathers, analyzes, and interprets data to identify trends, patterns, and insights. They use statistical and analytical tools to develop visualizations and reports that help organizations make better decisions. The Google Sheets course provides a strong foundation for Data Analysts, as it teaches them how to organize, clean, and analyze data using spreadsheet software. The course also covers how to create charts and graphs to visualize data, which is an essential skill for Data Analysts.

See salaries and explore the career path for Data Analyst

Financial Analyst

A Financial Analyst evaluates and interprets financial data to make recommendations on investment opportunities. They use spreadsheet software to create models and perform calculations that help them make investment decisions. The Google Sheets course can be helpful for Financial Analysts, as it teaches them how to use spreadsheet software to perform financial analysis and create financial models.

See salaries and explore the career path for Financial Analyst

Business Analyst

A Business Analyst analyzes business processes and systems to identify areas for improvement. They use data analysis and modeling techniques to develop solutions that can help businesses improve their operations. The Google Sheets course may be useful for Business Analysts, as it teaches them how to use spreadsheet software to analyze data and create models.

See salaries and explore the career path for Business Analyst

Project Manager

A Project Manager plans, executes, and closes projects. They use spreadsheet software to track project progress, manage budgets, and communicate with stakeholders. The Google Sheets course can be helpful for Project Managers, as it teaches them how to use spreadsheet software to manage projects and track progress.

See salaries and explore the career path for Project Manager

Marketing Manager

A Marketing Manager develops and executes marketing campaigns to promote products or services. They use spreadsheet software to track campaign performance, manage budgets, and analyze data. The Google Sheets course may be useful for Marketing Managers, as it teaches them how to use spreadsheet software to track campaign performance and analyze data.

See salaries and explore the career path for Marketing Manager

Sales Manager

A Sales Manager leads and manages a team of sales professionals. They use spreadsheet software to track sales performance, manage budgets, and forecast sales. The Google Sheets course may be useful for Sales Managers, as it teaches them how to use spreadsheet software to track sales performance and forecast sales.

See salaries and explore the career path for Sales Manager

Operations Manager

An Operations Manager oversees the day-to-day operations of a business. They use spreadsheet software to track performance, manage budgets, and forecast demand. The Google Sheets course may be useful for Operations Managers, as it teaches them how to use spreadsheet software to track performance and forecast demand.

See salaries and explore the career path for Operations Manager

Human Resources Manager

A Human Resources Manager oversees the human resources department of an organization. They use spreadsheet software to track employee data, manage payroll, and administer benefits. The Google Sheets course may be useful for Human Resources Managers, as it teaches them how to use spreadsheet software to track employee data and manage payroll.

See salaries and explore the career path for Human Resources Manager

Loan Officer

A Loan Officer helps individuals and businesses obtain loans. They use spreadsheet software to calculate loan payments, track loan applications, and manage loan portfolios. The Google Sheets course may be useful for Loan Officers, as it teaches them how to use spreadsheet software to calculate loan payments and track loan applications.

See salaries and explore the career path for Loan Officer

Financial Planner

A Financial Planner helps individuals and families plan for their financial future. They use spreadsheet software to create financial plans, track investments, and forecast retirement income. The Google Sheets course may be useful for Financial Planners, as it teaches them how to use spreadsheet software to create financial plans and track investments.

See salaries and explore the career path for Financial Planner

IT Manager

An IT Manager oversees the information technology department of an organization. They use spreadsheet software to track IT assets, manage budgets, and forecast demand. The Google Sheets course may be useful for IT Managers, as it teaches them how to use spreadsheet software to track IT assets and forecast demand.

See salaries and explore the career path for IT Manager

Accountant

An Accountant prepares and analyzes financial statements. They use spreadsheet software to track financial data, create budgets, and prepare tax returns. The Google Sheets course may be useful for Accountants, as it teaches them how to use spreadsheet software to track financial data and create budgets.

See salaries and explore the career path for Accountant

Customer Service Representative

A Customer Service Representative provides customer service to customers. They use spreadsheet software to track customer data, manage tickets, and resolve customer issues. The Google Sheets course may be useful for Customer Service Representatives, as it teaches them how to use spreadsheet software to track customer data and manage tickets.

See salaries and explore the career path for Customer Service Representative

Insurance Agent

An Insurance Agent sells insurance policies to individuals and businesses. They use spreadsheet software to track client data, manage policies, and calculate premiums. The Google Sheets course may be useful for Insurance Agents, as it teaches them how to use spreadsheet software to track client data and manage policies.

See salaries and explore the career path for Insurance Agent

Real Estate Agent

A Real Estate Agent helps individuals and businesses buy and sell real estate. They use spreadsheet software to track listings, manage appointments, and calculate commissions. The Google Sheets course may be useful for Real Estate Agents, as it teaches them how to use spreadsheet software to track listings and manage appointments.

See salaries and explore the career path for Real Estate Agent