Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

LinkedIn Learning

Google Sheets: Advanced Topics

via LinkedIn Learning

Write review
Coursera Ad

Learn AI, Data Science & Business — Earn Certificates That Get You Hired

Learn More → Simplilearn Ad

Earn a Michigan Engineering AI Certificate — Stay Ahead of the AI Revolution

Learn More →

Overview

Google, IBM & Meta Certificates – 40% Off
One plan covers every Professional Certificate on Coursera.
Unlock All Certificates
Upskill your data analytics and visualization capabilities in this advanced skills course for the online spreadsheet app Google Sheets.

Syllabus

Introduction
  • Course introduction
  • Agenda
1. Advanced Formatting in a Google Sheet
  • Advanced formatting in a Google Sheet
  • Conditional formatting
  • Activity 1 explained
2. Advanced Formulas and Functions
  • Advanced formulas and functions
  • Using IF and IFS to analyze data
  • Activity 2 explained
  • Data validation and named ranges
  • Activity 3 explained
3. Analyze and Report
  • Analyze and report
  • Exploring charts
  • Activity 4 explained
  • Pivot tables
  • Create a pivot table
  • Activity 5 explained
  • Integration and publishing in Google Sheets
  • Activity 6 explained
  • Macros
  • Apply a macro
4. Populate Data Using a Google Form
  • Populate data using a Google Form
  • Activity 7 explained
  • Form settings and sharing a Google Form
  • Activity 8 explained
  • Managing feedback
5. Business Challenge
  • Business challenge overview
  • Business challenge explained
  • Wrap-up

Taught by

Google Cloud

Reviews

4.6 rating at LinkedIn Learning based on 567 ratings

Start your review of Google Sheets: Advanced Topics

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free
Someone learning on their laptop while sitting on the floor.