How to use Formulas and Functions in Google Sheets

Поділитися
Вставка
  • Опубліковано 10 вер 2024

КОМЕНТАРІ • 62

  • @danalane2366
    @danalane2366 Рік тому +3

    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.

  • @LowRotor
    @LowRotor 11 місяців тому +2

    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

  • @gina86
    @gina86 2 роки тому +2

    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.

  • @1rocknroy
    @1rocknroy 10 місяців тому +1

    Good teachers are such gifts. Thank You.

  • @marwaghith9249
    @marwaghith9249 2 роки тому +3

    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.

  • @pamtaylor-harris1010
    @pamtaylor-harris1010 3 роки тому +3

    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.

    • @gina86
      @gina86 2 роки тому +1

      That's true, I couldn't find someone explaining how to follow the formula guide. This is the best.

  • @emilharden9532
    @emilharden9532 3 роки тому +4

    Excellent overview of formulas - clearly explained, great examples.

  • @diyaghosh5104
    @diyaghosh5104 Рік тому

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

  • @ReneeThompson-mo4qj
    @ReneeThompson-mo4qj Рік тому

    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.

  • @kenbahati
    @kenbahati Рік тому +1

    Excellent teaching! Very practical. Thank you!

  • @myrebounderchannel4849
    @myrebounderchannel4849 День тому

    Spectacular. Superb. Stellar.

  • @kirstentownley8916
    @kirstentownley8916 2 роки тому +1

    You are such a great teacher! Thank you!

  • @lisbethfraze9059
    @lisbethfraze9059 3 роки тому +2

    You are an amazing teacher, 🙏🏽

  • @vendeirenea1315
    @vendeirenea1315 Рік тому +1

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

  • @burhanuddin6371
    @burhanuddin6371 3 роки тому +1

    perfect video to learn about google sheet,

  • @everestuscalliste-gi6549
    @everestuscalliste-gi6549 3 місяці тому

    Great help!

  • @teddyw.charawa8989
    @teddyw.charawa8989 Рік тому

    You are a Billionaire in the making!!

  • @esgaldir7315
    @esgaldir7315 2 роки тому

    all your teacher vids are gold

  • @abdofeduconsult
    @abdofeduconsult 2 роки тому

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

  • @T-wr1cl
    @T-wr1cl 2 місяці тому

    Hey Jamie, I’m new to google sheets and I’m an Apple user. I downloaded the Google Sheets app and I’m trying to scrub information from Google maps into Google sheets. For some reason my systems aren’t communicating or synced. Can you help me with direction

  • @didargrewal1856
    @didargrewal1856 Рік тому

    Best teacher❤

  • @solnav6579
    @solnav6579 Місяць тому

    Hello I've been watching your videos hoping to find how to add an option to CRITERIA WITHIN DATA VALIDATION IN DATA. Is that possible?
    I 'm using Google Sheets for Bookkeeping Purposes. Thank you in advance

  • @orainedittmar344
    @orainedittmar344 7 місяців тому

    Great way to learn. How do I total columns and not double add the subtotals in said column total?

  • @stephenbrown9400
    @stephenbrown9400 10 місяців тому

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

  • @anthonyjenkins5170
    @anthonyjenkins5170 Рік тому

    Thanks

  • @girIs.
    @girIs. 3 роки тому +2

    Amazing video, it really helps!!

  • @sharoncorrie4783
    @sharoncorrie4783 Рік тому

    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?

  • @BeingMau
    @BeingMau 2 роки тому

    One of the BEST!

  • @bhanupratapsingh4169
    @bhanupratapsingh4169 3 роки тому +1

    very useful video, thanks for posting.

  • @victoriagarcia2318
    @victoriagarcia2318 2 роки тому

    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

  • @alexmwaniki1069
    @alexmwaniki1069 2 роки тому

    Great lesson

  • @sonyarobinson6287
    @sonyarobinson6287 3 роки тому +1

    Thanks for this

  • @ilyaszaw7459
    @ilyaszaw7459 2 роки тому

    Thank you ,sir.

  • @natividaddelfin5930
    @natividaddelfin5930 3 роки тому

    Hi, I like how you explain the subject

  • @bethls28
    @bethls28 2 роки тому

    Thank you

  • @bryantdesiabagat5871
    @bryantdesiabagat5871 2 роки тому

    Learn a lot

  • @collegeboytwo
    @collegeboytwo 3 роки тому +1

    Wow! Awesome video!

  • @techtimes1985
    @techtimes1985 3 роки тому +1

    Excellent video

  • @kimaffleck7943
    @kimaffleck7943 Рік тому

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

  • @sheila3353
    @sheila3353 2 роки тому

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

  • @gormangraphics
    @gormangraphics 2 роки тому

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

  • @r0sie888
    @r0sie888 3 роки тому

    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?

  • @FantasyFinalFiend
    @FantasyFinalFiend 3 роки тому

    Is there anyway to do a split and vlookup combined?

  • @symcardnel1741
    @symcardnel1741 2 роки тому

    14:04 thru 15:43 ?? Should you at least come close to 'teaching' the task correctly or come even slightly close to matching the column headers??

  • @danielleneri7640
    @danielleneri7640 3 роки тому

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

    • @TeachersTech
      @TeachersTech  3 роки тому +1

      Hi, this is the newest version of the mic I with the pop filter that comes with it. www.rode.com/microphones/studio/nt1-ai1kit

  • @tomeknaj
    @tomeknaj 3 роки тому

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

  • @MrMosoani
    @MrMosoani 2 роки тому

    i guess what I'm looking for which I don't see anyone here on UA-cam is posting, what real-life scenario does it solve? so many experts showing how to use it but it would be simpler experience for viewers to find what they need.
    ex.. If I wanna measure impact what formulas are efficient to use?
    we may be able to learn from video tutorials but it's more useful if it's arranged based on what real problems it can fix.

  • @jacksonjoseph3779
    @jacksonjoseph3779 2 роки тому

    Jackson joseph true step like Haïti

  • @sohot19
    @sohot19 3 роки тому

    🙇

  • @aquaticrose8110
    @aquaticrose8110 3 роки тому +1

    First

  • @ahmedhasanin8445
    @ahmedhasanin8445 Рік тому

    Great thanks to Your effort this lesson was really helpful

  • @vendeirenea1315
    @vendeirenea1315 Рік тому +1

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