Learn Backend Development Part-Time, Online
Power BI Fundamentals - Create visualizations and dashboards from scratch
Overview
Coursera Flash Sale
40% Off Coursera Plus for 3 Months!
Grab it
This 55-minute beginner tutorial introduces the fundamentals of Google Sheets, a cloud-based spreadsheet application within Google Workspace. Learn to navigate the web interface, create and format spreadsheets, and utilize essential features step-by-step. Master entering and organizing data with headers and Smart Fill, perform calculations using formulas and functions (SUM, AVERAGE, IF), apply formatting including alternating row colors, build dynamic tables, generate email strings, use absolute cell references, and implement checkboxes with COUNTIF and conditional formatting for task tracking. Perfect for complete beginners, students managing simple data, or professionals wanting to streamline basic tasks in Google's collaborative spreadsheet tool that enables real-time editing, automatic version history, and integration with other Google services.
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