Google Sheets Formulas Tutorial: How to Use Formulas and Functions in Google Sheets
ฝัง
- เผยแพร่เมื่อ 2 ก.ค. 2024
- Here’s your Google Sheets formulas tutorial! In this video, you’ll learn how to use some of the most popular formulas and functions in Google Sheets.
Hey friends, I’m Tasia Custode, and in this video, I’m breaking down how to use functions and formulas in Google Sheets. You’ll learn the difference between formulas and functions, some basic math equations, how to combine column information, date and time functions, and more. Consider this video your Google Sheets Beginners Bible.
⏰ TIMECODES:
00:00 - Intro
00:33 - Difference between formulas and functions
00:51 - Basic math equations
03:21 - SUM function in Google Sheets
05: 44 - Count function in Google Sheets
06:08 - Min and max functions in Google Sheets
07:00 - Average, median, and mode functions
07:45 - Combine column information
09:24 - Date and countdown functions and formulas
10:51 - Handy shortcuts
👀 WATCH OTHER GOOGLE SHEETS VIDEOS:
📹 Google Sheets Tips for Productivity: • Google Sheets Tips for...
📹 Google Sheets Keyboard Shortcuts: • The Best Google Sheets...
GOOGLE SHEETS FUNCTION LIST:
support.google.com/docs/table...
📷 TH-cam CAMERA GEAR:
Panasonic GH5 Lumix Kit: geni.us/teLeWzz
Sony ZV1 Camera & Vlogging Kit: geni.us/B6pj
Rode VideoMic Pro+: geni.us/yfXsy
Vanguard Alta Pro Tripod: geni.us/3Ougb
Sony E Series SD Card: geni.us/BBi1Yxd
Neewer Ring Light Kit: geni.us/3ho03WZ
Neewer Desktop Ring Light: geni.us/quBpGZ
Neewer Camera Light: geni.us/RyRTA
⌚️ MY APPLE WATCH BAND: geni.us/1IMxe
👚SHOP MY MERCH: tasiacustode.myspreadshop.com/
✅ RECOMMENDATIONS:
🎦 I use Tubebuddy to grow my TH-cam Channel. Learn more:
www.Tubebuddy.com/tasiacustode
🖼I use Canva to create all my TH-cam thumbnails. Learn more: partner.canva.com/jWXqOv
🎞 I use Camtasia for all my screencasting needs: techsmith.z6rjha.net/2rrRvG
⚙️ DOWNLOAD MY DIGITAL TOOLKIT:
www.tasiacustode.com/digitalt...
🤝 CONNECT WITH ME:
📸 Instagram - / tasiacustode
👍🏻 Facebook - / tasiacustode
🖥 Website: www.tasiacustode.com/
*Some of these links are affiliate links, meaning I may make a small commission if you sign up or purchase a product using these links. Don’t worry, this is at no extra cost to you! Thank you so much!
Did you find this video helpful? Have questions or comments? Leave your thoughts in the comment section below.
#GoogleSheets #ProductivityTips
If you like this video, give a like, a share, or subscribe for more tech tips and app reviews. - วิทยาศาสตร์และเทคโนโลยี
![CAMPปลิ้น | EP.77[1/2] ก็ไม่ได้ชอบเอาชนะ แต่เรื่องอะไรต้องแพ้!!](http://i.ytimg.com/vi/JraaBYOd7I0/mqdefault.jpg)
Hey friends! What are your most-used functions and formulas in Google Sheets? Comment below!
Upbeat, fast-paced (but not too fast) and very clear--thank you! Watching this for a quick tutorial. 🙂
Super helpful. I'm refreshing my memory for a job test tomorrow. Thank you!
Something new to learn every time from your videos. The combine column information is a massive time saver. Thank you.
So glad you like the videos. Thank you for watching and commenting!
You are amazing. I was given a task at work and for a minute I thought it was going to be difficult. You made it soooo easy. I subscribe to keep on learning with you. Thank you so much!
Thanks for making this valuable information simple .
Thank you! This was helpful!!
Appreciate the passion you "teach". Waiting for next advanced video on Google Sheets!
Thanks so much. Glad you liked the video. I’ll get working on an advanced one soon enough!
Awesome Tasia 😊
Glad you liked it!
Thank you..
You're welcome!
You just became my all time go to person to learn all things Google! Informative-clear-concise-worth subscribing to. Thanks. I do hope you see this because I have a question. How can I add a box/section/cell range...I don't know the proper term - but - I want to create a section at the top of the spreadsheet where: Name, Age, Blank, Blank can ge entered and remain frozen there. Would you please tell me how to do that? Thanks...Jim
Hi James! Welcome to the Channel. You might be talking about freezing cells? To do so, select a row or column you want to freeze or unfreeze. At the top, click View and then Freeze. Select how many rows or columns to freeze. To unfreeze, select a row or column. Then, at the top, click View and then Freeze and then No rows or No columns. OR, quicker yet: The top left cell of your Google Sheet should be outlined in grey. You can drag on the grey border (down or across to the right) to place it where you want. This will freeze those cells/rows :) Hope this helps!
Can I collect countif among several sheets?
Thanks
Tnx
Thanks
No problem!
Hi Tasia I am usually pretty good with google sheets I had combined 4 columns and when I go =sum(c15-c18) it is off by one number it gives me 24
Could you help with this?: I want to filter on two columns. Where Column C is Blank or Column C contains only a comma; and Where column D contains either the word Red, Green, or Yellow. How do I accomplish this? Also, can I add on one more thing, after you filter on C and D, in Column F I want to take the first 4 letters of the text in Column F.
Hi Tasia, great demo ....but....how do I embed a formula into a cell so that it does not delete when I delete the 'data' in that same cell? Girl, , it's so frustrating! Question No.2. : I create a formula in a cell that adds the contents of two other cells and places the sum of them in it's cell. The formula shows up as: #DIV/0! with a tiny arrow in the top right corner of the cell, giving me an error message. The tiny arrow should appear in the top left corner of the cell, not to get the error message appearing. HELP!!
Hi Tasia
how to do subtracting % , like for example my first cell would be 100 usd in the next cell i would like to have that but -15% = 85
Thanks in advance
❤
Do you have any videos about how to link specific cells together? I'm very new to all of this. I'm trying to link some check boxes together so when I check one box in a column it will automatically check other boxes in diffierent rows in that same column and vise versa. I want to make this happen with several columns each check box in the cloumns are linked to the check boxes in the rows below. The boxes are only linked to the boxes in the same column though. does that make sesnse? Sorry, I'm not really good at explaining things very well.
How to use URL to move data between sheets.
I see YOUR All video
..love u sister
Thanks for always watching!
assalam o alaikom dear Tasia please share one video of google sheet formola of profit and lose ( kata )
❤ do you have a following long template so I can practice please.
HELP! I need a formula for google sheets. I have multiple columns that will sometimes have dates in them. I need column "O"'s formula to subtract from the date in column "M" the date in column "L" if there is a date in it, if not the date in column "K" if there is a date in it, and if not the date in Column "J". There will always be a date in "L, K, or J" if there is a date in Column "M" and may have a date in multiple columns but I only need it to subtract from the one with the date in the order specified. Can anyone help me with this?
Tasia, You make learning fun And for Halloween I think you will be Adorable
Glad you like the videos. Haha I don’t know, this Halloween, I’m really going for it 😂
Thank you Tasia. I think you are going to be a "teacher" for Halloween. 😁
Haha good guess, Ron. That would have been a lot easier than what I’m going as!
So pretty