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!
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!
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.
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
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?
Hey friends! What are your most-used functions and formulas in Google Sheets? Comment below!
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!
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!
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!
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!
Thanks for making this valuable information simple .
Thank you very helpful tutorial
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!
Thank you for this
Very helpful 🙌
Thank you! This was helpful!!
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
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.
Hello Ma'am
How to Equal To cells
Like if A1=B1 or J2=H2
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.
Awesome Tasia 😊
Glad you liked it!
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!!
Can I collect countif among several sheets?
Thanks
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
Thank you..
You're welcome!
assalam o alaikom dear Tasia please share one video of google sheet formola of profit and lose ( kata )
Tnx
❤ 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?
I see YOUR All video
..love u sister
Thanks for always watching!
How to use URL to move data between sheets.
Thank you. Very informative. However, I don't celebrate Holloween.
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!
Thanks
No problem!
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 😂
I'm going to guess that you will be Princess Leia this year for Halloween.
❤
So pretty