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

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

","steps":[{"id":"536140","prompt":null,"isOptional":true,"activities":[{"id":"529038","href":"/course_templates/293/video/529038","isLocked":false,"duration":147000,"title":"Course introduction","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"536141","prompt":null,"isOptional":true,"activities":[{"id":"529039","href":"/course_templates/293/video/529039","isLocked":false,"duration":78000,"title":"Agenda","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false}],"expanded":false},{"id":"77520","title":"Advanced formatting in a Google Sheet","description":"

There are many advanced formatting options that help you customize your Google Sheets and leverage your data. In this module, we are going to talk about applying themes and conditional formatting options.

","steps":[{"id":"536142","prompt":null,"isOptional":true,"activities":[{"id":"529040","href":"/course_templates/293/video/529040","isLocked":false,"duration":114000,"title":"Advanced formatting in a Google Sheet","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"536143","prompt":null,"isOptional":true,"activities":[{"id":"529041","href":"/course_templates/293/video/529041","isLocked":false,"duration":108000,"title":"Conditional formatting","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"536144","prompt":null,"isOptional":true,"activities":[{"id":"529042","href":"/course_templates/293/video/529042","isLocked":false,"duration":13000,"title":"Activity 1 explained","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"536145","prompt":null,"isOptional":true,"activities":[{"id":"529043","href":"/course_templates/293/documents/529043","isLocked":false,"duration":1800000,"title":"Activity 1 Apply conditional formatting to a Google Sheet","description":null,"type":"document","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"536146","prompt":null,"isOptional":false,"activities":[{"id":"529044","href":"/course_templates/293/quizzes/529044","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":"77521","title":"Advanced formulas and functions","description":"

Formulas and functions allow you to make quick calculations and better use your data. Google Sheets supports many of the formulas found in other spreadsheet applications. In this module, we are going to look at creating a formula, using functions, and referencing and validating data. We will also discuss how using named ranges can assist you when working with data sets.

","steps":[{"id":"536147","prompt":null,"isOptional":true,"activities":[{"id":"529045","href":"/course_templates/293/video/529045","isLocked":false,"duration":166000,"title":"Advanced formulas and functions","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"536148","prompt":null,"isOptional":true,"activities":[{"id":"529046","href":"/course_templates/293/video/529046","isLocked":false,"duration":247000,"title":"Using IF and IFS to analyze data","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"536149","prompt":null,"isOptional":true,"activities":[{"id":"529047","href":"/course_templates/293/video/529047","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":"536150","prompt":null,"isOptional":true,"activities":[{"id":"529048","href":"/course_templates/293/documents/529048","isLocked":false,"duration":1800000,"title":"Activity 2 Using the IFS function in Google Sheets","description":null,"type":"document","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"536151","prompt":null,"isOptional":true,"activities":[{"id":"529049","href":"/course_templates/293/video/529049","isLocked":false,"duration":206000,"title":"Data validation and named ranges","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"536152","prompt":null,"isOptional":true,"activities":[{"id":"529050","href":"/course_templates/293/video/529050","isLocked":false,"duration":12000,"title":"Activity 3 explained","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"536153","prompt":null,"isOptional":true,"activities":[{"id":"529051","href":"/course_templates/293/documents/529051","isLocked":false,"duration":1800000,"title":"Activity 3 Create a data validation rule and name a range","description":null,"type":"document","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"536154","prompt":null,"isOptional":false,"activities":[{"id":"529052","href":"/course_templates/293/quizzes/529052","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":"77522","title":"Analyze and report","description":"

Spreadsheets can hold millions of numbers, formulas, and text. Making sense of all of that data can be difficult without a summary or visualization, especially when presenting the data to colleagues, partners, prospects, or clients. In this module, we are going to explore the data visualization options in Google Sheets, such as charts and pivot tables. We will discuss how Google Workspace integration makes it easy to share your charts and tables in Google Docs and Google Slides. We also look at ways to automate repetitive tasks using macros.

","steps":[{"id":"536155","prompt":null,"isOptional":true,"activities":[{"id":"529053","href":"/course_templates/293/video/529053","isLocked":false,"duration":78000,"title":"Analyze and report","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"536156","prompt":null,"isOptional":true,"activities":[{"id":"529054","href":"/course_templates/293/video/529054","isLocked":false,"duration":169000,"title":"Exploring charts","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"536157","prompt":null,"isOptional":true,"activities":[{"id":"529055","href":"/course_templates/293/video/529055","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":"536158","prompt":null,"isOptional":true,"activities":[{"id":"529056","href":"/course_templates/293/documents/529056","isLocked":false,"duration":1800000,"title":"Activity 4 Create a chart using Google Sheets","description":null,"type":"document","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"536159","prompt":null,"isOptional":true,"activities":[{"id":"529057","href":"/course_templates/293/video/529057","isLocked":false,"duration":48000,"title":"Pivot tables","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"536160","prompt":null,"isOptional":true,"activities":[{"id":"529058","href":"/course_templates/293/video/529058","isLocked":false,"duration":217000,"title":"Create a pivot table","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"536161","prompt":null,"isOptional":true,"activities":[{"id":"529059","href":"/course_templates/293/video/529059","isLocked":false,"duration":9000,"title":"Activity 5 explained","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"536162","prompt":null,"isOptional":true,"activities":[{"id":"529060","href":"/course_templates/293/documents/529060","isLocked":false,"duration":1800000,"title":"Activity 5 Create a pivot table based on existing data","description":null,"type":"document","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"536163","prompt":null,"isOptional":true,"activities":[{"id":"529061","href":"/course_templates/293/video/529061","isLocked":false,"duration":235000,"title":"Integration and publishing in Google Sheets","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"536164","prompt":null,"isOptional":true,"activities":[{"id":"529062","href":"/course_templates/293/video/529062","isLocked":false,"duration":9000,"title":"Activity 6 explained","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"536165","prompt":null,"isOptional":true,"activities":[{"id":"529063","href":"/course_templates/293/documents/529063","isLocked":false,"duration":1800000,"title":"Activity 6 Explore publishing options","description":null,"type":"document","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"536166","prompt":null,"isOptional":true,"activities":[{"id":"529064","href":"/course_templates/293/video/529064","isLocked":false,"duration":156000,"title":"Macros","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"536167","prompt":null,"isOptional":true,"activities":[{"id":"529065","href":"/course_templates/293/video/529065","isLocked":false,"duration":76000,"title":"Apply a macro","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"536168","prompt":null,"isOptional":false,"activities":[{"id":"529066","href":"/course_templates/293/quizzes/529066","isLocked":false,"duration":1800000,"title":"Quiz","description":null,"type":"quiz","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false}],"expanded":false},{"id":"77523","title":"Populate data using a Google Form","description":"

Google Forms are online surveys used to collect data and provide the opportunity for quick data analysis. In this module, we’re going to explore how Google Forms and Google Sheets work together by connecting collected form data to a spreadsheet, or by creating a form from an existing spreadsheet.

","steps":[{"id":"536169","prompt":null,"isOptional":true,"activities":[{"id":"529067","href":"/course_templates/293/video/529067","isLocked":false,"duration":228000,"title":"Populate data using a Google Form","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"536170","prompt":null,"isOptional":true,"activities":[{"id":"529068","href":"/course_templates/293/video/529068","isLocked":false,"duration":6000,"title":"Activity 7 explained","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"536171","prompt":null,"isOptional":true,"activities":[{"id":"529069","href":"/course_templates/293/documents/529069","isLocked":false,"duration":1800000,"title":"Activity 7 Create a Google Form","description":null,"type":"document","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"536172","prompt":null,"isOptional":true,"activities":[{"id":"529070","href":"/course_templates/293/video/529070","isLocked":false,"duration":220000,"title":"Form settings and sharing a Google Form","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"536173","prompt":null,"isOptional":true,"activities":[{"id":"529071","href":"/course_templates/293/video/529071","isLocked":false,"duration":13000,"title":"Activity 8 explained","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"536174","prompt":null,"isOptional":true,"activities":[{"id":"529072","href":"/course_templates/293/documents/529072","isLocked":false,"duration":1800000,"title":"Activity 8 Share a Google Form","description":null,"type":"document","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"536175","prompt":null,"isOptional":true,"activities":[{"id":"529073","href":"/course_templates/293/video/529073","isLocked":false,"duration":86000,"title":"Managing feedback","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"536176","prompt":null,"isOptional":false,"activities":[{"id":"529074","href":"/course_templates/293/quizzes/529074","isLocked":false,"duration":1200000,"title":"Quiz","description":null,"type":"quiz","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false}],"expanded":false},{"id":"77524","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":"536177","prompt":null,"isOptional":true,"activities":[{"id":"529075","href":"/course_templates/293/video/529075","isLocked":false,"duration":86000,"title":"Business challenge overview","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"536178","prompt":null,"isOptional":true,"activities":[{"id":"529076","href":"/course_templates/293/video/529076","isLocked":false,"duration":3000,"title":"Business challenge explained","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"536179","prompt":null,"isOptional":true,"activities":[{"id":"529077","href":"/course_templates/293/documents/529077","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":"536180","prompt":null,"isOptional":true,"activities":[{"id":"529078","href":"/course_templates/293/video/529078","isLocked":false,"duration":84000,"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 Sheets - Advanced Topics