YoVDO

Google Sheets Tutorial for Beginners - 2022 Edition

Offered By: Loves Data via YouTube

Tags

Google Sheets Courses Data Visualization Courses Data Sorting Courses Data Filtering Courses Spreadsheets Courses

Course Description

Overview

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


Taught by

Loves Data

Related Courses

Introduction to Databases
Meta via Coursera
Analyzing Big Data with SQL
Cloudera via Coursera
Managing Google Workspace 日本語版
Google Cloud via Coursera
Creating Advanced Reports with SAS Visual Analytics
SAS via Coursera
Query Client Data with LibreOffice Base
Coursera Project Network via Coursera