How To Use Google Sheets (Beginner's Guide)

Dean Stokes - Tech Tutorials · Beginner ·📊 Data Analytics & Business Intelligence ·1y ago

About this lesson

I'll walk you through creating your first spreadsheet, how to use the table feature, formatting your data and writing your first formulas. Perfect if you're new to spreadsheets or want to try out Google Sheets. Make a copy of my example spreadsheet here: https://go.deanjstokes.com/sheetsbeginner Subscribe to my newsletter (for free) to get a weekly Google Workspace tip: https://www.workspaceboost.com 📷 Check out my full office kit list on Amazon: https://www.amazon.co.uk/shop/deanstokes/list/1KNQ5KKX44PX2 📹 I use Camtasia to record and edit my how-to videos: https://go.deanjstokes.com/camtasia 📺 Consider supporting me by becoming a channel member: https://www.youtube.com/channel/UCX-znXB00avwiMyXU9GRlWA/join 00:00 Why use a spreadsheet? 00:19 How to create a spreadsheet 00:25 Elements of a spreadsheet 00:57 How to add a column header 1:47 How to make your data a table 2:23 How to format your spreadsheet 3:16 How to add and resize columns, rows and cells 5:08 How to write a basic formula 6:59 How to copy formulas to whole columns 7:26 How to use the SUM function 10:08 How to filter your data 11:01 How to share a Google Sheet 11:41 Project tracking spreadsheet example 11:56 How to add checkboxes 12:42 Budget tracking spreadsheet example 12:47 Where to get more tips Some of the links above are affiliate links, where I may earn a small commission if you click through and purchase.

Original Description

I'll walk you through creating your first spreadsheet, how to use the table feature, formatting your data and writing your first formulas. Perfect if you're new to spreadsheets or want to try out Google Sheets. Make a copy of my example spreadsheet here: https://go.deanjstokes.com/sheetsbeginner Subscribe to my newsletter (for free) to get a weekly Google Workspace tip: https://www.workspaceboost.com 📷 Check out my full office kit list on Amazon: https://www.amazon.co.uk/shop/deanstokes/list/1KNQ5KKX44PX2 📹 I use Camtasia to record and edit my how-to videos: https://go.deanjstokes.com/camtasia 📺 Consider supporting me by becoming a channel member: https://www.youtube.com/channel/UCX-znXB00avwiMyXU9GRlWA/join 00:00 Why use a spreadsheet? 00:19 How to create a spreadsheet 00:25 Elements of a spreadsheet 00:57 How to add a column header 1:47 How to make your data a table 2:23 How to format your spreadsheet 3:16 How to add and resize columns, rows and cells 5:08 How to write a basic formula 6:59 How to copy formulas to whole columns 7:26 How to use the SUM function 10:08 How to filter your data 11:01 How to share a Google Sheet 11:41 Project tracking spreadsheet example 11:56 How to add checkboxes 12:42 Budget tracking spreadsheet example 12:47 Where to get more tips Some of the links above are affiliate links, where I may earn a small commission if you click through and purchase.

Watch on YouTube ↗ (saves to browser)

Sign in to unlock AI tutor explanation · ⚡30

Related Reads

Tracking Macroeconomic Indicators with the Finance Toolkit

Learn to track macroeconomic indicators using the Finance Toolkit and understand its importance in global economic trends

Dev.to · Jeroen Bouma

Pydantic for Data Engineering: Schema Validation in ETL & Pipeline Contracts

Use Pydantic for schema validation in ETL pipelines to ensure data consistency and quality

Dev.to · Gowtham Potureddi

Half of Data Engineering Jobs on LinkedIn Aren't Real

Understand the discrepancy between reported data engineering job growth and actual job availability on LinkedIn

Dev.to · DataDriven

Evolutionary Data Through Schemaboi: Achieving Forward, Backwards, and Sideways Compatibility

Learn how Schemaboi achieves forward, backwards, and sideways compatibility for evolutionary data through self-contained schemas in file headers

Chapters (16)

Why use a spreadsheet?

0:19 How to create a spreadsheet

0:25 Elements of a spreadsheet

0:57 How to add a column header

1:47 How to make your data a table

2:23 How to format your spreadsheet

3:16 How to add and resize columns, rows and cells

5:08 How to write a basic formula

6:59 How to copy formulas to whole columns

7:26 How to use the SUM function

10:08 How to filter your data

11:01 How to share a Google Sheet

11:41 Project tracking spreadsheet example

11:56 How to add checkboxes

12:42 Budget tracking spreadsheet example

12:47 Where to get more tips

6-Phase SQL Roadmap 2026 | Data Analytics & Engineering | #shorts