Continue learning Google Sheets with FREE Official Training offered by Google: ✅ Google Sheets Getting Started course: bit.ly/3UwekAu ✅ Google Sheets Advanced Topics course: bit.ly/3tpxDj2 ✅ Google Sheets Functions, Formulas, and Charts course: bit.ly/3UNI9vV
I always wanted to learn Excel (Sheets) and even this ole man (I will be 77 this June 2021), I was thrilled that I could do what you presented here. I will watch two or three more tutorials on Google Sheets and then cross it off my bucket list of things to learn. The next item that I will try? Paramotoring.
You are one of the best Microsoft and Google instructors on the whole internet. Whenever I need crisp, clear instructions, I see if you have done something on it first. Much better than a guy clicking around very quickly on the screen with no explanation and polka music in the background.(No joke, just experienced that!)
Since I have no job right so i have decided to learn form formulas in Excel and I came to your tutorials and I am reviewing what I have in my brainy 😂 by watching your tutorials. Thank you for uploading.👍 .
Please help! I want to make a running total without individual entries. Ex. as each receipt comes in, I simply want to enter the amount spent so it shows in a total cell. If B5 is the amount of the receipt and B6 is the total spent, I want to add B5+ B6, with B6 changing each time a new and different amount is entered in B5
Thank you for giving Google Docs some love. This might be a tall request. Can you do a side by side comparison when doing these formulas between Google Sheet and Excel? This way, we can see how each of them does the calculations.
I need to track accrual and usage of sick time for employees based on actual hours worked. For every 40 hours worked, they accrue 1 sick hour. How is this done in google sheets under the total hours?
I'm just looking for basic formula as im just a beginner with using gsheets and we are going to use it in my midterm exam but damn i've learned a lot of things that i can use in our research paper. Thank u so much for this!! It's very helpful!!
I have ADD, and even I was able to keep up, absorb most of the steps on only 2 pass thrus. Your voice, pace, closeups, and dialog was a tight script with minimal ad lib.
Thanks for the video man. Really helped me a lot. Actually I heard that the google sheet has too many options and now I learned everything you said. Thank you. 🤝 Your tutorial is really amazing.
Stand up for the teacher and pay him veneration, the teacher is almost a messenger. If its in my hands, I'd definitely 👍honor you an OSCAR. Thank you so much 💓. HATS LIFT UP🎩 Sir
Hi Kevin! Thanks for providing this video, I had started a budgeting project in excel that's associated with google forms. I realise chapter 11, =SUMIF was exactly the missing piece. Thanks once again.
Nice explanations you did not waste our Time like other you tuber they don't focus on their content they keep saying or advertising in their video but you didn't do that therefore I liked, subscribed and shared with my few friends I hope you will keep making videos like this lots of love ❤️from india
Hi Mr. Kevin Stratvert! I love your tutorial videos. You are a good teacher, you explained every detail clearly. I wish you will make query tutorial for google sheet too. Thank you for all your effort!
Thanks for this video, reminded me of all the stuff I learnt at school in 1995 and then immediately forgot! "vlookup" is going to take some serious practise though, that section might as well have been in Greek. Top Cookie Monster reference :)
Is there a formula that picks out a certain before or after date from a sheet? For instance, if I need to know which cookies were baked within the last 3 months or later, and the bake date is in the sheet, can Sheets pull out the data, and highlight cells to differentiate them?
Kevin, Thank you for this video, This is a big help, but I need a formula for calculating cost of rebar based on the size of the rebar but I am not sure how to write it. Right now I have a simple formula that calculates finds the tonnage of rebar based on the linear footage multiplied by the weight of the bar per linear foot. Ex. #5 rebar weights 1.043lbs per lft., #4 is .668lbs per lft, etc. but to use this I have to change the formula every time based on the size of rebar itself. Is there a formula that can help me out here?
You have an abundance of knowledge with google sheets! Is there a way to show your total profit yesterday compared to total profit today? (gain/loss for the day) ie...If the sum of profits column was 100,000 yesterday but today the sum of profits only equals 98000 how can I make a cell show a negative 2000 change since yesterday? Thanks.
Hi Kevin! I have a problem. I want the dropbox to appear on c only if there's a value on a or b otherwise it should appear empty. Hope you can help me, Thank you!
hey i have a serious and important question about a project I'm working on... long story short , I have a checklist of materials that have at least 3 separate columns of different information.. what i need is to be able to move any checked items too a different area or a new page entirely.. so basically if something is checked off i need that item along with the 3 columns of info it comes with, to be projected somewhere else in a "owned" category
you can either use apps script which will add to destination and permanently remove from source or use formulas like filter or query that only add to destination without removing from source
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 do I create a formula that divides a time duration - 4:30 (4 hours and thirty minutes) - by another unit. For example, divide 4:30 by 10, to find how many minutes each unit used.
Thank you Pls let me know for mobile version couldn't find password protected cand hide formula... This facility can we add for Google sheets mobile application.. Thanks again 🙏
Is there a way I can change the highlight colour and line thickness to show the current cell. The current blue outline is proving quite hard for me to see. thanks !
Hi Kevin, I enjoy your video they are great and I have learned a lot from them. Several of the people that I follow and use their video have Patreon Campaigns to get exclusive content/video but have you started this as well?
hello im trying to create a risk reward column for a stock trading spreadsheet. i need the (entry price - the stop price )to = the letter "R" .. then i need the (entry + the exit) price to calc out how many (R's) i have gained or lost. is this possible?
Hi Kevin 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
Dear Kevin, when i used sumifs formula in google sheet, in this formula criterion1, i used cell reference or not? because i used cell reference then result is 0 when i used name then result is positive, what i will do? please help me!
Super cool tutorial video! Thanks so much Kevin. I can get much more work done quicker now. Can you make more videos on other Google apps too? Thanks so much! 👍❤😊
Continue learning Google Sheets with FREE Official Training offered by Google:
✅ Google Sheets Getting Started course: bit.ly/3UwekAu
✅ Google Sheets Advanced Topics course: bit.ly/3tpxDj2
✅ Google Sheets Functions, Formulas, and Charts course: bit.ly/3UNI9vV
I love you Kevin. You are the best ❤
Hi sir can we put formula in sheet title? From cell to sheet title in order to edit easily the names of a plenty sheet at a time
I came here after being lost in a course I took. Some people are just born teachers. Thank you!
Me too 😂
I always wanted to learn Excel (Sheets) and even this ole man (I will be 77 this June 2021), I was thrilled that I could do what you presented here. I will watch two or three more tutorials on Google Sheets and then cross it off my bucket list of things to learn. The next item that I will try? Paramotoring.
How did the paramotoring go?
You are one of the best Microsoft and Google instructors on the whole internet. Whenever I need crisp, clear instructions, I see if you have done something on it first. Much better than a guy clicking around very quickly on the screen with no explanation and polka music in the background.(No joke, just experienced that!)
This has made me realize sheets is essential for my business thanks
I don't ever leave comments, but this video was sooooo good! Informative, helpful, direct - thank you!!!!
This was really good! Presented very well and easy to go through. Well done, thanks for making
Since I have no job right so i have decided to learn form formulas in Excel and I came to your tutorials and I am reviewing what I have in my brainy 😂 by watching your tutorials. Thank you for uploading.👍 .
Please help! I want to make a running total without individual entries. Ex. as each receipt comes in, I simply want to enter the amount spent so it shows in a total cell. If B5 is the amount of the receipt and B6 is the total spent, I want to add B5+ B6, with B6 changing each time a new and different amount is entered in B5
Thanks for this. I'm working towards becoming a data analyst and this has been most useful. You have my support, I'm subscribed.
It still doesn't compute, but this is use error.
The way you explain everything is amazing!
I appreciate that you cover both Microsoft and Google options on your channel. Love your content, thank you.
Soooo happy i was refreshed on this and learned google sheets-loved it, so helpful!
thanks for the video. I am software developer and I heard a word concatenate[combining two variables] and turn into new one!
Thank you for giving Google Docs some love. This might be a tall request. Can you do a side by side comparison when doing these formulas between Google Sheet and Excel? This way, we can see how each of them does the calculations.
I need to track accrual and usage of sick time for employees based on actual hours worked. For every 40 hours worked, they accrue 1 sick hour. How is this done in google sheets under the total hours?
Me and my husband learned a lot from this video! Thanks and keep up the good work.
Wish I could watch every video all at once...lol thanks you're going to teach me a lot
Never heard of the counta formula before this is super helpful :)
it's often the very helpful video . dear friend 👍👍
I'm just looking for basic formula as im just a beginner with using gsheets and we are going to use it in my midterm exam but damn i've learned a lot of things that i can use in our research paper. Thank u so much for this!! It's very helpful!!
I have ADD, and even I was able to keep up, absorb most of the steps on only 2 pass thrus. Your voice, pace, closeups, and dialog was a tight script with minimal ad lib.
Thanks for the video man. Really helped me a lot. Actually I heard that the google sheet has too many options and now I learned everything you said. Thank you. 🤝
Your tutorial is really amazing.
Stand up for the teacher and pay him veneration, the teacher is almost a messenger.
If its in my hands, I'd definitely 👍honor you an OSCAR.
Thank you so much 💓.
HATS LIFT UP🎩 Sir
i've learnt so many new and helpful things from this video - thank you!!
I really enjoyed this video and how this is presented to the viewers. Thank you so much!
Very helpful for a not-so-gsheet user" like me 🙂 Now i will be more confident with sheets thank you!
Fast and Straightforward. Thank you! Love it!
Hi Kevin! Thanks for providing this video, I had started a budgeting project in excel that's associated with google forms. I realise chapter 11, =SUMIF was exactly the missing piece. Thanks once again.
Nice explanations you did not waste our Time like other you tuber they don't focus on their content they keep saying or advertising in their video but you didn't do that therefore I liked, subscribed and shared with my few friends I hope you will keep making videos like this lots of love ❤️from india
Thanks you. Learning how to use this for scoring baseball sheets and maybe a local sports grp
very insightful and hands on google sheet skills there. Thanks for giving this out to us
Such a good presentation. What about the percentage? How do you make the column calculate the equation?
Love all your Tutorials. I learn so much. My questions is can you import google docs into OneNote?
Exactly what I needed. Easily explained. Thank you
I loved it how simple way u explained it......plz keep uploading
Sir. You are a good teacher. Thanks.
Hi Mr. Kevin Stratvert! I love your tutorial videos. You are a good teacher, you explained every detail clearly. I wish you will make query tutorial for google sheet too. Thank you for all your effort!
thank you for teaching us in google sheet formulas and your tutorial is very helpful
Great video, thanks Kevin!
Thanks for this video, reminded me of all the stuff I learnt at school in 1995 and then immediately forgot! "vlookup" is going to take some serious practise though, that section might as well have been in Greek. Top Cookie Monster reference :)
This helped me with a project. Well presented and straight to the point. I saved it for future reference. Kudos!
it was really good i understood very fast thankyou verymuch
Is there a formula that picks out a certain before or after date from a sheet? For instance, if I need to know which cookies were baked within the last 3 months or later, and the bake date is in the sheet, can Sheets pull out the data, and highlight cells to differentiate them?
I’m just here to see how to find the mean median and mode for specific numbers bro
It was so much beautifully explained, I understood everything.
Thanks Kevin!!!
Kevin, so well explained! Great videos. Thank you.
Thanks Bro, This was really a quick and important learning.
I enjoyed your class, thank you. I would like to see the Absolute formula.
Thank you so much!!! ❤🎉 I LEARN SO MUCH FROM THIS
Kevin, Thank you for this video, This is a big help, but I need a formula for calculating cost of rebar based on the size of the rebar but I am not sure how to write it. Right now I have a simple formula that calculates finds the tonnage of rebar based on the linear footage multiplied by the weight of the bar per linear foot. Ex. #5 rebar weights 1.043lbs per lft., #4 is .668lbs per lft, etc. but to use this I have to change the formula every time based on the size of rebar itself. Is there a formula that can help me out here?
Hi Kevin. I really enjoy your tutorials. Is it possible to protect/unprotect specific cells in sheets as it is in excel? Thank you.
You are a Great teacher 👍
A fan of your intro!
I FEEL LIKE I CAN CONQURE THE WORLD NOW!
Thanks for the great tutorial. Subscribed and liked.
Thanks for creating this video, Kevin.
Very helpful.❤
This is an excellent tutorial. Thanks, Kevin !
Hi hi holy moly this was concise and educational ! Muchos thanks !!
Thankkkkkkk you video helps me a lot with my homework
Thank you for the excel sheet kevin
A life-saving video. Thank you so much!👌✨
thank you! it was so helpful Kevin
I liked your tutorial a lot. Thanks,
Always enjoy watching your educational videos, always helpful!
Can you do basically the same stuff with google sheets as excel? Is one better than the other?
You have an abundance of knowledge with google sheets!
Is there a way to show your total profit yesterday compared to total profit today? (gain/loss for the day) ie...If the sum of profits column was 100,000 yesterday but today the sum of profits only equals 98000 how can I make a cell show a negative 2000 change since yesterday? Thanks.
So direct to the point, easy to follow. Thanks a lot and I've subscribed.🙏🥰
Hi Kevin, Great Tutorial! Do you have a video that shows how you link the Documents?
I really adore you Kevin for real
Helpful, well explained video. I have been s'rchng for a Function to sum a list of '[Body] WEIGHT'. Can you help? Thanks!
When adding the addition formula, how do I make it so it continues to add numbers as I add more to it? Instead of doing it manual to add two rows?
Kudos to you Kevin! You never disappoint in your tutorials.
Kevin Hi , love your videos. Do you recommend working with 365 business or google workshop? for a small business??
Hi Kevin! I have a problem. I want the dropbox to appear on c only if there's a value on a or b otherwise it should appear empty. Hope you can help me, Thank you!
Kevin, it was easy to follow your explanation. 👍sub.
hey i have a serious and important question about a project I'm working on... long story short , I have a checklist of materials that have at least 3 separate columns of different information.. what i need is to be able to move any checked items too a different area or a new page entirely.. so basically if something is checked off i need that item along with the 3 columns of info it comes with, to be projected somewhere else in a "owned" category
you can either use apps script which will add to destination and permanently remove from source or use formulas like filter or query that only add to destination without removing from source
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.
Thanks for this tutorial. Found it really helpful 😃.
How do I create a formula that divides a time duration - 4:30 (4 hours and thirty minutes) - by another unit. For example, divide 4:30 by 10, to find how many minutes each unit used.
Very useful and quite clear examples! Thank you, Kevin! Regards from Argentina.
Hi sir can we put formula in sheet title? From cell to sheet title in order to edit easily the names of a plenty sheet at a time
You're the best Teacher. Thank you.
Thank you
Pls let me know for mobile version couldn't find password protected cand hide formula...
This facility can we add for Google sheets mobile application..
Thanks again 🙏
I am looking forward to a Microsoft Sharepoint Tutorial Please
Here you go: th-cam.com/video/5nrxp7lc0so/w-d-xo.html 😄
Is there a way I can change the highlight colour and line thickness to show the current cell.
The current blue outline is proving quite hard for me to see.
thanks !
Is there a way I can get popups for formula syntax as you got? If so what should I do
Hi Kevin, I enjoy your video they are great and I have learned a lot from them. Several of the people that I follow and use their video have Patreon Campaigns to get exclusive content/video but have you started this as well?
Thank you so much for this video Kevin! Very helpful!
Thank you Kevin. This is what I expect.👌👌👌
This is helpful.Thanks Kev
Thanks, very helpful for a noobie like me!
hello im trying to create a risk reward column for a stock trading spreadsheet. i need the (entry price - the stop price )to = the letter "R" .. then i need the (entry + the exit) price to calc out how many (R's) i have gained or lost. is this possible?
Hi Kevin
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
Kevin please make video on Microsoft Project Moca
Is there a way that if something is less than 3% or above 3% it can turn that block red or green?
Dear Kevin, when i used sumifs formula in google sheet, in this formula criterion1, i used cell reference or not? because i used cell reference then result is 0 when i used name then result is positive, what i will do? please help me!
Awesome!!! I learned something new! You’re a great instructor!
You are awesome. Heaven honor you!!
This is great. thank you Kevin.
Super cool tutorial video! Thanks so much Kevin. I can get much more work done quicker now. Can you make more videos on other Google apps too? Thanks so much! 👍❤😊