Google Sheets
- Offered byCoursera
Google Sheets at Coursera Overview
Duration | 3 hours |
Start from | Start Now |
Total fee | Free |
Mode of learning | Online |
Difficulty level | Beginner |
Official Website | Explore Free Course |
Credential | Certificate |
Google Sheets at Coursera Highlights
- Shareable Certificate Earn a Certificate upon completion
- 100% online Start instantly and learn at your own schedule.
- Course 5 of 7 in the Getting started with Google Workspace Specialization
- Flexible deadlines Reset deadlines in accordance to your schedule.
- Beginner Level
- Approx. 3 hours to complete
- English Subtitles: English
Google Sheets at Coursera Course details
- 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.
Google Sheets at Coursera Curriculum
Course Introduction
Course introduction
Agenda
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
Activity 2 explained
Activity 2 Manage data in Google Sheets
Manage data using Google Sheets
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 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
Activity 7 explained
Activity 7 Explore sharing options
Share your Google Sheets spreadsheets
Collaborate with Google Sheets
Activity 8 explained
Chat and Gmail integration
Activity 8 Comments and action items
Collaborate with Google Sheets
Business challenge overview
Business challenge explained
Wrap up
Activity 9 Business challenge