How to use Formulas and Functions in Google Sheets

[@danalane2366]

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.

[@1rocknroy]

Good teachers are such gifts. Thank You.

[@LowRotor]

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]

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]

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

[@gina86]

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.

[@marwaghith9249]

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.

[@emilharden9532]

Excellent overview of formulas - clearly explained, great examples.

[@TeachersTech]

Glad it was helpful!

[@kenbahati]

Excellent teaching! Very practical. Thank you!

[@diyaghosh5104]

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

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

[@everestuscalliste-gi6549]

Great help!

[@kirstentownley8916]

You are such a great teacher! Thank you!

[@teddyw.charawa8989]

You are a Billionaire in the making!!

[@lisbethfraze9059]

You are an amazing teacher, 🙏🏽

[@vendeirenea1315]

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

[@esgaldir7315]

all your teacher vids are gold

[@burhanuddin6371]

perfect video to learn about google sheet,

[@abdofeduconsult]

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

[@didargrewal1856]

Best teacher❤

[@anthonyjenkins5170]

Thanks

[@girIs.]

Amazing video, it really helps!!

[@TeachersTech]

Glad to hear it!

[@BeingMau]

One of the BEST!

[@orainedittmar344]

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

[@bhanupratapsingh4169]

very useful video, thanks for posting.

[@TeachersTech]

You’re welcome!

[@sonyarobinson6287]

Thanks for this

[@TeachersTech]

I’m glad I could help!

[@alexmwaniki1069]

Great lesson

[@collegeboytwo]

Wow! Awesome video!

[@TeachersTech]

Thanks!

[@natividaddelfin5930]

Hi, I like how you explain the subject

[@ilyaszaw7459]

Thank you ,sir.

[@bethls28]

Thank you

[@techtimes1985]

Excellent video

[@TeachersTech]

Thank you!

[@bryantdesiabagat5871]

Learn a lot

[@victoriagarcia2318]

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

[@kimaffleck7943]

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

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

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

[@gormangraphics]

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

[@stephenbrown9400]

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

[@sheila3353]

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

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

[@FantasyFinalFiend]

Is there anyway to do a split and vlookup combined?

[@jacksonjoseph3779]

Jackson joseph true step like Haïti

[@danielleneri7640]

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

[@TeachersTech]

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

[@r0sie888]

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]

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

[@symcardnel1741]

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

[@MrMosoani]

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

[@sohot19]

🙇

[@aquaticrose8110]

First

[@ahmedhasanin8445]

Great thanks to Your effort this lesson was really helpful

[@vendeirenea1315]

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

[@TeachersTech]

You're welcome!!