[{"id":"77452","title":"Course introduction","description":"

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

","steps":[{"id":"535727","prompt":null,"isOptional":true,"activities":[{"id":"528621","href":"/course_templates/196/video/528621","isLocked":false,"duration":125000,"title":"Course introduction","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"535728","prompt":null,"isOptional":true,"activities":[{"id":"528622","href":"/course_templates/196/video/528622","isLocked":false,"duration":89000,"title":"Agenda","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false}],"expanded":false},{"id":"77453","title":"Introduction to Google Sheets","description":"

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.

","steps":[{"id":"535729","prompt":null,"isOptional":true,"activities":[{"id":"528623","href":"/course_templates/196/video/528623","isLocked":false,"duration":218000,"title":"Introduction to Google Sheets","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"535730","prompt":null,"isOptional":true,"activities":[{"id":"528624","href":"/course_templates/196/video/528624","isLocked":false,"duration":7000,"title":"Activity 1 explained","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"535731","prompt":null,"isOptional":true,"activities":[{"id":"528625","href":"/course_templates/196/documents/528625","isLocked":false,"duration":1800000,"title":"Activity 1 Import an Excel spreadsheet to Google Sheets","description":null,"type":"document","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"535732","prompt":null,"isOptional":false,"activities":[{"id":"528626","href":"/course_templates/196/quizzes/528626","isLocked":false,"duration":600000,"title":"Quiz","description":null,"type":"quiz","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false}],"expanded":false},{"id":"77454","title":"Manage data using Google Sheets","description":"

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.

","steps":[{"id":"535733","prompt":null,"isOptional":true,"activities":[{"id":"528627","href":"/course_templates/196/video/528627","isLocked":false,"duration":319000,"title":"Manage data using Google Sheets","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"535734","prompt":null,"isOptional":true,"activities":[{"id":"528628","href":"/course_templates/196/video/528628","isLocked":false,"duration":11000,"title":"Activity 2 explained","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"535735","prompt":null,"isOptional":true,"activities":[{"id":"528629","href":"/course_templates/196/documents/528629","isLocked":false,"duration":1800000,"title":"Activity 2 Manage data in Google Sheets","description":null,"type":"document","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"535736","prompt":null,"isOptional":false,"activities":[{"id":"528630","href":"/course_templates/196/quizzes/528630","isLocked":false,"duration":600000,"title":"Quiz","description":null,"type":"quiz","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false}],"expanded":false},{"id":"77455","title":"Format a Google Sheets spreadsheet","description":"

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.

","steps":[{"id":"535737","prompt":null,"isOptional":true,"activities":[{"id":"528631","href":"/course_templates/196/video/528631","isLocked":false,"duration":18000,"title":"Format a Google Sheets spreadsheet","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"535738","prompt":null,"isOptional":true,"activities":[{"id":"528632","href":"/course_templates/196/video/528632","isLocked":false,"duration":254000,"title":"Format a Sheet","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"535739","prompt":null,"isOptional":true,"activities":[{"id":"528633","href":"/course_templates/196/video/528633","isLocked":false,"duration":141000,"title":"Cell types, rows and columns","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"535740","prompt":null,"isOptional":true,"activities":[{"id":"528634","href":"/course_templates/196/video/528634","isLocked":false,"duration":7000,"title":"Activity 3 explained","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"535741","prompt":null,"isOptional":true,"activities":[{"id":"528635","href":"/course_templates/196/documents/528635","isLocked":false,"duration":1800000,"title":"Activity 3 Apply formatting to a Google Sheet","description":null,"type":"document","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"535742","prompt":null,"isOptional":true,"activities":[{"id":"528636","href":"/course_templates/196/video/528636","isLocked":false,"duration":129000,"title":"Manage multiple sheets","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"535743","prompt":null,"isOptional":false,"activities":[{"id":"528637","href":"/course_templates/196/quizzes/528637","isLocked":false,"duration":600000,"title":"Quiz","description":null,"type":"quiz","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false}],"expanded":false},{"id":"77456","title":"Basic formulas, functions, and charts","description":"

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.

","steps":[{"id":"535744","prompt":null,"isOptional":true,"activities":[{"id":"528638","href":"/course_templates/196/video/528638","isLocked":false,"duration":50000,"title":"Basic formulas, functions, and charts","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"535745","prompt":null,"isOptional":true,"activities":[{"id":"528639","href":"/course_templates/196/video/528639","isLocked":false,"duration":232000,"title":"Basic functions","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"535746","prompt":null,"isOptional":true,"activities":[{"id":"528640","href":"/course_templates/196/video/528640","isLocked":false,"duration":7000,"title":"Activity 4 explained","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"535747","prompt":null,"isOptional":true,"activities":[{"id":"528641","href":"/course_templates/196/documents/528641","isLocked":false,"duration":1800000,"title":"Activity 4 Use formulas to perform calculations","description":null,"type":"document","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"535748","prompt":null,"isOptional":true,"activities":[{"id":"528642","href":"/course_templates/196/video/528642","isLocked":false,"duration":79000,"title":"Summarize data with charts","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"535749","prompt":null,"isOptional":true,"activities":[{"id":"528643","href":"/course_templates/196/video/528643","isLocked":false,"duration":220000,"title":"Create a chart","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"535750","prompt":null,"isOptional":true,"activities":[{"id":"528644","href":"/course_templates/196/video/528644","isLocked":false,"duration":184000,"title":"Import, export, date types, and more","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"535751","prompt":null,"isOptional":true,"activities":[{"id":"528645","href":"/course_templates/196/video/528645","isLocked":false,"duration":18000,"title":"Activities 5 and 6 explained","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"535752","prompt":null,"isOptional":true,"activities":[{"id":"528646","href":"/course_templates/196/documents/528646","isLocked":false,"duration":1800000,"title":"Activity 5 Use named ranges","description":null,"type":"document","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"535753","prompt":null,"isOptional":true,"activities":[{"id":"528647","href":"/course_templates/196/documents/528647","isLocked":false,"duration":1800000,"title":"Activity 6 Create a chart","description":null,"type":"document","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"535754","prompt":null,"isOptional":false,"activities":[{"id":"528648","href":"/course_templates/196/quizzes/528648","isLocked":false,"duration":300000,"title":"Quiz","description":null,"type":"quiz","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false}],"expanded":false},{"id":"77457","title":"Share your Google Sheets spreadsheets","description":"

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.

","steps":[{"id":"535755","prompt":null,"isOptional":true,"activities":[{"id":"528649","href":"/course_templates/196/video/528649","isLocked":false,"duration":317000,"title":"Share your Google Sheets spreadsheets","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"535756","prompt":null,"isOptional":true,"activities":[{"id":"528650","href":"/course_templates/196/video/528650","isLocked":false,"duration":10000,"title":"Activity 7 explained","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"535757","prompt":null,"isOptional":true,"activities":[{"id":"528651","href":"/course_templates/196/documents/528651","isLocked":false,"duration":1800000,"title":"Activity 7 Explore sharing options","description":null,"type":"document","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"535758","prompt":null,"isOptional":false,"activities":[{"id":"528652","href":"/course_templates/196/quizzes/528652","isLocked":false,"duration":600000,"title":"Quiz","description":null,"type":"quiz","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false}],"expanded":false},{"id":"77458","title":"Collaborate with Google Sheets","description":"

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.

","steps":[{"id":"535759","prompt":null,"isOptional":true,"activities":[{"id":"528653","href":"/course_templates/196/video/528653","isLocked":false,"duration":161000,"title":"Collaborate with Google Sheets","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"535760","prompt":null,"isOptional":true,"activities":[{"id":"528654","href":"/course_templates/196/video/528654","isLocked":false,"duration":9000,"title":"Activity 8 explained","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"535761","prompt":null,"isOptional":true,"activities":[{"id":"528655","href":"/course_templates/196/documents/528655","isLocked":false,"duration":1800000,"title":"Activity 8 Comments and action items","description":null,"type":"document","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"535762","prompt":null,"isOptional":true,"activities":[{"id":"528656","href":"/course_templates/196/video/528656","isLocked":false,"duration":64000,"title":"Chat and Gmail integration","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"535763","prompt":null,"isOptional":false,"activities":[{"id":"528657","href":"/course_templates/196/quizzes/528657","isLocked":false,"duration":900000,"title":"Quiz","description":null,"type":"quiz","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false}],"expanded":false},{"id":"77459","title":"Business challenge","description":"

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

","steps":[{"id":"535764","prompt":null,"isOptional":true,"activities":[{"id":"528658","href":"/course_templates/196/video/528658","isLocked":false,"duration":67000,"title":"Business challenge overview","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"535765","prompt":null,"isOptional":true,"activities":[{"id":"528659","href":"/course_templates/196/video/528659","isLocked":false,"duration":5000,"title":"Business challenge explained","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"535766","prompt":null,"isOptional":true,"activities":[{"id":"528660","href":"/course_templates/196/documents/528660","isLocked":false,"duration":1800000,"title":"Activity 9 Business challenge","description":null,"type":"document","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"535767","prompt":null,"isOptional":true,"activities":[{"id":"528661","href":"/course_templates/196/video/528661","isLocked":false,"duration":63000,"title":"Wrap up","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false}],"expanded":false},{"id":"next-steps","title":"Your Next Steps","description":null,"steps":[{"id":"badge-step","prompt":null,"isOptional":true,"activities":[{"id":"badge","href":null,"isLocked":true,"duration":null,"title":"Course Badge","description":null,"type":"badge","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false}],"expanded":true}]

Google Cloud Skills Boost

Google Sheets