Google Sheets Formulas Tutorial

Рет қаралды 363,294

Күн бұрын

Learn how to use formulas and functions in Google Sheets.
👋 Additional resources:
- Access the spreadsheet I used if you'd like to follow along: docs.google.com/spreadsheets/...
- Read about all functions available in Google Sheets: support.google.com/docs/table...
⌚ Timestamps
0:00 Introduction
0:33 Add & formula basics
2:08 Subtract
2:48 Multiply
3:50 Divide
4:37 Bring it all together
5:44 Min
6:16 Max
6:38 Mean
7:23 Median
7:52 Mode
8:24 Sum
9:37 Sumif
11:09 Count
12:01 Counta
12:33 Countif
13:26 Concatenate
14:41 If
16:41 Vlookup
19:29 Convert
20:50 Today & Now
21:30 Len / character length
22:25 Wrap up
📃 Watch related playlists and videos
- Google: • How to use Google Prod...
🚩 Connect with me on social:
- LinkedIn: / kevinstratvert
- Twitter: / kevstrat
- Facebook: / kevin-stratvert-101912...
🔔 Subscribe to my KZfaq channel
kzfaq.info?...
🎬 Want to watch again? Navigate back to my KZfaq channel quickly
www.kevinstratvert.com
🛍 Support me with your Amazon purchases: amzn.to/3kCP2yz
⚖ As full disclosure, I use affiliate links above. Purchasing through these links gives me a small commission to support videos on this channel -- the price to you is the same.

Пікірлер: 197

@KevinStratvert Жыл бұрын

Continue learning Google Sheets with FREE Official Training offered by Google: ✅ Google Sheets Getting Started course: bit.ly/3UwekAu ✅ Google Sheets Advanced Topics course: bit.ly/3tpxDj2 ✅ Google Sheets Functions, Formulas, and Charts course: bit.ly/3UNI9vV

@natsempire Жыл бұрын

I love you Kevin. You are the best ❤

@sweetmask1690 2 ай бұрын

Hi sir can we put formula in sheet title? From cell to sheet title in order to edit easily the names of a plenty sheet at a time

@gina86 2 жыл бұрын

I came here after being lost in a course I took. Some people are just born teachers. Thank you!

@gyankigudri 10 ай бұрын

Me too 😂

@oyino6879 3 жыл бұрын

This was really good! Presented very well and easy to go through. Well done, thanks for making

@chasingwildginger2157 2 жыл бұрын

You are one of the best Microsoft and Google instructors on the whole internet. Whenever I need crisp, clear instructions, I see if you have done something on it first. Much better than a guy clicking around very quickly on the screen with no explanation and polka music in the background.(No joke, just experienced that!)

@kuropixel6871 3 жыл бұрын

I appreciate that you cover both Microsoft and Google options on your channel. Love your content, thank you.

@audreythomas178 2 жыл бұрын

Kudos to you Kevin! You never disappoint in your tutorials.

@Jo-xu2vi 2 жыл бұрын

Hi Mr. Kevin Stratvert! I love your tutorial videos. You are a good teacher, you explained every detail clearly. I wish you will make query tutorial for google sheet too. Thank you for all your effort!

@barbiedollsdress24 2 жыл бұрын

So direct to the point, easy to follow. Thanks a lot and I've subscribed.🙏🥰

@TylerStanczak 3 жыл бұрын

Never heard of the counta formula before this is super helpful :)

@gracemark5995 3 жыл бұрын

it's often the very helpful video . dear friend 👍👍

@websterchurch2816 Жыл бұрын

I don't ever leave comments, but this video was sooooo good! Informative, helpful, direct - thank you!!!!

@diamondxp Жыл бұрын

This helped me with a project. Well presented and straight to the point. I saved it for future reference. Kudos!

@PlanetNinetyTwo 9 ай бұрын

Thanks for this. I'm working towards becoming a data analyst and this has been most useful. You have my support, I'm subscribed.

@antonlindberg7117 Жыл бұрын

Hi Kevin! Thanks for providing this video, I had started a budgeting project in excel that's associated with google forms. I realise chapter 11, =SUMIF was exactly the missing piece. Thanks once again.

@maximilianosalibe1710 3 жыл бұрын

Very useful and quite clear examples! Thank you, Kevin! Regards from Argentina.

@gypsysoleil 2 жыл бұрын

Soooo happy i was refreshed on this and learned google sheets-loved it, so helpful!

@jhyjai7702 3 жыл бұрын

Since I have no job right so i have decided to learn form formulas in Excel and I came to your tutorials and I am reviewing what I have in my brainy 😂 by watching your tutorials. Thank you for uploading.👍 .

@PeroSK_07 2 жыл бұрын

It was so much beautifully explained, I understood everything. Thanks Kevin!!!

@GeorgeAlexa 3 жыл бұрын

I always wanted to learn Excel (Sheets) and even this ole man (I will be 77 this June 2021), I was thrilled that I could do what you presented here. I will watch two or three more tutorials on Google Sheets and then cross it off my bucket list of things to learn. The next item that I will try? Paramotoring.

@rumham8124 21 күн бұрын

How did the paramotoring go?

@lesliemiller6826 3 жыл бұрын

Awesome!!! I learned something new! You’re a great instructor!

@user-jz6ue5uh1i 8 ай бұрын

Awesome introduction to G-Sheets Formulas. Well spoken english in a way to understand everything clearly. Thanks!

@2136thenatureboy1 Жыл бұрын

Always enjoy watching your educational videos, always helpful!

@NorwinaAngeles Жыл бұрын

Me and my husband learned a lot from this video! Thanks and keep up the good work.

@fatimasara2546 2 жыл бұрын

A life-saving video. Thank you so much!👌✨

@catherineboccongelle7224 3 жыл бұрын

Hi Kevin. I really enjoy your tutorials. Is it possible to protect/unprotect specific cells in sheets as it is in excel? Thank you.

@iamazalea9888 3 жыл бұрын

I'm just looking for basic formula as im just a beginner with using gsheets and we are going to use it in my midterm exam but damn i've learned a lot of things that i can use in our research paper. Thank u so much for this!! It's very helpful!!

@maganvalenzuela829 25 күн бұрын

Fast and Straightforward. Thank you! Love it!

@daimyoshugo2821 3 жыл бұрын

Thanks you. Learning how to use this for scoring baseball sheets and maybe a local sports grp

@snowboardslider24 3 күн бұрын

It still doesn't compute, but this is use error. The way you explain everything is amazing!

@BerniePascual Жыл бұрын

I really enjoyed this video and how this is presented to the viewers. Thank you so much!

@phamuyen4904 2 жыл бұрын

So clear and so good! Thanks a lot !

@fredrickotienoawino5044 Жыл бұрын

very insightful and hands on google sheet skills there. Thanks for giving this out to us

@gingerginger3413 3 жыл бұрын

You're the best Teacher. Thank you.

@katherinehumphries9545 Жыл бұрын

Kevin, so well explained! Great videos. Thank you.

@elmerhernandez4566 2 жыл бұрын

Thank you so much for this video Kevin! Very helpful!

@leonieamba Жыл бұрын

Thanks for creating this video, Kevin. Very helpful.❤

@nextstopmagic Ай бұрын

Exactly what I needed. Easily explained. Thank you

@NajsCorner1318 2 жыл бұрын

Very helpful for a not-so-gsheet user" like me 🙂 Now i will be more confident with sheets thank you!

@jawwadkhan3604 3 жыл бұрын

thank you for teaching us in google sheet formulas and your tutorial is very helpful

@RPSUChronicles 3 жыл бұрын

Most useful video ever! Thanks a lot!

@mentorforlife1881 3 жыл бұрын

Nice explanations you did not waste our Time like other you tuber they don't focus on their content they keep saying or advertising in their video but you didn't do that therefore I liked, subscribed and shared with my few friends I hope you will keep making videos like this lots of love ❤️from india

@sunilscorpy4594 3 жыл бұрын

Super cool tutorial video! Thanks so much Kevin. I can get much more work done quicker now. Can you make more videos on other Google apps too? Thanks so much! 👍❤😊

@jean-francoisregnard4889 Жыл бұрын

This is an excellent tutorial. Thanks, Kevin !

@johnvincentbello3276 3 жыл бұрын

Thank you sir! Helped a lot!

@damilolaslife 2 жыл бұрын

Thanks for this tutorial. Found it really helpful 😃.

@jasonluong3862 3 жыл бұрын

Thank you for giving Google Docs some love. This might be a tall request. Can you do a side by side comparison when doing these formulas between Google Sheet and Excel? This way, we can see how each of them does the calculations.

@zelclutario4430 3 ай бұрын

Thank you so much!!! ❤🎉 I LEARN SO MUCH FROM THIS

@snsgte559 Жыл бұрын

Thanks Bro, This was really a quick and important learning.

@gajabathiarjuntg2390 3 жыл бұрын

Thank you Kevin. This is what I expect.👌👌👌

@salemastery 3 жыл бұрын

very helpful Kevin. Thanks very much!

@adwaithdin Жыл бұрын

Thanks for the video man. Really helped me a lot. Actually I heard that the google sheet has too many options and now I learned everything you said. Thank you. 🤝 Your tutorial is really amazing.

@TheFathersHouse2023 8 ай бұрын

Wish I could watch every video all at once...lol thanks you're going to teach me a lot

@easynetoffice4104 2 ай бұрын

I loved it how simple way u explained it......plz keep uploading

@Olayinkahakeemishola 2 жыл бұрын

Sir. You are a good teacher. Thanks.

@casmilmurengezi3603 Жыл бұрын

thank you! it was so helpful Kevin

@venomsquad1231 2 жыл бұрын

it was really good i understood very fast thankyou verymuch

@MJBorlado 2 жыл бұрын

This is helpful.Thanks Kev

@scooby1683 3 жыл бұрын

👍👍 The way you explain...🤘Amazing 🤘

@jrcgjhughes 2 жыл бұрын

Love all your Tutorials. I learn so much. My questions is can you import google docs into OneNote?

@bandibhanuprasad2 2 жыл бұрын

Thank you Kevin for your Gsheet formulas

@RudolphDocCampos 8 ай бұрын

Thanks for the great tutorial. Subscribed and liked.

@carolyncallahan 11 ай бұрын

Great video, thanks Kevin!

@mr.serenity7203 Жыл бұрын

Hi hi holy moly this was concise and educational ! Muchos thanks !!

@rmariestennett7565 2 жыл бұрын

I enjoyed your class, thank you. I would like to see the Absolute formula.

@thowheedh 3 жыл бұрын

I am looking forward to a Microsoft Sharepoint Tutorial Please

@KevinStratvert 3 жыл бұрын

Here you go: kzfaq.info/get/bejne/a9Siq9No0cmUo6M.html 😄

@brandonhernandez5207 Жыл бұрын

Love it, thank you

@danny355 Жыл бұрын

Thanks for this video, reminded me of all the stuff I learnt at school in 1995 and then immediately forgot! "vlookup" is going to take some serious practise though, that section might as well have been in Greek. Top Cookie Monster reference :)

@catalinarodriguez7845 2 ай бұрын

I liked your tutorial a lot. Thanks,

@virginiamagbitang6833 2 жыл бұрын

This is great. thank you Kevin.

@khemrajsinghpalwal 2 жыл бұрын

Very helpful...Thank you.

@maruthirahulmssv2678 3 жыл бұрын

prefect content my man!

@babatundealaka7044 2 ай бұрын

You are a Great teacher 👍

@alegrefeliz7579 2 жыл бұрын

Kevin, it was easy to follow your explanation. 👍sub.

@polokahmedtushar5860 2 жыл бұрын

marvelous tutorial

@gradientO 2 жыл бұрын

A fan of your intro!

@russel4742 2 жыл бұрын

Thankkkkkkk you video helps me a lot with my homework

@ankitayadav7683 Жыл бұрын

Thank you for the excel sheet kevin

@johnpauladlawan9753 3 жыл бұрын

Thank you, sir!

@monroeranderson 2 жыл бұрын

This was great!

@Gwrod.s Жыл бұрын

Simple and informative.

@matthewybarra3303 Жыл бұрын

Thank you Kevin!!

@jegerald09 2 жыл бұрын

THANK YOU SO MUCH

@user-uv9xd3gp1l 3 жыл бұрын

It was very helpful.

@wolfhaize Жыл бұрын

Very useful!

@rener351 Жыл бұрын

Thank you Kevin!

@markcole6460 Жыл бұрын

Very well done

@devashishv7015 2 ай бұрын

Thankyou so much❤

@user-gf5ln3ym8v Жыл бұрын

Nice tutorial

@sunnydva 3 жыл бұрын

thank you very much!

@danielbadger2641 3 жыл бұрын

Dude you rock.

@dr.yahyaelewa1628 2 жыл бұрын

Stand up for the teacher and pay him veneration, the teacher is almost a messenger. If its in my hands, I'd definitely 👍honor you an OSCAR. Thank you so much 💓. HATS LIFT UP🎩 Sir

@teddyw.charawa8989 Жыл бұрын

You are awesome. Heaven honor you!!

@randyblack9479 2 жыл бұрын

Kevin, Thank you for this video, This is a big help, but I need a formula for calculating cost of rebar based on the size of the rebar but I am not sure how to write it. Right now I have a simple formula that calculates finds the tonnage of rebar based on the linear footage multiplied by the weight of the bar per linear foot. Ex. #5 rebar weights 1.043lbs per lft., #4 is .668lbs per lft, etc. but to use this I have to change the formula every time based on the size of rebar itself. Is there a formula that can help me out here?

@flawlessmyles Жыл бұрын

thanks for the video. I am software developer and I heard a word concatenate[combining two variables] and turn into new one!

@jamesanthonytheiler8885 3 жыл бұрын

Hi Kevin, I enjoy your video they are great and I have learned a lot from them. Several of the people that I follow and use their video have Patreon Campaigns to get exclusive content/video but have you started this as well?

@shelleyharris971 2 жыл бұрын

Hi Kevin, Great Tutorial! Do you have a video that shows how you link the Documents?

@parvathi8634 2 жыл бұрын

thanks for the video

@godefroidniyonkuru4377 2 жыл бұрын

I really adore you Kevin for real

@rerite2 3 жыл бұрын

Is there a formula that picks out a certain before or after date from a sheet? For instance, if I need to know which cookies were baked within the last 3 months or later, and the bake date is in the sheet, can Sheets pull out the data, and highlight cells to differentiate them?