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

YouTube

Google Sheets - From Basics to Advanced Features Tutorial

Kevin Stratvert via YouTube

Overview

Master Google Sheets from scratch in this comprehensive 49-minute tutorial that progresses from basic spreadsheet operations to advanced data analysis features. Start with fundamental concepts like navigating the interface, working with cells, and entering data efficiently using smart fill. Learn essential formatting techniques including number formatting, column/row adjustments, and conditional formatting. Advance through mathematical operations and key functions like SUM and VLOOKUP while understanding crucial concepts such as relative/absolute references and named ranges. Explore data organization with multiple worksheets, sorting, and filtering capabilities. Create impactful visualizations using charts and pivot tables, integrate data collection through forms, and discover collaboration features including sharing, version history, and publishing options. Access additional free Google training resources and practice with provided sample workbooks to reinforce learning.

Syllabus

Introduction
Official Google Sheets training
What is Google Sheets
How to get Google Sheets
Start page
Top bar
Cells, columns, & rows
Zoom level
Enter data & smart fill
Format numbers
Adjust column widths & row heights
Move columns & rows
Alternating colors
Conditional formatting
Hide columns & rows
Insert columns & rows
Freeze columns & rows
Column stats
Explore
Addition
Subtraction
Multiplication
Division
Functions
SUM function
Relative & absolute references
Named ranges
VLOOKUP function
Multiple worksheets
Sort & filter
Filter views
Charts
Pivot tables
Create a new form
Share & collaborate with others
Version history
Publish, email, & print
Wrap up

Taught by

Kevin Stratvert

Reviews

Start your review of Google Sheets - From Basics to Advanced Features Tutorial

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.