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 RUclips 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.
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!
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.
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..
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 RUclips videos but you're the best teacher thanks again
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.
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.
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 would like to ask , i want to copy the youtube playlist to excel(sheet) , because they always delete the video, and thosse video name are gone, witch i don't know what that empty are, and can't find it back to my collection again. but after i copy and paste, they are lining at a single column only. can u teach how to do those arrangement? i have try to write the grid number in a column, ie. A6, A10, A14 but after i pull the little cross at corner , it give A9,A13, A17, then A12, A16, A20 i dun understand how it logic work, and can i just tell it what to do? to transform it?
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.
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).
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!
Hii sir,,,i am fetching percentage change of stocks from google finenance using "changepct" attribute. Result comes but without % sign. Can u plzz help me, how can i put % symbol??
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
Slnp Art It is most likely that you would still be using Excel. However, there are far more similarities than there are differences so learning Sheets would help.
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?
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. ruclips.net/video/caR-K-ykgYo/видео.html
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.
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".
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?
@@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.
I don't think so. Here is a discussion about it. www.experts-exchange.com/questions/29089064/How-to-link-to-external-data-in-Google-Sheets-pivot-table.html
Can you help me with my problem, please? I created a table with a cell named "Status" and it is located in C3, for example. As well i created a dropping-down menu for this cell with 3 components. I need the colour of a whole range of cells to be changed according to the condition of this "status" cell - if one component is chosen - it should change to, say, red colour. If the second - to some other and so on
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
I have a excel file, In That excel I have 3 sheets witch are inter link with many formulas. When I uploading to Google sheet some of the formulas are not working. Can you help on this
Yeah, just keep them in Google Drive but using the Office file formats using Office Compatibility Mode. See this video ruclips.net/video/oo9qtyqNFE0/видео.html
I want to make a load out spread sheet for my Arma 3 (Video Game) unit similar to the 501st version were it has a few images as visual examples and then a list of i teams allowed under each load out picture how would I do that?
Ayush Dugar I’m a member of the 501st but I own a small group called Bravo Arms I started with BC Jays day that I didn’t have to leave the 501st. Why do you ask? “My clone brother”
Thank you so much sir , sir when i am importing existing xls sheet it is removing all my functions/micros , how can i import my sheet with all formulas intact ??? plz help me.
Macros can't be imported. However, formulas should come into Sheets as they were in Excel. Make sure you upload it and then open it in Sheets instead of copying it in Excel and pasting it into Sheets.
Perhaps those five people should be entertaining data with Google Forms instead. Thar way the data gets into the spreadsheet but they don't need access to it. See here ruclips.net/video/vQw2jDlylDU/видео.html
Hello Sir! I tried to use IMPORTRANGE() to copy cell range from one file to another you have shown in this video that in the second argument of this function, sheet name is optional. But when I skipped it and directly wrote cell ranges, nothing comes up not even an error message !! can you please help me? thanks in advance
@@ProlificOaktreeFirst above all Thanks for considering and answering query even with your busy schedule. No, that is an array of cells being referenced and they are in the 2nd sheet of the 1st file that I tried to import to 2nd file sheet1. ok, I will add a name . thanks once again
This tutorial was very helpful. I am trying to set up a spreadsheet for tracking investments. I am trying to enter my formulas. When I enter a formula that is dividing one cell from another I get an error message saying I cannot divide by 0. I don't know what I am doing wrong? How do I enter the formula with no numbers yet entered?
How do you make it so the scroll bar on the right that scrolls down the rows stops and not go all the way to 500 rows? Like I am only using 46 rows but it still goes down to 500 rows.
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.
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.
I've been searching every where for this answer and cant seem to find it. On the spread sheet, in colum 1, I have a list of names going across the top. I have all of them sitting at a 45 degree angle. When I publish it, they are all sitting horizontally. How can I publish this with the names at a 45 degree angle?
@@ProlificOaktree File Publish to the web. And I tried it all and I get that same result. Link or embedding. Then web page and all the different options after, all the same result. On google sheets, they are on a 45 degree angle, but the published is not.
Is there a way that when I input number "x" into a cell, another cell will automatically give me the percentage of it? Example, L26 has an input 300. I need cell C20 to show 60% of that number
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.
- 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
@@rosellesalvador4315 This I way I don't get hired huh, Because I dont lie SMH
This is the first RUclips 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
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?
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.
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!
The birds in the background was a nice touch
It feels like they counterbalance the uptight nature of spreadsheets. Ying yang sort of thing.
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!
Finally a tutorial I can understand! I definitely recommend implementing each step as you go for information absorption.
I'm glad it helped out!
Thats one informative video. I feel like an expert already. Thank you so much.
Glad you liked it. Thanks for letting me know.
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.
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 so much for creating this!
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 RUclips videos but you're the best teacher thanks again
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!
Used this for a school project and my teacher loved it!
answered my questions and I was only 1/3 finished with the video. Excellent video.
Thank you for creating a very helpful and easy to follow video! Great job!!!
I'm glad you liked it. Thanks for letting me know.
Thank you for sharing knowledge in a quick way.
My pleasure!
This video has just rescued my work life. Thank you sooooo much!
No problem, feel free to send me part of your paycheck!
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.
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.
Just started my own biz this was v helpful tyvm!!!
Best of luck to you. Hope it works out well!
Thank you, you helped me a lot.. I´ve been struggling a long time.. Thanks again :)
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.
I use the Importrange function once in a while. It's very convenient.
Thanks and well done. Useful for the beginners for sure.
Glad it was helpful!
When saving the sheet and sharing it, the file shows a grey blank face on the cover of the file. How do I change that to a picture of my choice?
GREAT JOB! Thank you!
i would like to ask , i want to copy the youtube playlist to excel(sheet) , because they always delete the video, and thosse video name are gone, witch i don't know what that empty are, and can't find it back to my collection again.
but after i copy and paste, they are lining at a single column only.
can u teach how to do those arrangement?
i have try to write the grid number in a column, ie. A6, A10, A14
but after i pull the little cross at corner , it give A9,A13, A17, then A12, A16, A20
i dun understand how it logic work, and can i just tell it what to do? to transform it?
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.
Very helpful, thanks!
Could not find: How to put SHORT-CUT, to SprdSht file, icon on Desktop. Would you please help? Thanks!
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!
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?
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).
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!
Hii sir,,,i am fetching percentage change of stocks from google finenance using "changepct" attribute. Result comes but without % sign. Can u plzz help me, how can i put % symbol??
great video man!!
Thanks for the visit
Thank you so much you honestly saved me from failing my Statistics class.
Whew!
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.
Do jobs allow you to use Google sheets or if I learn sheets, I will be good at excel also?
Slnp Art It is most likely that you would still be using Excel. However, there are far more similarities than there are differences so learning Sheets would help.
You Explain each and everything very greatly,thanks
Well, you're welcome!
Excellent! A+ Tutorial.
Thank you!
Wonderful tutorial for quick start-up!
Thanks!
Very useful for beginners..thank you so much!!! :) :) :)
You're welcome 😊
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.
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
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.
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.
Hi do you have video about making calendar content for social meron managers???
No sorry!
Great tutorial. Serious gold. Thank you.
Glad you enjoyed 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. ruclips.net/video/caR-K-ykgYo/видео.html
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.
Muy buen video! Gracias a personas como tu el mundo es mejor. Eres mi padre
You're a great teacher...thank you
You are welcome!
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".
This was super helpful thanks so much!
Glad it was helpful!
Thank youuuu. you made it easy.
Glad it helped!
thank you so much for the vedio sir.... very much helpful ..love from INDIA
Most welcome!
THANK YOU THE TUTORIAL WAS VERY HELPFUL
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?
Really clear. Had several tips I didn't know before. Thanks!
Cool, glad you liked it. Thanks.
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.
What a great tutor you are! Thank you.
Aww, very nice! Thank you.
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!
Is it possible to have 2 different files. One for database only and another one for a pivot table for analysis purposes
I don't think so. Here is a discussion about it. www.experts-exchange.com/questions/29089064/How-to-link-to-external-data-in-Google-Sheets-pivot-table.html
Can you help me with my problem, please?
I created a table with a cell named "Status" and it is located in C3, for example. As well i created a dropping-down menu for this cell with 3 components. I need the colour of a whole range of cells to be changed according to the condition of this "status" cell - if one component is chosen - it should change to, say, red colour. If the second - to some other and so on
Sounds like you need conditional formatting with a custom formula. Start here ruclips.net/video/W7wjXGzB4hs/видео.html
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
I have a excel file, In That excel I have 3 sheets witch are inter link with many formulas. When I uploading to Google sheet some of the formulas are not working. Can you help on this
Yeah, just keep them in Google Drive but using the Office file formats using Office Compatibility Mode. See this video ruclips.net/video/oo9qtyqNFE0/видео.html
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 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.
Dear sir,
below is the URL, I want to import FnO stock’s open interest data(%chg in OI) to google sheet. is it possible?
Not sure.However, you could look into the GOOGLEFINANCE function.
I want to make a load out spread sheet for my Arma 3 (Video Game) unit similar to the 501st version were it has a few images as visual examples and then a list of i teams allowed under each load out picture how would I do that?
which assault battalion do you belong to? I'm from the 212th.
Ayush Dugar I’m a member of the 501st but I own a small group called Bravo Arms I started with BC Jays day that I didn’t have to leave the 501st. Why do you ask? “My clone brother”
Thank you so much sir , sir when i am importing existing xls sheet it is removing all my functions/micros , how can i import my sheet with all formulas intact ??? plz help me.
Macros can't be imported. However, formulas should come into Sheets as they were in Excel. Make sure you upload it and then open it in Sheets instead of copying it in Excel and pasting it into Sheets.
Sir,
We have a sheet in 5 people for deta feeding. But how can I restrict edit cell when once edited. To avoid repeated entries. So please help me
Perhaps those five people should be entertaining data with Google Forms instead. Thar way the data gets into the spreadsheet but they don't need access to it. See here ruclips.net/video/vQw2jDlylDU/видео.html
Awesome that was exactly what I needed... Thanx mate.
This was very helpful, thanks so much!!!
Glad it was helpful!
Hello Sir!
I tried to use IMPORTRANGE() to copy cell range from one file to another
you have shown in this video that in the second argument of this function, sheet name is optional. But when I skipped it and directly wrote cell ranges, nothing comes up not even an error message !!
can you please help me?
thanks in advance
Is the cell being referenced in the first sheet of that file? You could just add the name of the sheet to be sure.
@@ProlificOaktreeFirst above all Thanks for considering and answering query even with your busy schedule.
No, that is an array of cells being referenced and they are in the 2nd sheet of the 1st file that I tried to import to 2nd file sheet1.
ok, I will add a name .
thanks once again
@@ProlificOaktree Its done!
Thanks for such awesome informative tutorials and your wonderful help even with comments
This tutorial was very helpful. I am trying to set up a spreadsheet for tracking investments. I am trying to enter my formulas. When I enter a formula that is dividing one cell from another I get an error message saying I cannot divide by 0. I don't know what I am doing wrong? How do I enter the formula with no numbers yet entered?
I would just leave the error there and plug in the rest of the numbers. Once you have all the numbers, the error should go away.
Thanks!
How do you make it so the scroll bar on the right that scrolls down the rows stops and not go all the way to 500 rows? Like I am only using 46 rows but it still goes down to 500 rows.
Select all of the rows beneath, right-click, delete. To select them, select the whole row, hold down shift and tap the down arrow.
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.
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.
IS there anyway to group spreadsheets together under one header? Have several companies that I would like to create separate folders for
You can have several sheets in one file by going to the bottom left and clicking the plus sign.
Thank you for this great resource!
Glad it was helpful!
Really good tutorial thank you!
Thanks for providing this training
You're welcome!
I've been searching every where for this answer and cant seem to find it. On the spread sheet, in colum 1, I have a list of names going across the top. I have all of them sitting at a 45 degree angle.
When I publish it, they are all sitting horizontally. How can I publish this with the names at a 45 degree angle?
What exact steps are you doing to Publish it?
@@ProlificOaktree File
Publish to the web. And I tried it all and I get that same result. Link or embedding. Then web page and all the different options after, all the same result.
On google sheets, they are on a 45 degree angle, but the published is not.
@@Reaperdkms Hmmm. I don't know what you're trying to do, but maybe you could use the Share option instead and make it available as a link.
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.
Is there a way that when I input number "x" into a cell, another cell will automatically give me the percentage of it? Example, L26 has an input 300. I need cell C20 to show 60% of that number
Sure, put this in C20 =.6*L26
@@ProlificOaktree thanks!!! Worked flawlessly
When I try to replace the black to white, it does the same thing for each line I enter. Why's that?
Great video! I learned a lot! Thank You
Thank you!
Good tutorial on google sheets. Most of functions are covered.
Thanks!
Brilliant work !!
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.
So is this the same as excel spreadsheet?
Similar, but built for sharing on the web.
How to default set a sheet in spreadsheet from many sheet. Please advise
I don't know of a way to do that.
getting tested tomorrow on my excel skills...this is helpful lol
Good luck!
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!