Getting Started with Google Sheets (Coursera)

First, you’ll learn how to input and format your data. Next, you’ll learn how formulas, functions and a few exclusive Google Sheets features can accelerate your data analysis. Finally, you’ll get tips for sharing your spreadsheets and collaborating on them with your team.

Syllabus

WEEK 1

Welcome to Google Sheets: how to create, edit, and print your spreadsheet

Getting started with Google Sheets is simple. Let’s start with the basics. Learn how to create and edit your spreadsheet. Then print or publish it to the web.

WEEK 2

Working with formulas and functions: how to import and analyze your data

Anyone can be a data analyst with Google Sheets. Learn how to use formulas, functions, and other key features to help you analyze data effectively.

WEEK 3

Telling stories with data: how to design your sheet to highlight trends

Explore how Google Sheets allows you to design spreadsheets that are both aesthetically pleasing and informative.

WEEK 4

Supercharge your sheet: how to create charts, pivot tables, and reports

Google Sheets empowers you to detect and visualize data with no advanced coding required. This module will show you how to generate charts, pivot tables, and other shareable reports of your data.

WEEK 5

Collaborating in Sheets: how to share your data with your team

With Google Sheets you can work in real-time on a spreadsheet. Learn how to share your data with your team.