Information Technology
Hands on Training icon
Hands On Training
Hands on Training icon

Google Sheets - Advanced Topics

Course Cover
compare button icon

Course Features

icon

Duration

49 minutes

icon

Delivery Method

Online

icon

Available on

Downloadable Courses

icon

Accessibility

Desktop, Laptop

icon

Language

English

icon

Subtitles

English

icon

Level

Intermediate

icon

Teaching Type

Self Paced

icon

Video Content

49 minutes

Course Description

This course is designed to build upon the knowledge gained in the previous Google Sheets course. It offers a deeper understanding of advanced functions and formulas within Google Sheets. Participants will learn how to create formulas using various functions and how to reference and validate data in a Google Sheet. With the ability to contain millions of numbers, formulas, and text, spreadsheets can be overwhelming without proper organization. This course will explore data visualization options in Google Sheets such as charts and pivot tables, providing participants with the tools to make sense of complex data sets. Additionally, participants will learn about Google Forms, an online survey tool that collects data for quick analysis. By connecting data from Google Forms to a spreadsheet or creating a form using an existing spreadsheet, participants will gain insights into how Google Sheets and Forms interact. This course is ideal for individuals who want to enhance their data management skills and improve their data analysis capabilities using Google Sheets.

Course Overview

projects-img

International Faculty

projects-img

Post Course Interactions

projects-img

Instructor-Moderated Discussions

projects-img

Case Studies, Captstone Projects

Skills You Will Gain

What You Will Learn

Google Forms are online surveys used to collect data and provide the opportunity for quick data analysis

Making sense of all of that data can be difficult without a summary or visualization

Spreadsheets can hold millions of numbers, formulas, and text

This course explores the data visualization options in Google Sheets, such as charts and pivot tables

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

You will explore how to create formulas using functions, and you will also learn how to reference and validate your data in a Google Sheet

You will learn about some of Google Sheets’ advanced formulas and functions

You will learn how to apply and customize themes In Google Sheets, and explore conditional formatting options

Course Cover