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

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!
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.7 rating at LinkedIn Learning based on 263 ratings

Start your review of Google Sheets: Advanced Topics

Never Stop Learning.

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

Someone learning on their laptop while sitting on the floor.