In this election, the sun will help you more connect and improve formula used in engineering and mathematical application. And also if you learn how to sort of do data you should open a Google Sheet. That's what I am doing now. And you can click here on just go here to new can select cheat sheet. This will help what other teams we have hiding Rosen calm Just see how we can suppose you want to hide the color grip Congress in 10 columns and focus on this point and then you will get hide columns. columns that if you can see these when you click on that D has come down and suppose you want to click want to hide two more columns together with like this and how do you hide columns D to D say also we did say hide columns click on these columns CP wants to hear when you click drop down menu what we call this you have to click right click we have to do right click.

So, this is normal usage in the computer application when you are using most of the people they will adjust the most so the right click will have a drop down menu and regular focusing on cells and other things right utensils and other things. It will be left click OK. Now, we will see how we can hide the rows as you click on the river This is called neighbor because these numbers could not change to this is called neighbor. Okay. You click on that and then the entire row is corrected that is guru approved end of the row. It is correctly selected. Mr Then what you have to do is you grid countries then hydro, hydro.

You can click on this. Similarly, you can just see. I will click on this. You can do both rows and columns within Congress. You hide the first ID rows and then you can hide this columns and columns are to be C or you can also click the unhide if you want to comment on it, you can do this one see London in columns and rows protecting the sheet. This is a method where you have some data.

You have some calculations and some pharma. You don't want it to be changed by your co Packer co Packer is one with whom you're sharing the sheets and maybe two people or three people for a number paper you had explained you whom you have shared tissues and all those people are partners. And you want to hire Digi these to protect the T two you don't want them to change the data you want to edit and calculate all those things for yourself. In such cases, what you have to do use then you will see description here you if you want to range then you to click this to select the range ranges, the range that is from selected click continuing to click on to select like this and now you print the sheet. Suppose you want to record I want to click on this, it shows you three g one, you click then you say permission.

See, here you get restrict, who can edit this range only you you can only show the one before editing. That is there are two type restricts you can you can add this range. That means you can click this, then we'll explain you what it means. It means you can edit it is no problem. Okay? Remember, three to G 12 then the person who have already shared that is important.

That plan cannot be edited to put an email address so I want to do one unit Shall we This this if you want you can write some notes here Okay, cricket here. So the message has already gone. So, we just see this exact link was open because the sheet has been shared by that person. So I will open it now Let us I will show you how it works. Yeah, this is the button then here select the C D GG SR because it has been shared is appearing here and he or something like that. You can't see the problems are trying to edit the sheet which has been protected or protected.

So similar to G c G as a process you need not you to look if you're not protected He's not holding these three two, g two or whatever you have selected the V that those things will be the question here cannot shoot the Queen she cannot write here edited, you can share this sheet, but you cannot edit it. Suppose you have another two three people, the same thing is going to happen they also cannot add to the color also will change See, the percentage indicate person is being indicated here. The main winner of this sheet is this person. So, you can only edit this. Now you go back go back to this world This is how you can sue me. See you know how to bring back removal protection that we'll see how we can do.

So there is no segment or site. We'll walk through how do you work of course, click protect sheet in searching. Setting the range you have already set up for me Cancel it means once you cancel it, it shows candidate recon that the person was there. He can edit it. Okay, so we can now go there and see how to edit anything. Come to this this is what should you see the Google Chrome open now we can see To protect only particular sets, now we learn about how to create the entire sheet is also very simple.

Click on that we had the rain we selected earlier in select sheet safety permission to click on pneumonic already there I think so we can just say you can edit you can have a diff Send with him. He cannot hear you. See ya to remove protection to go back know what hear what you have to lose and then you can do it here. Then click on Cancel you will get this box then the demo Once again to be difficult to understand this is a known issue is protected. Okay? Click here to cheat once again once again This is Tom repeating are getting like this is protected.

So you can see then can you click on then you will read this description sheet numbers are there do you feel protected from cells then you have to you have to set otherwise you can just click on this since there are cool people working on one man can protect So, protection Trying to understand and once you start using it, then it is easier for you to follow. Okay, now, we've worked through that since using the software to data data I will come What role she plays. Here you see too many. Suppose you want to start from here and say addition it It goes great to see you just see 1938 you can remember the 19 second how to changes see 1934 that is the first one that is in the ascending order the two segments which is turning 1934 3859 suppose you want to solve with descending order, it is Zack Do you know your si?

Si, come see me Lisa, we can talk on unity can focus on that particular column like this. If you want to start this recon data, first you have to focus the port now I'm focusing on V column. So we want to start it off to get to that which is numerical, it will do ascending order is set to a numerical subject. It will do the same Okay, I focused on V. Now a good contractor. And now I click on this. Yes, it is the first one minus 230.

Similarly, we can do that we're going to solve coconut. So, no you see how it was like alphabetical focus on that. See this main one is the ad, not selecting the ad at some level it remains there only one year starting now. Or if you click here, if you take this, then all the things below it is sorted. So, if you click here, all the thing below it is sorted. Oh, so we this is entities, Edie?

You're sorting all the things below hot countries, the host country This Okay, now we'll see how we can start to see first year earlier to or not, you know most countries click on Yes, because it's working from there are charting slightly different than Excel To select a sheet, which no have selected the sheet No, no. Yeah, the salt range did not highlight it, you cannot click on this and select one to select the sheet, intake sheet, or upgrade suppose you want to start up here and if you select the entire sheet in our case we'll select this. And now you can see here, sort range you get. Okay, this last week you click on this. Now gospel data has added Yes, we have 32 now, so if you don't have either if you don't click on this Just a column suppose I will just show you how it does run quick like this.

Then it can all come to last. Yay numbers will come and then yeah did come last. You should have that what you do is undo it. Once you do this each row click on header row we have then you click it then it is sorted like this. See started with column A. This is what the data is in addition, the address is there on the show you want to get back what you see now it is 2014 can you said anything touchy you want to know to click on this search range, click on header row that is possible it will leave first row and then remaining it like this this is from Colombia.

Suppose you want to start as cold column B as the main thing and having a header row Yes. Then what you have to do select the short range and this column you select B now, you say similarly, if you want to select here numbers A to Zed meet attendee, just select suppose you want to select from here. See, then what you have to do is select select here, select instead of column C you should We have to click in the row all the time. We do not see you have to click here. Then you click here, which one you want to or you can click later on also. column C header row you're good.

It shows the first one starting start from there to select a saw, he can see us mean that if you want possibly karada to set something like that He is simply the heading if you said but yet was selected you can select on that good to know suppose you want to sort by this V cost you have to select the intake sheet as data goes to Winner, winner is the data, registration, whatever you select your winner, certainly with all of the things will be sorted that is a gentle nice posture. All the data have led to our printer will come Get a tuna all I think this year 98 1986 cups more like this. Suppose no offer this. So we want to talk number average average value what you have to do can click here at the highest to submit, ascending. I just came for 20 I mean we're just came up with the same thing you want to solve in descending order this is all we carry.

I hope you're getting a little bit tricky, but you can do sorting. Once you can see there are other methods also, Cookie consulting. I will show you suppose First you want to start by header next you want to sign Yeah, just see ya. The table is big then only we can do three types of sorting that is washed visible and then I can just suppose the two twos are here apart. We'll just explain that to you. You see, one more time this will be sorted alphabetically.

How we can do it has to be taken up in 1930s 1933 countries, France and another country nearby Samia, then it will come over here for single one you won't get. So here we have a table, we can insert tables or temporary keys Not taking this common number the 1930 years it comes here we came together which will come when do you suppose 1931 this was countries once again and then it comes to the next to that See here twice, okay. We did in 1957 14 says become Brazil. Here it is attending Brazil is 1950 and 2014. But you want to come 2014 that is this column should be descending cost, you click on Brazil, then this columns descending then what you have to do is to click here, click on this, you're already shot at this Edison bill, which will change what country Brazil has come another UK yet UK euro debt not ascending descending normally See just change Brazil, Brazil is common and crucial 14% came and then 1915 and if there are Brazil is for many other years and indicators on key like that.

In France also see function came twice per tier Auto 1919 1930s Germany to 2019 some people this year also interview also dissenting while you are wondering once I will show you once again suppose we started what country under one minute keep it yeah to said that this is also attending alphabetically, ascending 14 first, and then this is good in one country So this is all we can do continue next class