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

YouTube

Google Sheets Advanced Tutorial

Learnit Training via YouTube

Start learning Write review
Coursera Ad

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

Learn More → Train in Data Ad

Master Production-Ready Machine Learning, Step by Step

Learn More →

Overview

Google, IBM & Meta Certificates – 40% Off
One Coursera Plus subscription covers most Professional Certificates on Coursera.
Unlock All Certificates
This tutorial teaches ways to organize, calculate, and interpret data in Google Sheets. It covers filters, charts, pivot tables, lookup and conditional formulas, file sharing, and real-time authoring.

Syllabus

Start
Introduction
List, Format, and Sort
Multi-Column Sort
Filters
Conditional Filters and Filtered Views
Creating Charts
Editing Charts
Removing and Deleting Chart Data
Sparklines
Formatting with Alternating Row Colors
Pivot Tables
Pivot Charts
Named Ranges
IF Functions
Nested Functions
VLOOKUP
SUMIF and AVERAGEIF
SUMIFS
AVERAGEIFS
IFERROR
LEFT and RIGHT
CONCATENATE
Sharing Files
Real-Time Authoring
Google Sheets Add-Ons
Introduction to Google Apps Scripts
Conclusion

Taught by

Learnit Training

Reviews

Start your review of Google Sheets Advanced Tutorial

Start learning

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.