Google Sheets for Beginners

About this course

A step-by-step introduction to Google Sheets: entering data, formulas, references, sorting, functions and sharing spreadsheets with others. Who it's for: students and office workers who use spreadsheets. These are the free, official videos of the "Google Sheets for Beginners" playlist from the Learn Google Sheets & Excel Spreadsheets YouTube channel (youtube.com/@excelgooglesheets). All videos belong to Learn Google Sheets & Excel Spreadsheets; Sikhami is not affiliated with Learn Google Sheets & Excel Spreadsheets and simply arranges the public playlist into a course, so you can learn one lesson at a time and keep track of your progress.

What you will learn

• The basics of Google Sheets • Formulas, percentages and locking cells in formulas • Locking rows, columns and ranges • Cell references and referring to other sheets • Sorting by numbers, dates and multiple columns • Functions, joining text and splitting text into columns • Sharing and working on sheets with other people

Course content

1 section · 10 lectures · 3h 10m

1. 1. Google Sheets for Beginners

   • Google Sheets - Tutorial for Beginners - Part 130m
   • Google Sheets - Formulas Tutorial - Part 216m
   • Google Sheets - Lock Cells in Formula, Percentage & More - Part 321m
   • Google Sheets - Lock Rows, Lock Columns, Lock Ranges, So Much Locking! - Part 415m
   • Google Sheets - Cell References, Reference Another Sheet - Part 524m
   • Google Sheets - Sort - by Number, Date, Multiple Columns - Part 615m
   • Google Sheets - Functions Tutorial - Part 721m
   • Google Sheets - Ampersand (&), Join Text (CONCATENATE), Text to Columns, LEFT function - Part 88m
   • Google Sheets - Linking Data Between Sheets (Workbooks, Files) & Other Worksheets (Tabs)15m
   • Google Sheets Tutorial - Share & Work on Spreadsheets with other Users in Google Workspace20m