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

YouTube

Google Sheets Beginner Tutorial

Learnit Training via YouTube

Overview

Coursera Flash Sale
40% Off Coursera Plus for 3 Months!
Grab it
Learn the fundamentals of Google Sheets in this 55-minute beginner tutorial from Learnit Training. Master the web interface and essential features as you navigate through the spreadsheet environment, create headers, adjust column widths, and leverage Smart Fill for automated data entry. Discover how to enter and organize data efficiently, perform calculations using formulas and functions like SUM, AVERAGE, and IF, and implement absolute cell references for consistent calculations. Apply professional formatting techniques including alternating row colors, build dynamic attendance and scoring tables, generate email strings, and use checkboxes with COUNTIF and conditional formatting to automate task tracking. Perfect for complete beginners, students managing simple data, or professionals wanting to streamline basic spreadsheet tasks in Google's cloud-based collaborative environment.

Syllabus

Start 0:00
Introduction 0:09
Google Sheet Interface 1:09
Adding Headers and Adjusting Column Widths 9:49
Using Smart Fill 16:30
Entering Data 20:58
Calculations, Formulas, and Functions 23:55
Using Average Function 33:15
IF Function with Absolute Cell Reference 36:42
Formatting our Worksheet 43:14
Checkboxes 48:18
Conclusion 54:08

Taught by

Learnit Training

Reviews

Start your review of Google Sheets Beginner 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.