Learn all of the basics of using Google Sheets. This tutorial covers everything that you need to know to start using Sheets.
– Start – Creating a Sheet
– 4:58 Format your Sheet
– 13:14 Use cell references
– 20:39 Create formulas
– 26:56 Sort and filter
#googlesheets #spreadsheet #basics
Nguồn: https://wakeakpsi.com/
Xem thêm bài viết: https://wakeakpsi.com/category/cong-nghe
15:06 how did you get the formula to show up like 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?
https://www.youtube.com/watch?v=vg8gZ_mbiaI
how to lock or protect cells after data entry or input in GOOGLE SPREADSHEET (AS WE DO IN EXCEL USING VBA PROGRAMMING )
Thank you so much for this !
How to create filters by color in googel sheets
You Explain each and everything very greatly,thanks
Google sheet is very easy and fast working
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.
What a great tutor you are! Thank you.
When you did the cell references. I couldn't get the number for the Operating Income. It's telling me to go to the spreadsheet settings for the calculation. I don't know how you got the number for the Operating Income.
How to run scripts on iphone ?
Excellent! A+ Tutorial.
Thanks for providing this training
Great tutorial but didn’t find what I’m looking for.
My source gives me data In Minutes:seconds and but it always treats it as hour:minute even when I set the format to Minutes:seconds it just adds a :00 to the end and treats it as hour:Minutes:seconds hiding the hour. Example Don McLean – American Pie-8:33. If I put this into a table instead of the duration being 8 and a half minutes. It would automatically say that the song is 8 and a half hours long. Does anyone know how to resolve this apart from changing everything everytime I pull the data.
Can I set up an import range of future data that will import from another sheet every time that sheet is updated?
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?
Thank you very much.
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??
The birds in the background was a nice touch
This video has just rescued my work life. Thank you sooooo much!
you speak so slowlllllllllllyyyyyyyyyyyyy like that
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! 🙂
thank you for your instruction
No mention of formatting (to margin) Header and Footer, not exactly a "full tutorial eh sailor"?
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?
Hey
LOL this is so long thats what you need to improve on
Its counting in millions except from thousands like i want it to.
really hopefull thanks alot
Wonderful tutorial for quick start-up!
Thank you so much! My business class didn't even teach this !
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
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
How to find out who access my spreadsheet and also a single sheet in it
Another bad example of the Sheets software now is the difficulty in making a simple chart. Say, the bond yield over consecutive weeks. It makes columns for the weeks rather than setting them as notches on the x axis for a graph, so you get two columns; then when you try to graph the line, it makes two lines. It's like they can't understand the simple chores you need to do. It should make one line with the weeks as the x axis number line. Gosh. They keep it all hidden and most arcane.
The edit functions on Google sheets SUCKS! It's designed poorly. Simple things like editing column width are too hidden when they should scream at you with simplicity. And it's easy to lose data and not be able to retrieve it. It's frustrating to work with. Google engineers dropped the ball on making this user friendly need to get with the program!!!
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?