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