Google Sheets - Advanced Topics (Coursera)

Spreadsheets can hold millions of numbers, formulas, and text. Making sense of all of that data can be difficult without a summary or visualization. This course explores the data visualization options in Google Sheets, such as charts and pivot tables.
Google Forms are online surveys used to collect data and provide the opportunity for quick data analysis. You will explore how Forms and Sheets work together by connecting collected Form data to a spreadsheet, or by creating a Form from an existing spreadsheet.
Course 8 of 8 in the Getting started with Google Workspace Specialization.

What You Will Learn

• Apply advanced formatting within a Google Sheet
• Perform calculations and visualize data using Google Sheets
• Create and collect data from a Google Form
• Solve business challenges using Google Sheets

Syllabus

WEEK 1
Course introduction
This module covers the agenda. It also introduces students to On the Rise and the course business challenge.
Advanced formatting in a Google Sheet
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.
Advanced formulas and functions
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.
Analyze and report
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.
Populate data using a Google Form
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.
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.