Google Sheets Formulas Tutorial: How to Use Formulas and Functions in Google Sheets

Рет қаралды 25,150

Күн бұрын

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...
📷 KZfaq 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 KZfaq Channel. Learn more:
www.Tubebuddy.com/tasiacustode
🖼I use Canva to create all my KZfaq 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.

Пікірлер: 38

@TasiaCustode Жыл бұрын

Hey friends! What are your most-used functions and formulas in Google Sheets? Comment below!

@jamesa.rodriguez4180 Ай бұрын

Upbeat, fast-paced (but not too fast) and very clear--thank you! Watching this for a quick tutorial. 🙂

@everestuscalliste-gi6549 27 күн бұрын

Thanks for making this valuable information simple .

@kaarinheap5023 Ай бұрын

Super helpful. I'm refreshing my memory for a job test tomorrow. Thank you!

@sreedharanbaskaradass9896 Жыл бұрын

Something new to learn every time from your videos. The combine column information is a massive time saver. Thank you.

@TasiaCustode Жыл бұрын

So glad you like the videos. Thank you for watching and commenting!

@user-gc5zh5sl2o 11 ай бұрын

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!

@kinkykurlychic470 3 ай бұрын

Thank you! This was helpful!!

@krutarth_suthar Жыл бұрын

Appreciate the passion you "teach". Waiting for next advanced video on Google Sheets!

@TasiaCustode Жыл бұрын

Thanks so much. Glad you liked the video. I’ll get working on an advanced one soon enough!

@ladycoder2095 Жыл бұрын

Awesome Tasia 😊

@TasiaCustode Жыл бұрын

Glad you liked it!

@JamesEnTennessee 4 ай бұрын

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

@TasiaCustode 4 ай бұрын

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!

@user-sj8ub2pf3m Жыл бұрын

Can I collect countif among several sheets? Thanks

@janicewhite5849 8 ай бұрын

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

@MrandDrSmith Жыл бұрын

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.

@vikentijslauruts2153 Жыл бұрын

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

@emeryazevedo9948 3 ай бұрын

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.

@mohdmohsin2803 Жыл бұрын

Thank you..

@TasiaCustode Жыл бұрын

You're welcome!

@lloyd-qt1mg Жыл бұрын

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

@taherehmajidi4398 9 ай бұрын

Tnx

@user-od6fs5od6c Жыл бұрын

assalam o alaikom dear Tasia please share one video of google sheet formola of profit and lose ( kata )

@joananderson4111 7 ай бұрын

❤

@techstudio6293 Жыл бұрын

Thanks

@TasiaCustode Жыл бұрын

No problem!

@ReneeThompson-mo4qj 11 ай бұрын

❤ do you have a following long template so I can practice please.

@jeromezimmerman961 Жыл бұрын

How to use URL to move data between sheets.

@angeliabeadle4365 Жыл бұрын

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?