This is great I told my new bosses in my interview I loved spreadsheets and knew how to do them, now I can pretend I'm just a little rusty but fumble my way through it.
This is the first TH-cam tutorial I am ever leaving a comment about. I appreciate your voice, calmness and the amount of information in this tutorial, I never skipped for once instead I had to rewind so many times. Thanks a lot sir.
Well, this reminded me of how excited I was to start learning this at school and how disappointed I was because this was never taught to us (maybe just our class) even during college days. I don't want to blame the school as I probably just had lazy IT teachers or maybe the lessons were just exclusive to top section classes, which I would find unfair if that latter was indeed the reason.
Your video was great, easy to follow and you described things well. It would be really helpful if you were able to link each of the sheets you used in the description so that a viewer could make a copy and follow along as you teach. I stopped and did my best to make them as I watched and it took a bit to do the data entry. Thanks!
I was looking for a fixed cell reference for 30 mins, also I didn't know it was called a fixed cell reference, and I realized that there are no google sheets full tutorial that goes from basic to advanced. Ever vide that is searched under google sheets tutorial is "what beginners need to know" etc .... Thanks Man!
You are an awesome teacher thank you🙏 I have been trying to learn these sheets for a long time been using them but never understood so many terms searched a lot of other TH-cam videos but you're the best teacher thanks again
Sir i want to express my good gratitude towards your efforts, of producing and publishing this video training.. It really is good for us towards learning and growing with Google Sheets. Any updates on 2019 edition for us? Thank you sir
There have been lots of updates since this video but I am not sure if any of them would change the subjects this video went through. The interface had some slight changes to conform with "material" design, there were checkboxes added, insert images into cells, and see history of changes in a cell to name a few that I can think of off of the top of my head.
@@ProlificOaktree Hi Oaktree! Actually working on 1st budgeting spreadsheet - but how do i update a total using a formula when i keep adding one row per entry??? ;)
@@mariannes.6023 Just trick Sheets and make the range one cell further down than the values actually go. Then you'll be adding to the middle of the range and it will auto expand.
Question...I am making an accounting sheet that is dated. I would like to date the top of the sheet and have the date replicate to other cells on the sheet. I did a sum of the top date cell to the other cells. Is there another way of doing this? My way works but is it correct? I would love your insight on this.
Thank you for all the information in this video. What I really want to know is if you can make a video on how to link just an image that is saved on your CPU and that will only open on the sheet if you hover over the text it's tagged to in a cell with your mouse or click it to open. Also at the same time, giving the link a shorter name : Like "Price" and not the full name c:\desktop ewfile\price. I don't even know if this is possible. Thank you again. Looking forward to your reply.
Very good information...sir I have one query, I have completed some task on 22nd may, after some time I have checked this task completed date the completed task date automatically changed accordingly the current date...so please tell me how can I fix this problem..
Thanks for a very comprehensive tutorial. I find almost all functions and commands similar to Excel and wonder if the latter has an edge over Sheets any more.
I use Excel in my "day job" because the business world is still pretty tied into it. I get spreadsheets in the Excel format to begin with and I send them back out in Excel. Excel is better with really large data sets or some more complex operations (advanced filter being just one example).
It's not a one cell. Freezed area is so bigger. When I add a pie chart, it is add in unfreezes area . When I trying to move that chart in freezed area it's not moving in freezed area . I resize my chart as small size than 1cell
This was a pleasure to watch and learn from but I have a thin green line across a spreadsheet on my Google docs. The line is just there and I am not sure what it does, all that comes to mind is maybe that it marks the rows that would print if I chose to. Any thoughts? Thank you for the tutorial!
I am working in a Google spreadsheet and before I had not viewed the formula boxes but when I went into the cell it would outline the formula, meaning it would highlight the cells that were part of the formula. I changed the view to show the formula on the top and now it does not outline that formula and I cannot figure out how to do this again. I hope this makes sense it is making me crazy that I cannot figure out what the formula is by just looking at it when I'm in the formula box but have to look at the formula line on the top and figure out which cells they are.
and is it possible to just drag and move cells to move them above or below other cells? Cause I havent found a way to do that yet but surely it's possible? Either I cut/paste or I just manually erase and push other items downward...?
@@ProlificOaktree Wow, amazing that you got back so soon! thank you I just tried it, and successfully moved the sell, but it goes ontop/replaces existing cells instead of in between? Hope that makes sense. If that's the way it is let me know
There's really no built in way to do that. Control (whatever the Mac equivalent is) gives you a new line within a cell though, if that gets you started.
WATCHING FROM 2020. MY BOSS: ARE YOU GOOD IN GOOGLE SHEET? DO YOU HAVE EXPERIENCED ON IT? ME: DEFINITELY, I AM SO GREAT IN DOING A SPREAD SHEET. *AFTER THE INTERVIEW-- SEARCHING, "EVERYTHING TO KNOW IN GOOGLE SHEET". HAHAHAHAHAHA TY
Hi, Thank you for the video. Would you please assist me here. I have a situation where I wanted to subtract the respective row value from grand total in a pivot by using calculated field. Is it possible?
At 26:09 Isn't easier just to use this formula for the average total for D14? =sum(D12/D13) I don't understand why some use over-complicate formulas when with just a simple one its done. Unless I missing something in that case please feel free to enlighten me.
Your formula is saying "add the quotient of D12 divided by D13". The SUM functions wants at least two items to add together, but your formula just gives it one, which is the quotient of the division problem. I think you're headed down the path of how arrays work, when the function can be executed on a range, but that's not what happens in basic formulas.
@@ProlificOaktree I'm new to Excel/Google Sheets thanks ofr the info. I was thinking this one =(D12/D13) BTW Thanks for the vid and all the info I've been watching a lot of videos always being fascinated with spreadsheets programs and all the things we can do with them. I still have to learn a lot of functions and stuff. Enjoying every bit of it.
Could you help me? I would like to input a time in minutes and seconds, and have it display in just seconds for printing. For example if I type in 0:10:06 or 10.6 (as in 10min 6seconds) I want 606 to be displayed in that cell. If yes, could you also do this with hours?
Try pointing the IMPORTRANGE function at the cells that are empty now. I would think it would update once they get values. There are more robust ways to do it if you need something more flexible like I show in this video. It just depends on what you are looking for. th-cam.com/video/caR-K-ykgYo/w-d-xo.html
Help! I am trying to use conditional formatting to highlight a cell that contains certain value in two different sheets . I am struggling with the formula, could someone please advise?
Thank you for the video, very good content. I will like to move the numbers down after the header so I can list some products. Sorry I cant found how do that.
Great video! But I have a question. I am baffled on what formula to use to get the "difference between the current total value (of my stocks) compared to the previous day's value". What is the formula for this? Let's say C6 is the total value of my stocks. Can I see the gain/loss compared to the previous day's value in C7?
That's not it. I'm getting a message that says - #REF! error. "circular dependency detected" C6 would be equal to yesterday's results. My Schwab acct lists it as "DAY'S CHANGE".
- Start - Creating a Sheet
- 4:58 Format your Sheet
- 13:14 Use cell references
- 20:39 Create formulas
- 26:56 Sort and filter
You're a good man.
@@aintnoway5508 Literally in the description though
Much appreciated. The comment has functional links which makes it much easier for mobile users to accurately skip to all the parts
Yes. That is how you do Google Sheets
Is there a way to center text across cell selection without merging in google sheets?
This is great I told my new bosses in my interview I loved spreadsheets and knew how to do them, now I can pretend I'm just a little rusty but fumble my way through it.
Do the same thing every few months for the next 40 years and you're good
I’m in high school and I’m still confused before watching😂 this comment is one of The realest things I’ve ever done!!!!
LOL
Same here. I was asked how I rate myself in navigation of google tools, I mindlessly said 10
@@ros3ssss This I way I don't get hired huh, Because I dont lie SMH
This is the first TH-cam tutorial I am ever leaving a comment about. I appreciate your voice, calmness and the amount of information in this tutorial, I never skipped for once instead I had to rewind so many times. Thanks a lot sir.
That's awesome! Thank you. Creators like it when you comment. It let's us know how the videos are being perceived.
Fantastic video! I wish I could be as clear and concise (and patient!) when I'm explaining a computer concept to my mom...
You and me both.
@@ProlificOaktree hi
Great job, thank you so much! I'll never understand why people do a thumbs down on things that are of super great value. Thanks again! :)
Yeah, thanks for not being one of the haters!
I heard something relaxing while watching this tutorial, sounds like there are birds and wind. I like the place very quiet.
Wait, were you digging the birds or not liking them?
The birds in the background was a nice touch
It feels like they counterbalance the uptight nature of spreadsheets. Ying yang sort of thing.
Used this for a school project and my teacher loved it!
Finally a tutorial I can understand! I definitely recommend implementing each step as you go for information absorption.
I'm glad it helped out!
It would be good to add that you can automatically select the width of a column by double clicking on the border of the cell or column.
Thats one informative video. I feel like an expert already. Thank you so much.
Glad you liked it. Thanks for letting me know.
Thank you so much for creating this!
Well, this reminded me of how excited I was to start learning this at school and how disappointed I was because this was never taught to us (maybe just our class) even during college days. I don't want to blame the school as I probably just had lazy IT teachers or maybe the lessons were just exclusive to top section classes, which I would find unfair if that latter was indeed the reason.
I majored in accounting and had one elective class about spreadsheets. All accountants use them all day. Ugh!
Your video was great, easy to follow and you described things well. It would be really helpful if you were able to link each of the sheets you used in the description so that a viewer could make a copy and follow along as you teach. I stopped and did my best to make them as I watched and it took a bit to do the data entry. Thanks!
I was looking for a fixed cell reference for 30 mins, also I didn't know it was called a fixed cell reference, and I realized that there are no google sheets full tutorial that goes from basic to advanced. Ever vide that is searched under google sheets tutorial is "what beginners need to know" etc .... Thanks Man!
Tx, glad you liked it!
answered my questions and I was only 1/3 finished with the video. Excellent video.
You are an awesome teacher thank you🙏 I have been trying to learn these sheets for a long time been using them but never understood so many terms searched a lot of other TH-cam videos but you're the best teacher thanks again
I use the Importrange function once in a while. It's very convenient.
Thank you, you helped me a lot.. I´ve been struggling a long time.. Thanks again :)
Thank you for creating a very helpful and easy to follow video! Great job!!!
Thank you, glad you enjoyed it!
Thank you for sharing knowledge in a quick way.
My pleasure!
Just started my own biz this was v helpful tyvm!!!
Best of luck to you. Hope it works out well!
Your amazing profilic Oaktree you slow enough your in English i can understand you pretty well take care Buddy Thank You so much for this video k
Glad this tutorial was helpful!
Thank you so much for this crash course !!! looking for a chart based tutorial.
That's a good reminder. I've been meaning to do one on charts.
Very helpful, thanks!
Thank youuuu. you made it easy.
Glad it helped!
This video has just rescued my work life. Thank you sooooo much!
No problem, feel free to send me part of your paycheck!
Excellent! A+ Tutorial.
Thank you!
Can't wait to work on my budget, ty so much for this video it's super helpful and calmly explained! 💕
The spreadsheet's the easy part of a budget!
Thanks and well done. Useful for the beginners for sure.
Glad it was helpful!
Muy buen video! Gracias a personas como tu el mundo es mejor. Eres mi padre
Sir i want to express my good gratitude towards your efforts, of producing and publishing this video training.. It really is good for us towards learning and growing with Google Sheets. Any updates on 2019 edition for us? Thank you sir
There have been lots of updates since this video but I am not sure if any of them would change the subjects this video went through. The interface had some slight changes to conform with "material" design, there were checkboxes added, insert images into cells, and see history of changes in a cell to name a few that I can think of off of the top of my head.
You're a great teacher...thank you
You are welcome!
Excellent instruction!! Thank you.
You're welcome, I'm glad you liked it.
@@ProlificOaktree Hi Oaktree! Actually working on 1st budgeting spreadsheet - but how do i update a total using a formula when i keep adding one row per entry??? ;)
@@mariannes.6023 Just trick Sheets and make the range one cell further down than the values actually go. Then you'll be adding to the middle of the range and it will auto expand.
very useful . hope to see more videos on google sheet, specially import range and other important functions.
Thanks for the suggestion. I'll look into that function.
@@ProlificOaktree Thank you very much Sir, for your prompt reply. I would like to learn more about google drive, as I m totally new to it
great video man!!
Thanks for the visit
Great tutorial. Serious gold. Thank you.
Glad you enjoyed it!
thank you so much for the vedio sir.... very much helpful ..love from INDIA
Most welcome!
Question...I am making an accounting sheet that is dated. I would like to date the top of the sheet and have the date replicate to other cells on the sheet. I did a sum of the top date cell to the other cells. Is there another way of doing this? My way works but is it correct? I would love your insight on this.
Thank you for all the information in this video. What I really want to know is if you can make a video on how to link just an image that is saved on your CPU and that will only open on the sheet if you hover over the text it's tagged to in a cell with your mouse or click it to open. Also at the same time, giving the link a shorter name : Like "Price" and not the full name c:\desktop
ewfile\price. I don't even know if this is possible. Thank you again. Looking forward to your reply.
I don't think so.
You Explain each and everything very greatly,thanks
Well, you're welcome!
THANK YOU THE TUTORIAL WAS VERY HELPFUL
You're welcome!
Very useful for beginners..thank you so much!!! :) :) :)
You're welcome 😊
This was super helpful thanks so much!
Glad it was helpful!
Very good information...sir I have one query, I have completed some task on 22nd may, after some time I have checked this task completed date the completed task date automatically changed accordingly the current date...so please tell me how can I fix this problem..
Thank you! Very helpful!
Awesome, glad you liked it!
Wonderful tutorial for quick start-up!
Thanks!
Your voice is so soothing! Thank you for this tutorial; I'm new to Google Sheets, and this was very helpful! :-D
Awesome, glad you liked it!
Thank you so much you honestly saved me from failing my Statistics class.
Whew!
A great help thank you very much
You're welcome!
Really good tutorial thank you!
What a great tutor you are! Thank you.
Aww, very nice! Thank you.
Thanks for providing this training
You're welcome!
nice tutorial
Really clear. Had several tips I didn't know before. Thanks!
Cool, glad you liked it. Thanks.
Awesome!
Thanks!
Thank you for this great resource!
Glad it was helpful!
That is so cool
Thank you. Good luck with your channel.
Awesome that was exactly what I needed... Thanx mate.
Thanks for a very comprehensive tutorial. I find almost all functions and commands similar to Excel and wonder if the latter has an edge over Sheets any more.
Shah Alam google sheets is simpler and easier and uses less memory
@@biggreenbananas8929 Thanks. Those advantages tilt the balance further in favor of Sheets.
I use Excel in my "day job" because the business world is still pretty tied into it. I get spreadsheets in the Excel format to begin with and I send them back out in Excel. Excel is better with really large data sets or some more complex operations (advanced filter being just one example).
19:28 what if you share a file that references a file that is not shared or owned by the person viewing the first shared file?
The owner of the sheet being referenced has to grant permission for IMPORTRANGE to work no matter what the settings are on either spreadsheet.
I like your ambient sound
I like to share my bird sounds with you guys so you can get the same effect that I get in my backyard!
How add pie chart in freezed cell in google sheet. Iam trying but not success.
Try a sparkline. Charts aren't made to fit in one cell.
It's not a one cell. Freezed area is so bigger. When I add a pie chart, it is add in unfreezes area . When I trying to move that chart in freezed area it's not moving in freezed area . I resize my chart as small size than 1cell
This was very helpful, thanks so much!!!
Glad it was helpful!
You did great
Thanks a lot.
You're welcome. I'm glad you liked it.
Brilliant work !!
Can i remove the lines between eg. A-C that the Text in the Fields combine?
Whoa dude, give me something to go on here! What's the timestamp of the data that you're asking about?
This was a pleasure to watch and learn from but I have a thin green line across a spreadsheet on my Google docs. The line is just there and I am not sure what it does, all that comes to mind is maybe that it marks the rows that would print if I chose to. Any thoughts? Thank you for the tutorial!
You may have a Filter turned on so that marks the boundary of the range that is being filtered.
Hi do you have video about making calendar content for social meron managers???
No sorry!
I am working in a Google spreadsheet and before I had not viewed the formula boxes but when I went into the cell it would outline the formula, meaning it would highlight the cells that were part of the formula. I changed the view to show the formula on the top and now it does not outline that formula and I cannot figure out how to do this again. I hope this makes sense it is making me crazy that I cannot figure out what the formula is by just looking at it when I'm in the formula box but have to look at the formula line on the top and figure out which cells they are.
I've never heard of the cells in a formula not being indicated if you double click (or use F2) to get into the cells.
Great video! I learned a lot! Thank You
Thank you!
and is it possible to just drag and move cells to move them above or below other cells? Cause I havent found a way to do that yet but surely it's possible? Either I cut/paste or I just manually erase and push other items downward...?
The mouse pointer turns into a had if you are near the border of a cell, hold the left mouse button and move it around.
@@ProlificOaktree Wow, amazing that you got back so soon! thank you
I just tried it, and successfully moved the sell, but it goes ontop/replaces existing cells instead of in between? Hope that makes sense. If that's the way it is let me know
@@distortiontildeafness Yes, that's what it's supposed to do.
Thank you very much.
You're welcome!
thank you for your instruction
You're welcome!
getting tested tomorrow on my excel skills...this is helpful lol
Good luck!
Thanks! You helped so much.
You're welcome!
Q: How do you use bullet points for a cell? Both using a mac desktop, and an iPad pro?
There's really no built in way to do that. Control (whatever the Mac equivalent is) gives you a new line within a cell though, if that gets you started.
You are awesome for this!
Thank you!
Thank you so much! My business class didn't even teach this !
I'm not suprised. They should though. A lot of people in business careers use spreadsheets every day.
Could not find: How to put SHORT-CUT, to SprdSht file, icon on Desktop. Would you please help? Thanks!
WATCHING FROM 2020.
MY BOSS: ARE YOU GOOD IN GOOGLE SHEET? DO YOU HAVE EXPERIENCED ON IT?
ME: DEFINITELY, I AM SO GREAT IN DOING A SPREAD SHEET.
*AFTER THE INTERVIEW-- SEARCHING, "EVERYTHING TO KNOW IN GOOGLE SHEET".
HAHAHAHAHAHA TY
I'm telling your boss.
@@ProlificOaktree Thank you so much! I got accepted. ❣️
Hi,
Thank you for the video. Would you please assist me here. I have a situation where I wanted to subtract the respective row value from grand total in a pivot by using calculated field. Is it possible?
Not that I can think of. You may need to use apps script.
At 26:09 Isn't easier just to use this formula for the average total for D14? =sum(D12/D13) I don't understand why some use over-complicate formulas when with just a simple one its done. Unless I missing something in that case please feel free to enlighten me.
Your formula is saying "add the quotient of D12 divided by D13". The SUM functions wants at least two items to add together, but your formula just gives it one, which is the quotient of the division problem. I think you're headed down the path of how arrays work, when the function can be executed on a range, but that's not what happens in basic formulas.
@@ProlificOaktree I'm new to Excel/Google Sheets thanks ofr the info. I was thinking this one =(D12/D13) BTW Thanks for the vid and all the info I've been watching a lot of videos always being fascinated with spreadsheets programs and all the things we can do with them. I still have to learn a lot of functions and stuff. Enjoying every bit of it.
Could you help me? I would like to input a time in minutes and seconds, and have it display in just seconds for printing. For example if I type in 0:10:06 or 10.6 (as in 10min 6seconds) I want 606 to be displayed in that cell. If yes, could you also do this with hours?
Not sure about that one.
is it possible to make a row (horizontal) constant as your scroll down? so that it's fixed?
Yes, go to View then Freeze and choose how to want it to work from there.
amazing loved it
Can I set up an import range of future data that will import from another sheet every time that sheet is updated?
Try pointing the IMPORTRANGE function at the cells that are empty now. I would think it would update once they get values. There are more robust ways to do it if you need something more flexible like I show in this video. It just depends on what you are looking for. th-cam.com/video/caR-K-ykgYo/w-d-xo.html
How to default set a sheet in spreadsheet from many sheet. Please advise
I don't know of a way to do that.
Awesome! Thank you for making this!
You're welcome. I'm glad you like it!
Wow great
really hopefull thanks alot
You're welcome!
Help!
I am trying to use conditional formatting to highlight a cell that contains certain value in two different sheets . I am struggling with the formula, could someone please advise?
I appreciate you! Helping me do my first spreadsheet literally ever. Thank you!
Dear diary, today I made my first spreadsheet. I can't wait to do another!
Hey man, I was trying to do this thing where I have B2 show only 30 percent of A2
Type =A2*.3 into cell B2.
Thank you!
You're welcome!
Thank you for the video, very good content. I will like to move the numbers down after the header so I can list some products. Sorry I cant found how do that.
Thank you for this!
Perfect! Thanks so much!!
You're welcome. I'm glad you liked it.
Nice. thanks
You're welcom!
Great video! But I have a question.
I am baffled on what formula to use to get the "difference between the current total value (of my stocks) compared to the previous day's value".
What is the formula for this? Let's say C6 is the total value of my stocks. Can I see the gain/loss compared to the previous
day's value in C7?
=C6-C7
That's not it. I'm getting a message that says - #REF! error.
"circular dependency detected"
C6 would be equal to yesterday's results. My Schwab acct lists it as "DAY'S CHANGE".