Overview
Learn the essentials of Google Sheets in this comprehensive 30-minute tutorial designed for beginners. Explore the layout, basic formatting techniques, and essential functions like UNIQUE, COUNT, and IF. Master row and column formatting, sorting data, and freezing rows. Discover how to create and manipulate charts, share your work, and protect sensitive information. Gain practical skills applicable to the Google Certified Educator Level 1 exam, from getting started to publishing your spreadsheet as a website.
Syllabus
Getting Started & Layout.
Basic Formatting in Google Sheets.
Formulas & Functions in Google Sheets.
Formatting Rows and Columns in Google Sheets.
Sorting and Using Freeze Rows in Google Sheets.
Unique Function.
Count Function.
IF Function in Google Sheets.
Inserting Charts in Google Sheets.
Copy and Paste Charts into Google Slides and Google Docs.
Sharing and Publishing as a website in Google Sheets.
Protect Sheets and Ranges in Google Sheets.
Taught by
Teacher's Tech