YoVDO

Google Sheets Tutorial for Beginners 2024 - Step-by-Step

Offered By: Loves Data via YouTube

Tags

Google Sheets Courses Data Analysis Courses Data Visualization Courses Spreadsheets Courses Data Validation Courses

Course Description

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!
Learn the fundamentals of Google Sheets in this comprehensive beginner's tutorial. Create your first spreadsheet, import data, understand basic structure, and master essential features like freezing rows, text wrapping, and cell formatting. Explore data manipulation techniques including sorting, conditional formatting, and calculations. Discover how to use functions, apply filters, validate data, and create visualizations. Gain insights into collaboration tools and prepare for advanced topics. Follow along with practical examples and step-by-step instructions to build a strong foundation in spreadsheet management using Google Sheets.

Syllabus

Introduction to Google Sheets
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
Next steps


Taught by

Loves Data

Related Courses

Rails with Active Record and Action Pack
Johns Hopkins University via Coursera
Excel Skills for Business: Intermediate II
Macquarie University via Coursera
Programming 103: Saving and Structuring Data
Raspberry Pi Foundation via FutureLearn
Everyday Excel, Part 1
University of Colorado Boulder via Coursera
Creating Dashboards in Google Spreadsheets
Coursera Project Network via Coursera