How to use Formulas and Functions in Google Sheets

How to use Formulas and Functions in Google Sheets

Teacher's Tech

3 года назад

77,605 Просмотров

Google Sheets formulas and functions for beginner's 2021 tutorial. I will show you how to use formulas and functions in Google Sheets. I will start with basic math formulas in Google Sheets and show you some of the very popular and powerful functions. Use the timestamps below to help you navigate through this video.

Here’s the link to the practice spreadsheet: https://docs.google.com/spreadsheets/d/195g9zTLzUyuHmx89vGGz0dD7pN10mCwV3_0nZMO11Ik/edit?usp=sharing

0:00 Intro
0:49 Basic math formulas
3:35 Starting with the SUM Function in Google Sheets
7:05 The COUNT function
8:50 AVERAGE, MEDIAN and MODE functions
10:32 MIN and MAX functions in Google Sheets
11:19 Functions and formulas with Date and time in Google Sheets
14:04 Using formulas to combine columns
15:44 If statements in Google Sheets
19:01 How to use VLOOKUP in Google Sheets
22:12 Conditional functions (SUMIF, SUMIFS, COUNTIF etc.)

Interested in how I make my videos? Here’s a tutorial: https://youtu.be/hNzulrauu4Y

Тэги:

#google_sheets #google_sheets_formulas #google_sheets_tutorial_for_beginners #google_sheets_tutorial #google_sheets_custom_function #google_sheets_functions #jamie_keet #teachers_tech #how_to_use_google_sheets #how_to_use_google_sheets_for_beginners #spreadsheet_formulas #google_sheets_vlookup #teachers_tech_google_sheets #google_spreadsheet #google_sheets_tutorial_2021
Ссылки и html тэги не поддерживаются


Комментарии:

@1rocknroy
@1rocknroy - 12.11.2023 05:58

Good teachers are such gifts. Thank You.

Ответить
@stephenbrown9400
@stephenbrown9400 - 30.10.2023 21:17

How can I develop a formula for a banking sheet which when a credit or debit is entered the balance reduces? Finding this tough

Ответить
@LowRotor
@LowRotor - 23.09.2023 08:43

This was great! I’m working on building a real estate investment calculator with zero sheets experience and this was very helpful. Wish I could chat with you for some more information but I’ll keep watching your videos!! Thanks for the tutorial

Ответить
@didargrewal1856
@didargrewal1856 - 16.09.2023 20:03

Best teacher❤

Ответить
@ReneeThompson-mo4qj
@ReneeThompson-mo4qj - 11.07.2023 12:23

Your are such a great google sheet instructor for these formulas, I would love ❤️ for you to show more formulas using on a couponing spreadsheets, budget sheets please.

Ответить
@anthonyjenkins5170
@anthonyjenkins5170 - 08.06.2023 11:53

Thanks

Ответить
@diyaghosh5104
@diyaghosh5104 - 05.06.2023 16:57

Thank you so much for providing the spreadsheet along with the video. enjoyed this one too.

Ответить
@kimaffleck7943
@kimaffleck7943 - 19.05.2023 18:37

Just a suggestion. You use "Go ahead" quite a lot. Changing it up or omitting it all together would be nice.

Ответить
@sharoncorrie4783
@sharoncorrie4783 - 03.05.2023 11:10

Hey there, i have a doubt regarding google sheets, its a lil hard to explain over text, can i get any other source of communication please?

Ответить
@teddyw.charawa8989
@teddyw.charawa8989 - 08.02.2023 16:44

You are a Billionaire in the making!!

Ответить
@vendeirenea1315
@vendeirenea1315 - 19.01.2023 10:49

I LITERALLY CRIED WHEN I TRIED THE LAST TUTORIAL AND I GOT IT!! 😭🤍🤍 THANK YOU SO MUCH

Ответить
@vendeirenea1315
@vendeirenea1315 - 19.01.2023 10:45

OMG THANK YOU SO MUCH!! 😭😭 THIS IS VV HELPFUL!

Ответить
@danalane2366
@danalane2366 - 03.01.2023 19:52

Thank you for this! I had totally forgotten how to do basic sum functions in spreadsheets (it’s been a long time since high school!), and I was struggling to set up my accounting sheets for my small business. You just laid it out perfectly. Now I can set up my sheets to keep track of inventory and costs more efficiently.

Ответить
@ahmedhasanin8445
@ahmedhasanin8445 - 07.12.2022 02:31

Great thanks to Your effort this lesson was really helpful

Ответить
@kenbahati
@kenbahati - 23.09.2022 19:00

Excellent teaching! Very practical. Thank you!

Ответить
@BeingMau
@BeingMau - 14.09.2022 05:48

One of the BEST!

Ответить
@jacksonjoseph3779
@jacksonjoseph3779 - 28.08.2022 03:39

Jackson joseph true step like Haïti

Ответить
@gina86
@gina86 - 19.08.2022 19:34

This is by far the best. You explained well how to follow the formula guide. Thank you! I will surely come back some time for a thank you tip.

Ответить
@bethls28
@bethls28 - 18.08.2022 20:19

Thank you

Ответить
@marwaghith9249
@marwaghith9249 - 14.08.2022 03:13

Your video is the best and most favorable video I've watched concerning formulas as it was step-by-step and easy to follow. Big thanks for your constructive content! it was so helpful.

Ответить
@bryantdesiabagat5871
@bryantdesiabagat5871 - 27.07.2022 17:49

Learn a lot

Ответить
@abdofeduconsult
@abdofeduconsult - 03.07.2022 13:09

Excellent Google sheet Instructor!. Keep doing well. Thanks for sharing your knowledge.

Ответить
@kirstentownley8916
@kirstentownley8916 - 19.06.2022 00:41

You are such a great teacher! Thank you!

Ответить
@chloew7904
@chloew7904 - 07.06.2022 15:40

…⋯二罰.。

Ответить
@alexmwaniki1069
@alexmwaniki1069 - 05.05.2022 19:56

Great lesson

Ответить
@sheila3353
@sheila3353 - 01.04.2022 15:42

Great video, however I don't have the suggestions coming up. How do I turn them on? than you

Ответить
@esgaldir7315
@esgaldir7315 - 31.03.2022 09:08

all your teacher vids are gold

Ответить
@gormangraphics
@gormangraphics - 12.03.2022 11:41

how about beginning balance and your depositing and subtracting or withdrawning to get current amount

Ответить
@doguitech3500
@doguitech3500 - 01.02.2022 02:00

thank you, it´s a really helpful video

Ответить
@victoriagarcia2318
@victoriagarcia2318 - 06.01.2022 20:37

thank you , you simplified the best what i am having trouble is how to saved the formulas so i don't have to be adding constantly, i am working in a time sheet so what to be able to add the time and sum every week logins and add totals . Thank you for your help

Ответить
@ilyaszaw7459
@ilyaszaw7459 - 17.10.2021 19:44

Thank you ,sir.

Ответить
@pamtaylor-harris1010
@pamtaylor-harris1010 - 06.09.2021 19:19

The best video I've seen on functions and formulas for Google Sheets. Your instructions are logical and easy to follow. Thanks for the worksheet example download and the showing the learn more tool.

Ответить
@natividaddelfin5930
@natividaddelfin5930 - 05.09.2021 09:30

Hi, I like how you explain the subject

Ответить
@lisbethfraze9059
@lisbethfraze9059 - 16.07.2021 15:17

You are an amazing teacher, 🙏🏽

Ответить
@tomeknaj
@tomeknaj - 23.06.2021 23:41

Nice video, pity you didn't finish the COUNTIF(S)

Ответить
@burhanuddin6371
@burhanuddin6371 - 15.05.2021 21:30

perfect video to learn about google sheet,

Ответить
@sohot19
@sohot19 - 13.05.2021 19:22

🙇

Ответить
@FantasyFinalFiend
@FantasyFinalFiend - 11.05.2021 08:18

Is there anyway to do a split and vlookup combined?

Ответить
@danielleneri7640
@danielleneri7640 - 10.05.2021 20:48

Random tech question, but what type of pop filter are you using during your videos?

Ответить
@emilharden9532
@emilharden9532 - 10.05.2021 16:10

Excellent overview of formulas - clearly explained, great examples.

Ответить
@rmorris910
@rmorris910 - 10.05.2021 00:11

How can you make this data auto populate to another sheets spreadsheet?
Is there a way to have a master student data list and have each students data auto populate to their own sheet?

Ответить
@sonyarobinson6287
@sonyarobinson6287 - 08.05.2021 23:39

Thanks for this

Ответить
@bhanupratapsingh4169
@bhanupratapsingh4169 - 08.05.2021 20:08

very useful video, thanks for posting.

Ответить
@techtimes1985
@techtimes1985 - 08.05.2021 18:09

Excellent video

Ответить
@collegeboytwo
@collegeboytwo - 08.05.2021 16:23

Wow! Awesome video!

Ответить
@girIs.
@girIs. - 08.05.2021 16:11

Amazing video, it really helps!!

Ответить
@aquaticrose8110
@aquaticrose8110 - 08.05.2021 16:11

First

Ответить