Google Sheets Formulas Tutorial

Поделиться
HTML-код
  • Опубликовано: 5 окт 2024

Комментарии • 202

  • @KevinStratvert
    @KevinStratvert  Год назад +19

    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

    • @thesempire
      @thesempire Год назад +1

      I love you Kevin. You are the best ❤

    • @sweetmask1690
      @sweetmask1690 6 месяцев назад

      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
    @gina86 2 года назад +41

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

  • @wildgingerliving
    @wildgingerliving 2 года назад +6

    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!)

  • @GeorgeAlexa
    @GeorgeAlexa 3 года назад +4

    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
      @rumham8124 3 месяца назад

      How did the paramotoring go?

  • @oyino6879
    @oyino6879 3 года назад +45

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

  • @TylerStanczak
    @TylerStanczak 3 года назад +16

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

    • @gracemark5995
      @gracemark5995 3 года назад

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

  • @websterchurch2816
    @websterchurch2816 2 года назад +1

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

  • @jhyjai7702
    @jhyjai7702 3 года назад +1

    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.👍 .

  • @kuropixeljp
    @kuropixeljp 3 года назад +2

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

  • @psl907
    @psl907 Месяц назад

    This has made me realize sheets is essential for my business thanks

  • @jasonluong3862
    @jasonluong3862 3 года назад +6

    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.

  • @PlanetNinetyTwo
    @PlanetNinetyTwo Год назад

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

  • @snowboardslider24
    @snowboardslider24 3 месяца назад +1

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

  • @FabianSanchez-d1z
    @FabianSanchez-d1z 11 месяцев назад

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

  • @gypsysoleil
    @gypsysoleil 2 года назад

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

  • @antonlindberg7117
    @antonlindberg7117 Год назад +1

    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.

  • @iamazalea9888
    @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!!

  • @NorwinaAngeles
    @NorwinaAngeles Год назад

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

  • @maganvalenzuela829
    @maganvalenzuela829 4 месяца назад

    Fast and Straightforward. Thank you! Love it!

  • @kaela420
    @kaela420 Месяц назад

    i've learnt so many new and helpful things from this video - thank you!!

  • @TheFathersHouse2023
    @TheFathersHouse2023 Год назад

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

  • @NajsCorner1318
    @NajsCorner1318 2 года назад

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

  • @daimyoshugo2821
    @daimyoshugo2821 3 года назад

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

  • @diamondxp
    @diamondxp 2 года назад

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

  • @Jo-xu2vi
    @Jo-xu2vi 2 года назад +3

    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!

  • @Nomaddin
    @Nomaddin Год назад

    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.

  • @nextstopmagic
    @nextstopmagic 4 месяца назад

    Exactly what I needed. Easily explained. Thank you

  • @BerniePascual
    @BerniePascual Год назад

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

  • @fredrickotienoawino5044
    @fredrickotienoawino5044 Год назад

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

  • @NgwiSabius-show
    @NgwiSabius-show Год назад

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

  • @mentorforlife1881
    @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

  • @easynetoffice4104
    @easynetoffice4104 5 месяцев назад

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

  • @dr.yahyaelewa1628
    @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

  • @jawwadkhan3604
    @jawwadkhan3604 3 года назад

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

  • @Olayinkahakeemishola
    @Olayinkahakeemishola 2 года назад +1

    Sir. You are a good teacher. Thanks.

  • @jrcgjhughes
    @jrcgjhughes 2 года назад

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

  • @barbiedollsdress24
    @barbiedollsdress24 3 года назад +1

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

  • @danny355
    @danny355 2 года назад

    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 :)

  • @audreythomas178
    @audreythomas178 2 года назад +2

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

  • @2136thenatureboy1
    @2136thenatureboy1 Год назад

    Always enjoy watching your educational videos, always helpful!

  • @snsgte559
    @snsgte559 2 года назад

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

  • @venomsquad1231
    @venomsquad1231 3 года назад +1

    it was really good i understood very fast thankyou verymuch

  • @PeroSK_07
    @PeroSK_07 2 года назад

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

  • @fatimasara2546
    @fatimasara2546 2 года назад +1

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

  • @zelclutario
    @zelclutario 6 месяцев назад

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

  • @gajabathiarjuntg2390
    @gajabathiarjuntg2390 3 года назад +1

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

  • @maximilianosalibe1710
    @maximilianosalibe1710 3 года назад

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

  • @gradientO
    @gradientO 2 года назад +1

    A fan of your intro!

  • @rmariestennett7565
    @rmariestennett7565 2 года назад

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

  • @babatundealaka7044
    @babatundealaka7044 5 месяцев назад

    You are a Great teacher 👍

  • @katherinehumphries9545
    @katherinehumphries9545 Год назад

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

  • @catherineboccongelle7224
    @catherineboccongelle7224 3 года назад +6

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

  • @russel4742
    @russel4742 3 года назад

    Thankkkkkkk you video helps me a lot with my homework

  • @mr.serenity7203
    @mr.serenity7203 Год назад

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

  • @RudolphDocCampos
    @RudolphDocCampos 11 месяцев назад

    Thanks for the great tutorial. Subscribed and liked.

  • @jean-francoisregnard4889
    @jean-francoisregnard4889 Год назад

    This is an excellent tutorial. Thanks, Kevin !

  • @leonieamba
    @leonieamba 2 года назад

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

  • @gingerginger3413
    @gingerginger3413 3 года назад

    You're the best Teacher. Thank you.

  • @ankitayadav7683
    @ankitayadav7683 2 года назад

    Thank you for the excel sheet kevin

  • @casmilmurengezi3603
    @casmilmurengezi3603 Год назад

    thank you! it was so helpful Kevin

  • @thowheedh
    @thowheedh 3 года назад +3

    I am looking forward to a Microsoft Sharepoint Tutorial Please

    • @KevinStratvert
      @KevinStratvert  3 года назад

      Here you go: ruclips.net/video/5nrxp7lc0so/видео.html 😄

  • @dammyowode
    @dammyowode 3 года назад

    Thanks for this tutorial. Found it really helpful 😃.

  • @catalinarodriguez7845
    @catalinarodriguez7845 5 месяцев назад

    I liked your tutorial a lot. Thanks,

  • @lesliemiller6826
    @lesliemiller6826 3 года назад

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

  • @sherribuzzyanderson7598
    @sherribuzzyanderson7598 9 месяцев назад

    Such a good presentation. What about the percentage? How do you make the column calculate the equation?

  • @MJBorlado
    @MJBorlado 3 года назад

    This is helpful.Thanks Kev

  • @elmerhernandez4566
    @elmerhernandez4566 3 года назад

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

  • @alegrefeliz7579
    @alegrefeliz7579 2 года назад

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

  • @carolyncallahan
    @carolyncallahan Год назад

    Great video, thanks Kevin!

  • @randyblack9479
    @randyblack9479 2 года назад +1

    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?

  • @bandibhanuprasad2
    @bandibhanuprasad2 3 года назад

    Thank you Kevin for your Gsheet formulas

  • @rerite2
    @rerite2 3 года назад +1

    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?

  • @godefroidniyonkuru4377
    @godefroidniyonkuru4377 2 года назад

    I really adore you Kevin for real

  • @jamesanthonytheiler8885
    @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?

  • @abhinavsubramaniam5137
    @abhinavsubramaniam5137 3 года назад +2

    Now i Have become an excel wizard because of Kevin.
    * Is Kevin cookie company real or it is a fictional company?😂

  • @polokahmedtushar5860
    @polokahmedtushar5860 2 года назад

    marvelous tutorial

  • @RPSUChronicles
    @RPSUChronicles 3 года назад

    Most useful video ever! Thanks a lot!

  • @sunilscorpy4594
    @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! 👍❤😊

  • @Gwrod.s
    @Gwrod.s 2 года назад

    Simple and informative.

  • @AlessandroCardano
    @AlessandroCardano 3 года назад

    Thanks, very helpful for a noobie like me!

  • @robira1313
    @robira1313 3 года назад

    You have an abundance of knowledge with google sheets!
    Is there a way to show your total profit yesterday compared to total profit today? (gain/loss for the day) ie...If the sum of profits column was 100,000 yesterday but today the sum of profits only equals 98000 how can I make a cell show a negative 2000 change since yesterday? Thanks.

  • @virginiamagbitang6833
    @virginiamagbitang6833 2 года назад

    This is great. thank you Kevin.

  • @phamuyen4904
    @phamuyen4904 2 года назад

    So clear and so good! Thanks a lot !

  • @johnvincentbello3276
    @johnvincentbello3276 3 года назад

    Thank you sir! Helped a lot!

  • @MYINDIANTECHIE
    @MYINDIANTECHIE 3 года назад

    AMAZING VID BROTHER>>>>>> SIMPLE AND EASIEST

  • @salemastery
    @salemastery 3 года назад

    very helpful Kevin. Thanks very much!

  • @shelleyharris971
    @shelleyharris971 2 года назад

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

  • @scooby1683
    @scooby1683 3 года назад

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

  • @jeffreyscottfishman
    @jeffreyscottfishman 3 года назад +1

    Can you do basically the same stuff with google sheets as excel? Is one better than the other?

  • @matthewybarra3303
    @matthewybarra3303 2 года назад

    Thank you Kevin!!

  • @TylerMichalek-g8j
    @TylerMichalek-g8j Год назад

    Nice tutorial

  • @jegerald09
    @jegerald09 2 года назад

    THANK YOU SO MUCH

  • @k-ray6989
    @k-ray6989 Год назад

    hey i have a serious and important question about a project I'm working on... long story short , I have a checklist of materials that have at least 3 separate columns of different information.. what i need is to be able to move any checked items too a different area or a new page entirely.. so basically if something is checked off i need that item along with the 3 columns of info it comes with, to be projected somewhere else in a "owned" category

  • @brandonhernandez5207
    @brandonhernandez5207 Год назад

    Love it, thank you

  • @wfranco37
    @wfranco37 2 года назад

    Kevin Hi , love your videos. Do you recommend working with 365 business or google workshop? for a small business??

  • @gripWIN
    @gripWIN 3 года назад

    Helpful, well explained video. I have been s'rchng for a Function to sum a list of '[Body] WEIGHT'. Can you help? Thanks!

  • @khemrajsinghpalwal
    @khemrajsinghpalwal 3 года назад

    Very helpful...Thank you.

  • @monroeranderson
    @monroeranderson 2 года назад

    This was great!

  • @devashishv7015
    @devashishv7015 6 месяцев назад

    Thankyou so much❤

  • @ইশতিয়াক-খ৩হ
    @ইশতিয়াক-খ৩হ 3 года назад

    It was very helpful.