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

  Рет қаралды 34,068

Tasia Custode

Tasia Custode

Күн бұрын

Пікірлер: 50
@TasiaCustode
@TasiaCustode 2 жыл бұрын
Hey friends! What are your most-used functions and formulas in Google Sheets? Comment below!
@KLSe
@KLSe 17 күн бұрын
Whew... saw a lot of formulas vids.... but yours is...... the best and to the point. Thx.
@sreedharanbaskaradass9896
@sreedharanbaskaradass9896 2 жыл бұрын
Something new to learn every time from your videos. The combine column information is a massive time saver. Thank you.
@TasiaCustode
@TasiaCustode 2 жыл бұрын
So glad you like the videos. Thank you for watching and commenting!
@jamesa.rodriguez4180
@jamesa.rodriguez4180 6 ай бұрын
Upbeat, fast-paced (but not too fast) and very clear--thank you! Watching this for a quick tutorial. 🙂
@amydls
@amydls 8 күн бұрын
This was SO helpful. Quick, concise and exactly what I needed to get started. I've subscribed and will be on board to learning more. Thank you!
@TasiaCustode
@TasiaCustode 8 күн бұрын
So glad it helped! Welcome to the family! You're in the right place if you want to master your Google ecosystem!
@LuzGuzman-d8c
@LuzGuzman-d8c Жыл бұрын
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!
@kaarinheap5023
@kaarinheap5023 6 ай бұрын
Super helpful. I'm refreshing my memory for a job test tomorrow. Thank you!
@krutarth_suthar
@krutarth_suthar 2 жыл бұрын
Appreciate the passion you "teach". Waiting for next advanced video on Google Sheets!
@TasiaCustode
@TasiaCustode 2 жыл бұрын
Thanks so much. Glad you liked the video. I’ll get working on an advanced one soon enough!
@everestuscalliste-gi6549
@everestuscalliste-gi6549 6 ай бұрын
Thanks for making this valuable information simple .
@JamesEnTennessee
@JamesEnTennessee 9 ай бұрын
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
@TasiaCustode 9 ай бұрын
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!
@jamesamberpeta
@jamesamberpeta 2 ай бұрын
Thank you very helpful tutorial
@emeryazevedo9948
@emeryazevedo9948 9 ай бұрын
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.
@anujaghosh9082
@anujaghosh9082 3 ай бұрын
Very helpful 🙌
@SharedAccount-r4g
@SharedAccount-r4g Жыл бұрын
Can I collect countif among several sheets? Thanks
@nerissataylor
@nerissataylor 2 ай бұрын
Thank you for this
@MrandDrSmith
@MrandDrSmith 2 жыл бұрын
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
@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
@kinkykurlychic470
@kinkykurlychic470 8 ай бұрын
Thank you! This was helpful!!
@lloyd-qt1mg
@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!!
@ladycoder2095
@ladycoder2095 2 жыл бұрын
Awesome Tasia 😊
@TasiaCustode
@TasiaCustode 2 жыл бұрын
Glad you liked it!
@janicewhite5849
@janicewhite5849 Жыл бұрын
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
@SeanC-x9j
@SeanC-x9j 3 ай бұрын
I'm going to guess that you will be Princess Leia this year for Halloween.
@ReneeThompson-mo4qj
@ReneeThompson-mo4qj Жыл бұрын
❤ do you have a following long template so I can practice please.
@mohdmohsin2803
@mohdmohsin2803 2 жыл бұрын
Thank you..
@TasiaCustode
@TasiaCustode 2 жыл бұрын
You're welcome!
@prasannasnaik4241
@prasannasnaik4241 5 ай бұрын
Hello Ma'am How to Equal To cells Like if A1=B1 or J2=H2
@Kruffy
@Kruffy Ай бұрын
awesome thank you
@fazliagency
@fazliagency Жыл бұрын
assalam o alaikom dear Tasia please share one video of google sheet formola of profit and lose ( kata )
@MariaHerrera-ng8os
@MariaHerrera-ng8os 2 ай бұрын
Thank you. Very informative. However, I don't celebrate Holloween.
@rossjohnson9162
@rossjohnson9162 Ай бұрын
I am looking for the $cell to copy down so the top cell selection does not change, so sad, not working, not enough edjumacation.
@jeromezimmerman961
@jeromezimmerman961 Жыл бұрын
How to use URL to move data between sheets.
@likhonhosenkhokon5457
@likhonhosenkhokon5457 2 жыл бұрын
I see YOUR All video ..love u sister
@TasiaCustode
@TasiaCustode 2 жыл бұрын
Thanks for always watching!
@ronm6585
@ronm6585 2 жыл бұрын
Thank you Tasia. I think you are going to be a "teacher" for Halloween. 😁
@TasiaCustode
@TasiaCustode 2 жыл бұрын
Haha good guess, Ron. That would have been a lot easier than what I’m going as!
@angeliabeadle4365
@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?
@techstudio6293
@techstudio6293 2 жыл бұрын
Thanks
@TasiaCustode
@TasiaCustode 2 жыл бұрын
No problem!
@taherehmajidi4398
@taherehmajidi4398 Жыл бұрын
Tnx
@vijujose876
@vijujose876 2 ай бұрын
Hi sister how to add automatically Indian rupees to US currency formula
@joananderson4111
@joananderson4111 Жыл бұрын
@brenthair1228
@brenthair1228 2 жыл бұрын
Tasia, You make learning fun And for Halloween I think you will be Adorable
@TasiaCustode
@TasiaCustode 2 жыл бұрын
Glad you like the videos. Haha I don’t know, this Halloween, I’m really going for it 😂
@JarenMartin-n5u
@JarenMartin-n5u 5 ай бұрын
So pretty
15 Spreadsheet Formulas Working Professionals Should Know!
14:42
10 INCREDIBLE things Google Sheets can do Right Now!
13:27
Jeff Su
Рет қаралды 56 М.
[BEFORE vs AFTER] Incredibox Sprunki - Freaky Song
00:15
Horror Skunx 2
Рет қаралды 20 МЛН
Quilt Challenge, No Skills, Just Luck#Funnyfamily #Partygames #Funny
00:32
Family Games Media
Рет қаралды 53 МЛН
Как Я Брата ОБМАНУЛ (смешное видео, прикол, юмор, поржать)
00:59
How to use Formulas and Functions in Google Sheets
26:34
Teacher's Tech
Рет қаралды 84 М.
How to use VLOOKUP in Google Sheets
12:36
Teacher's Tech
Рет қаралды 24 М.
3 Easy Ways to Use AI in Excel Tutorial (Beginner)
12:52
Elliot Gherardi
Рет қаралды 2,2 М.
15 Functions in Google Sheets You NEED to know!
17:30
Flipped Classroom Tutorials
Рет қаралды 438 М.
10 Google Sheets Tips You DON'T Want to Miss
13:51
Leila Gharani
Рет қаралды 579 М.
Google sheets have some killer hidden features
9:18
Bog
Рет қаралды 19 М.
Google Sheets IF & IFS Functions - Formulas with If, Then, Else, Else If Statements
21:43
Learn Google Sheets & Excel Spreadsheets
Рет қаралды 580 М.
What is Google Stack? How to Use the Smart PDF Scanner
11:57
Tasia Custode
Рет қаралды 5 М.
7 Google Sheets Tips that will Save You So Much Time!
11:49
Simpletivity
Рет қаралды 26 М.
10 BEST Google Sheets HACKS for Teachers
21:12
Pocketful of Primary
Рет қаралды 74 М.
[BEFORE vs AFTER] Incredibox Sprunki - Freaky Song
00:15
Horror Skunx 2
Рет қаралды 20 МЛН