Google Sheets – Full Tutorial

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


Xem thêm bài viết:

31 thoughts on “Google Sheets – Full Tutorial

  1. 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?


    how to lock or protect cells after data entry or input in GOOGLE SPREADSHEET (AS WE DO IN EXCEL USING VBA PROGRAMMING )

  3. 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.

  4. 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.

  5. 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.

  6. 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?

  7. 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??

  8. 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! 🙂

  9. 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?

Leave a Reply

Your email address will not be published. Required fields are marked *