Google Sheets Tutorial for Beginners - 2022 Edition

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!

Grab it

Dive into a comprehensive 21-minute tutorial on Google Sheets, designed for beginners and updated for 2022. Learn to create spreadsheets, import data, understand basic structure, freeze headers, format cells, sort values, apply conditional formatting, perform calculations, use functions, filter data, validate entries, and visualize information. Master essential skills for efficient spreadsheet management, from basic operations to advanced features like data visualization and collaboration. Download the provided example file to practice alongside the instructor and gain hands-on experience with Google Sheets' powerful tools and functionalities.

Syllabus

○ Introduction
○ How to create a new spreadsheet in Google Sheets
○ How to import data into a spreadsheet in Google Sheets
○ Understanding columns and rows in Google Sheets
○ How to freeze the header row in Google Sheets
○ Text wrapping in Google Sheets spreadsheet cells
○ Formatting values and text in Google Sheets cells
○ Sorting values in a Google Sheets spreadsheet
○ How to use conditional formatting in Google Sheets
○ Calculating new values in Google Sheets
○ Inserting extra columns in a spreadsheet
○ Using functions in Google Sheets
○ How to use filters in Google Sheets
○ Validating data in Google Sheets
○ Visualizing data in your Google Sheets spreadsheet
○ Sharing and collaborating in Google Sheets
○ Conclusion