Google Sheets – Advanced Topics

Overview

This course builds on concepts from the earlier Google Sheets course. You will learn how to apply and customize themes, use conditional formatting, work with advanced formulas, reference and validate data, and create visualizations such as charts and pivot tables. The course also covers how Google Forms integrate with Sheets, allowing you to collect and analyze data efficiently.

Syllabus

Course introduction

• Course introduction
• Agenda

Advanced formatting in a Google Sheet

• Advanced formatting in a Google Sheet
• Conditional formatting
• Activity 1 explained
• Activity 1: Apply conditional formatting to a Google Sheet
• Quiz

Advanced formulas and functions

• Advanced formulas and functions
• Using IF and IFS to analyze data
• Activity 2 explained
• Activity 2: Using the IFS function in Google Sheets
• Data validation and named ranges
• Activity 3 explained
• Activity 3: Create a data validation rule and name a range
• Quiz

Analyze and report

• Analyze and report
• Exploring charts
• Activity 4 explained
• Activity 4: Create a chart using Google Sheets
• Pivot tables
• Create a pivot table
• Activity 5 explained
• Activity 5: Create a pivot table based on existing data

Integration and publishing in Google Sheets

• Activity 6 explained
• Activity 6: Explore publishing options
• Macros
• Apply a macro
• Quiz

Populate data using a Google Form

• Populate data using a Google Form
• Activity 7 explained
• Activity 7: Create a Google Form
• Form settings and sharing a Google Form
• Activity 8 explained
• Activity 8: Share a Google Form
• Managing feedback
• Quiz

Business challenge

• Business challenge overview
• Business challenge explained
• Activity 9: Business challenge

Wrap up

• Your Next Steps
• Course Badge