How to use Formulas and Functions in Google Sheets

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

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

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

  • @pamtaylor-harris1010
    @pamtaylor-harris1010 2 года назад +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.

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

  • @1rocknroy
    @1rocknroy 9 месяцев назад +1

    Good teachers are such gifts. Thank You.

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

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

    Excellent overview of formulas - clearly explained, great examples.

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

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

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

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

    Excellent teaching! Very practical. Thank you!

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

    You are such a great teacher! Thank you!

  • @teddyw.charawa8989
    @teddyw.charawa8989 Год назад

    You are a Billionaire in the making!!

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

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

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

    You are an amazing teacher, 🙏🏽

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

    perfect video to learn about google sheet,

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

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

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

    all your teacher vids are gold

  • @everestuscalliste-gi6549
    @everestuscalliste-gi6549 2 месяца назад

    Great help!

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

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

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

    Best teacher❤

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

    One of the BEST!

  • @girIs.
    @girIs. 3 года назад +2

    Amazing video, it really helps!!

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

    Thanks

  • @T-wr1cl
    @T-wr1cl Месяц назад

    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

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

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

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

    very useful video, thanks for posting.

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

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

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

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

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

    Thank you ,sir.

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

    Wow! Awesome video!

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

    Jackson joseph true step like Haïti

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

    Thank you

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

    Hi, I like how you explain the subject

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

    Excellent video

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

    Thanks for this

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

    Learn a lot

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

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

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

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

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

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

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

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

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

    Is there anyway to do a split and vlookup combined?

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

    i guess what I'm looking for which I don't see anyone here on RUclips 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.

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

    Great thanks to Your effort this lesson was really helpful

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

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

    🙇

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

    First

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

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