Technology for Teachers and Students

Technology for Teachers and Students

1,930,000 subscribers

⏱ 👁 223,619 views

Google Sheets for Beginners - The Complete Course

Video Overview & Insights

This is the beginning Google Sheets course that you've been waiting for! Learn everything you need to effectively use Google Sheets by watching just one video. You'll learn spreadsheet terminology and the Google Sheets layout, how to create workbooks, entering values into Sheets, formulas and functions, formatting, creating and editing charts, printing options, and publishing options. After watching and mastering this video, you will be able to use Google Sheets effectively in almost any professional setting.

“

Super helpful!🙏🏾💜

— @PhyB33

Table of Contents:

00:00 - Intro

“

Learnt a lot . Thank you

— @nwa2791

00:25 - Creating Workbooks, The Anatomy of a Spreadsheet / Spreadsheet Terminology

09:25 - Entering Cell Values and Data in Google Sheets

“

Thank you

— @MaryAsamo

24:26 - Formulas

32:10 - Functions: SUM, AVERAGE, MAX, MIN, COUNT

“

It's same as excel

— @ShambhuParshad-mh8wd

39:07 - Formatting Numbers, Text, Cells, Rows, and Columns

45:50 - Creating and Editing Charts

“

Thank you for this tutorial it was awesome.

— @elajeanlouisjolivairt

48:20 - Print Options and Publishing Options

Join this channel to get access to perks:

“

Thank you
I learnt a lot

— @ednaosademe

https://www.youtube.com/channel/UCYUPLUCkMiUgiyVuluCc7tQ/join

***Support Technology for Teachers and Students on Patreon***: https://www.patreon.com/technologyforteachersandstudents Here's my entire playlist of Google tutorials: https://bit.ly/thegoogleplaylist Please say "Thanks" by clicking the Thanks button below the video. #googlestudents #google #googletutorial #sheets #googledrive #googleworkspace #gsuite #googlesheets #googlesheetstips #googlesheetstutorial

“

Thank you, best toturial, clearly explained step by step.

— @Filea-i3h

More User Perspectives

@

Really well presented clear, engaging, and easy to follow from beginning to end

@ReallycomeTogether

@

The best! Packed info.Thank you

@annenevin1198

@

First off .. please can someone please explain Google sheets to me for a better understanding

@ConfidenceJoel-z6z

@

Excellent and google sheets what is the difference

@kalpavriksha666

@

Thank you great video

@Ayennnngggg

@

Thank you for this tutorial. 😍😍😍

@rhinasanpascual5490

@

Started learning today

@facegaming5978

@

Thank you for this valuable information! How can you create and share a template that a recipient can edit?

@denisegiddingsmargart475

@

Is there an intermediate level explanation of this? I really liked this explanation.

@elanurdmrrr

@

Thank you for the knowledge, I will continue watch your other videos :)

@Tiredhooman8

@

Good bless you for the training

@PatrickEdughaen-kz9yw

@

Bro is good 🔥

@nazp232

@

the problem is the 10 replaced all the employee numbers too

@BrentChung

@

Thank you!

@lmattanthony

@

(47:28) Why don't I have the "Create chart for this data" option in Google Sheets? I also noticed that Google Gemini isn't available in my Google Docs and Google Sheets. Can you help me fix this issue? Thank you.

@divinajanem

@

11:43 pm 06/16/26

Super grateful for this tutorial!

@SceneTalk-4u

@

It's amazing how powerful Google Sheets is till today in 2026, not only for personal but also business. Thank you for the great video.

@mobtereststudio

@

Thankk u soo much for this ❤ I've learned a lot of

@Vaniefy19

@

Thank you, that was very helpful 😊

@CallyLawson

@

Hi, how to solve for data lost in the sheets and I waste time to restore version and after restored this part, it will lose in another part. Do you have solution for this? Can you do video share on this issue?

@NewCo-y4l

@

Starting learning today May 28, 2026. Thank you for free tutorial Sir.

@DrumBeatFill

@

Thank you ... this tutorial is so invaluable to me.

@ChukwuemekaOzokwere

@

Thanks!

@deborahbaker9052

@

Best course so far on YouTube on Google sheet

@BriannaBucks

@

I learn within one hour now tomarrow i am gonna teach in tue school😅

@MuhammadusmanKhan-f7p9g

@

Absolutely remarkable

@4SevenSeas

@

This is incredible , what an amazing teacher ❤ thank you so much ❤ Please can you do intermediate level please ?

@ezioauditor87

@

When you changed all 10 values to 12 @22:36, it also altered all of the employee numbers that started with 10xx. Any solutions?

@neptudi

@

How do I add the names above the functions. For example, I only have the symbols to do things and really need the names above the functions. ThIA

@debibrock7340

@

Fantastically clear and easy to understand, thank you .

@thesonggardenproject1316

@

Will this help me in data entry jobs in the future?

@bikromshovo8542

@

Thank you for this video. New subscriber here👍

@alexshaie1313

@

This was helpful, thank you.

@nasahubofficial

@

soo good

@ketheestharsi9075

@

and how to copy ONE COLUM ? USE to be able to do it with google colum copy extension on google.

Some ASSHOLE Over there discontinued that extesnsion try to reinvent the wheel. It is like one step foward and 3 steps backwards. Is there an easy way to right click and copy ONE colum of info on a website data table ?

@alivstyson1864

@

The video was really good. I just noticed that around the 22 - 23 minute mark, when you did the "Find and replace" to change all the 11's to 12's, it also changed "Zoe's" employment number from "2011" to "2012", making her employment number incorrect. Not sure if there is way to stop it doing that or is that just what happens when you "Find and replace" all, it changes everything, even though the "11" was part of "2011" ?

@JoeTaylor-q8c

@

❤ it was Fun to learn from you

@Perpy-perpy

@

22:18 find and replace seemed to edit more than just the indented column (the 10** in the employee numbers rather than just their wages) is there a way to contain find and replace to one column/row/range? or would you have to input manually to avoid this issue

@valzangel

@

Thank you, I used to be a dedicated Excel user but switched to a Mac...not sure why I was so nervous about the switch. Your course has given me confidence that I can do this!

@loripeterson5403

@

I have to relearn this shit cause all the other videos are outdated. Just found out there’s no explore button.

@minotauro8154

@

thank you i need this for a remote work assessment hopefully i get the job. wish me luck

@TshegofatsoMole

@

I rarely finish videos in one sitting, but this one felt like a story and kept me hooked. Thank you!

@cutiedapatootie

@

Thanks. Very clear and succinct. Always worked in .xlsx. New job uses Google Sheets.

@tamikofung3310

#google sheets tutorial for beginners #google sheets tutorial #google sheet #google sheets formulas #how to use google drive #excel #spreadsheets #google spreadsheets #google sheets for beginners #sheets tutorial #google sheets basics #google drive #google sheet tutorial #google sheets #google sheets tips and tricks #what is google sheets #learn google sheets #how to use google sheets #advanced excel #google sheets full course #free google sheets tutorial