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

Coursera Flash Sale
40% Off Coursera Plus for 3 Months!
Grab it
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

5.0 rating, based on 1 Class Central review

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

  • Profile image for POR VIDA E.E.M SPORTS HEART DEFINES A CHAMPION
    POR VIDA E.E.M SPORTS HEART DEFINES A CHAMPION
    This was so super easy. The instructor takes his time and simplifies everything he is doing. I never knew how much you could do with sheets!!! It’s awesome thank you Kevin u do an amazing job man!!!! Good luck with your business hope it keeps striving!!

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.