Not. In this session, we shall learn how to use Google Sheet with these grants located in Google Chrome, which is internet web browser key. In this lesson number one, I call this Google Sheet by multiple names, program, correct sheets are an application in all these places, which is understood that I am referring to oversee the main prerequisites for running Google ci is basic understanding of computer peripherals like mouse, keyboard, monitor, screen, etc. And also, you should know about the pilot manner event. This program useful for a cadet machines, professionals, engineers, scientists and business people are on things when doctors are also used for day to day expenses by housewife in this rendering which are concentrate more on engineers usage now I will open lesson number one what are the subjects to Lesson number one lesson number one, we have one random a new boss or means albinos explained ribbon and each functions defined area defined rows and columns, defined cells, adding new rows columns to the sheet, shape sheet, getting help explorer from from the explora internet internet, insert comments in any sense Please listen.

Now first, let us know how to open the Google Chrome. To open the Google Chrome, you will need to click on program. And there is a program Google Chrome can open here. Also, Google Chrome icon is available. Desktop is installed in most of the desktop. And you can click, double click over that Google Chrome and it will be walked by now.

You can open the folder from here by clicking on this directory or here. No, I just do this by clicking on here. So no open. Chrome is open and you need to specify for each product one concern person here. I needed not a general sheet for everybody. And now what we do is we are going to click On Google application, this Google application consists of various programs.

Okay. And if you click on that, there will be a drop down which indicates various programs and also the name of the person who are using these things. Okay? This is a counter a person, that is who uses search, you can go to such maps, you can use. You can play YouTube by clicking on that, radio and news you can read mail, you can email, contact, various contacts you have you can find out the contact and news and Google Drive. This is what we have our program is locked we are interested and our program is created here.

And we have many other things like gathering data transmitted or cross shopping you can also do and there are some more things like Document books. It should have logger. So I'm going to teach something. Now let us concentrate on right, we have to click on Google Drive. We open the Google Sheet, we click on this we get a screen like this. The screen has many icons and program located as shown here.

So many things are located here. These are the programs that have been uploaded from the computer to the Google Drive. So these programs can be open when you are traveling and see some report and rates or anything on your mobile. So it can be opened by clicking on this meeting can be opened any programs you want to open click on this one click on this documentary opens. Okay, is how we can move on the gun. programs.

And now what we are interested in is open the Google Sheet, click on new, and we will check various others. So proteins upload. Upload means take a file from your computer for that the complete folder can also be uploaded from your computer, or from any break. I definitely more by use the program support and Google document. This is also another program like sheets. And then Google Sheets, Google Slides, the like a slides show.

And then Google forum. There are some drawings also that escapes you can prepare Google Maps on their website or their uncle drives. You can you and UW drawings also you can you do a lot of back and forth anything except extract We are concentrating on Google Sheet. And before that I will briefly explain how it is compared with Microsoft program. There are two documents, Google documents, programs, I mean our document program, Google documents, Google Archie, these two programs are compatible with Excel, my Excel program, and also word program that is an Excel and Word program. The Microsoft program, Google document is very similar to MS Word and Google Sheet very similar to excel.

What do you think is the location and the function and use as a function is slightly different? Okay, now I will open Google Sheets now. Explanation click on that Google Sheet Google Sheet Do open his untitled spreadsheet name his untitled spreadsheet know if you want to rename of your choice, click on File rename and you will get here and you can take any specific name or any specific name then it is the spreadsheet is inactive Okay. Now as you can see the spreadsheet which is very similar to Microsoft Excel and it has rows and columns similar to excel the one which is moving horizontally score rows when it is moving vertically like this. That means various lines are drawn in permanent lines horizontally and even new vertical lines are drawn and we will fall in itself. This is called a rectangular ocean.

Yeah, this is a set He's another exit video search on there. Okay. Now, the columns are the rows are named that 123456 like that. And the columns are roll, yay, B column, C column, D column, etc. Like that. Now, if we want to this is one check if we want to add a sheet, you have to use an icon.

When you add a sheet, you click on this sheet is added. If you want to delete a sheet, you just click on the Delete. Okay. Suppose you have some data on there. You don't want to delete by a clip you are corrected it asked you or if you want to see and cricket anything. Now that's how we can add any number of feet.

Okay. They just one Once again one by one. You have duplicate widgets or duplicated copy, you can copy this new like sheet of existing, rename, you can rename it, change color, you can change the color of the sheet, the cheat sheet on how we do stuff and for many things, you know, the next movie let us know what are the five minute or here this is a vitamin C hearing Google Sheets, sheets can be saved shared with somebody else. That means suppose you are in your place say you are in Bangalore and you want to share a sheet the person in Delhi. So what you have to do, you will have to click on this. Then enter the email address, you can type in gmail.com you can choose the sheet.

That is how we can once again enter the email address, and then you can click on the email address and the GG is shared. That means, that she can be seen by a person whom you have addressed here. So you wouldn't do it. I think she can be seen there. And another advantage here, Google Sheet is that what have you, that is the person sitting in that room, the person who asked to share with you can enter the value Cindy. You can work on this sheet that using the sheets can return the values or text on the sheet, or you can work on the sheet, any formula, anything you do.

Together, this is how Google Sheets sharing and working explained to you know, next week, um, you know, you can open a new document or spreadsheet you can open if you want to click on that new spreadsheet is open. And if you click on that existing spreadsheet you open it use your various sheets available here on the Google Right Google Sheets out there and if you can this you will get a menu like this. So many icons here and you can name this sheet or you can click on the special treat you want the titles are given year. names are given, everything is given yet, so you can click on click on that will shoot like this shoots up. Okay, this is how we can work with the opening the sheets. In opening the sheets.

I'm flipping the new sheets means it can be document. documents can be open like this, which is just a document I explained you easy water Word documents exactly similar to Word document, but this is called as Google Doc. You can work here like working on radness how to work here by looking at the command or by Getting it. Now, then you can close this worksheet. And here open import, you can import any type of you may or Graham's using you can click on that, you will get an import and video you can import process we can import this you can do anything. And you can also browse here, share it, we can import upload, upload means you can import from it from your own computer.

If you click on that you get and then you can browse it, you will get the sheet so you have to go ahead and open it what you see is that when you click on this select from the file that you wanna fight me What are you gonna keep one and then You can select anything you want, like this Like this any recent she shared with me was your that also you can have and then drive my drive you can open anything. Click on focus on that you can import the sheet or create a new spreadsheet, create a new spreadsheet, and then the data is taking some time. It's a cheat sheet, make a copy, you can make a copy of this president cheat. We can copy like this. Make a copy of this and okay You can be sued on your word, okay? I would like to do ironical tissue.

So one beauty is this don't sue me that one once you open it and maybe like I want to get input here that everything will be automatically saved. So all you every step of the way should be and there is no other method of saving here is an Auto Key. So that's why you don't have anything as Save as a save or anything like that. So click Save As, but you have to make a duplicate. Make a duplicate copy and name it's by different name. Okay, make a copy here.

Name it, name as you as you like. You can change the name or any other Okay, so I'm happy to read that now. That is how we can that is how we can use Save as function in an email attachment you can do whatever you want you can you So download as Excel, you can download the programs from Excel program. If you click on this one Excel program can be opened mostly by whatever program you want to have. You just you can see so many programs available then you can automatically see this is one program like that you can walk on walk. I will open and connect one.

I mean open this See, suppose this one This will ask you do you want to replace it will be replaced. Click on that replaced by this can you want to say this too and this would be zero. Click on this water block and you can click on this. You want to water blocks waterblock will replace by this So this is all we can work on. And you can also you can also you can also download upload excel sheet. So the action sheet cannot be opened directly Excel sheets just acts when you open the sheet on to institute an Excel sheet from Microsoft that is on your computer cannot be opened here unless you upload it you don't want to have done have shown us this present she is saved as Excel sheet on your computer.

Suppose I what I what I did was I clicked on this drum roll as is if I click on this what you shows you the program I suppose a quick as this then this wall block dash conclusion, exit exit will be saved at CCC not exit. Okay, sheet that exits here you see over there as exit. Okay, suppose we want to get a excel sheet on your Google Sheet what you have to do you have to click then upload a file and you upload it. When you upload a file there is a it shows you various files in your computer directories are open and select any directory you want. You can open click on this open Google Sheet that is it will be present on the Google Sheet. I see by example.

This was going on recondition is completed excellent. Yet this you can. You can you can download it but actually there is no problem you can open it. Sheet open with Google Sheet Means, a sheet which you have already uploaded has to be open open which we had to open with Google Sheet. The same sheet can be downloaded somewhere else also. See suppose here, download can be downloaded or you or some other direct you can click on.

So now define sheet sheet is defined Grossman Columns self define these things by name. Yeah. So, this one is called game one, this is the year one, this is this one should not be the one you want to believe you can see. Similarly, this one this Sunday like this, I can like that. See the sheet has only so many rows Suppose your calculation requires more rows than you click on this and you can add this shoot in second column is not an issue, but it is inserted on a set like this, you will suppose you want to insert one more record on this, insert a column. This is our columns and when you want to delete a column remove the columns.

Delete the column in the column. Suppose you want to delete a cell delete cells represent the rights and what are left and Jupiter Lee The rows also can be added. Here you can see you read a column, insert a row, very similarly, you can insert anywhere you click on that insert and row. And it is also possible to insert a sector by clicking that oh, this is double explaining how to insert rows and columns extra added he's adding sheet rows and columns to shield the sheet I have explained you getting help from the Explore getting help explore my right my while you can explore from my right My Documents right? That you can see that you can cheat help training and use upgrades you can provide so many functions a function is present. Usually this function can read and understand how these examples are given.

And this is how I help you get from other programs. And now what else we see freeze rows and columns. Yeah, no, we haven't done this. While at binary basically, you can undo redo once again bring it back and add the remote, copy, paste, question, find replace, delete values, delete rows in each column, remove rows, etc. So I'm doing some messaging. Suppose you want to avoid you want to bring back assuming suppose you want to cut it and you want to quit somewhere once you can at least hear something suppose you want to have RP, RP this Copy here and this is the extreme case values only format only that you finally press Delete value suppose you want to delete values suppose here you want to delete column D whatever the Rename column is really further removed from here because that column is removed but the name is there, but whatever matter is there in that column.

Suppose, we have like this I'm just explaining what we mean by deleting suppose you want to delete this column and then what you have to delete column Yes, this column the actual name remains the same by the president you can just call him if you really all value saga okay similarly Ross often can delete sense and shift up sense can be duplicated regions and shift left Korea north. Thank you. I'm suppose you have some I know you can do one particular angle like this And values you can do this result instead Listen, you have to define what is your take on it yet you right the cell has a comment, see here this is a comment the definition of what is this or what? Whatever like that you can comment. You can replay that comment Suppose you want to read a comment you can see once again here or you can comment you can read next lesson number two next to see Thank you