How to use Formulas and Functions in Google Sheets
ฝัง
- เผยแพร่เมื่อ 5 ก.ค. 2024
- Google Sheets formulas and functions for beginner's 2021 tutorial. I will show you how to use formulas and functions in Google Sheets. I will start with basic math formulas in Google Sheets and show you some of the very popular and powerful functions. Use the timestamps below to help you navigate through this video.
Here’s the link to the practice spreadsheet: docs.google.com/spreadsheets/...
0:00 Intro
0:49 Basic math formulas
3:35 Starting with the SUM Function in Google Sheets
7:05 The COUNT function
8:50 AVERAGE, MEDIAN and MODE functions
10:32 MIN and MAX functions in Google Sheets
11:19 Functions and formulas with Date and time in Google Sheets
14:04 Using formulas to combine columns
15:44 If statements in Google Sheets
19:01 How to use VLOOKUP in Google Sheets
22:12 Conditional functions (SUMIF, SUMIFS, COUNTIF etc.)
Interested in how I make my videos? Here’s a tutorial: • How to Use Camtasia wi...
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.
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.
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.
That's true, I couldn't find someone explaining how to follow the formula guide. This is the best.
Excellent teaching! Very practical. Thank you!
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.
You are such a great teacher! Thank you!
Excellent overview of formulas - clearly explained, great examples.
Glad it was helpful!
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
You are an amazing teacher, 🙏🏽
Thank you so much for providing the spreadsheet along with the video. enjoyed this one too.
Excellent Google sheet Instructor!. Keep doing well. Thanks for sharing your knowledge.
Good teachers are such gifts. Thank You.
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.
Amazing video, it really helps!!
Glad to hear it!
OMG THANK YOU SO MUCH!! 😭😭 THIS IS VV HELPFUL!
all your teacher vids are gold
perfect video to learn about google sheet,
One of the BEST!
Hi, I like how you explain the subject
very useful video, thanks for posting.
You’re welcome!
Great lesson
Thank you ,sir.
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
Best teacher❤
Wow! Awesome video!
Thanks!
Thanks for this
I’m glad I could help!
Great help!
Thank you
Excellent video
Thank you!
Learn a lot
You are a Billionaire in the making!!
Thanks
Is there anyway to do a split and vlookup combined?
Great way to learn. How do I total columns and not double add the subtotals in said column total?
how about beginning balance and your depositing and subtracting or withdrawning to get current amount
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?
Great video, however I don't have the suggestions coming up. How do I turn them on? than you
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
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?
Random tech question, but what type of pop filter are you using during your videos?
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
Just a suggestion. You use "Go ahead" quite a lot. Changing it up or omitting it all together would be nice.
Jackson joseph true step like Haïti
🙇
How can I develop a formula for a banking sheet which when a credit or debit is entered the balance reduces? Finding this tough
Nice video, pity you didn't finish the COUNTIF(S)
i guess what I'm looking for which I don't see anyone here on TH-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.
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??
First
Great thanks to Your effort this lesson was really helpful
I LITERALLY CRIED WHEN I TRIED THE LAST TUTORIAL AND I GOT IT!! 😭🤍🤍 THANK YOU SO MUCH
You're welcome!!