Hello, everybody, welcome to the second dashboard. In this video, we will see how to create an experienced group. Let's say we have a data set which has an experience requirement. So if we filter down we could see a group set 0.51 1.5 and many more, which goes up to 40 years of experience. So we wish to create a slab over here based on the requirement like maybe zero to five five to 1010 to 1515 to 20 and so on and so forth. It may be equal or may not be equal.

So depending on that, how do we create a slab using the existing data is what we are going to see. So first, let's come into our currency and I'll name this sheet mapping sheet. So, this will be the sheet which we will be using to map our entire data with the dashboard like the one we just did for currency. Now to clean up the appearance, what we're going to do We are going to group this. So to group a set of particular columns or rows, we just have to select the entire column or row under data tab. There's an option that says groups just click on it and the group option that will in turn place the data into a single group, we can see small minus symbol that will actually collapse the data.

Once done, it automatically shrinks the data. So just for my understanding, I have created a gap of one column colored light blue, which makes me understand that this is a partition that I've created for bifurcating the data. I'll do the same for the second one as well. Data grouping that should do it. So now one set I have the currency which is getting downloaded from the internet and the second set which is actually converted into a table for my calculation purposes. Now we're going to create a third set and the third set will be the slab group.

So first I'll say experience and then next the text slabs. So a person with zero experience will go into missing and that is no experience will be provided. So I'll just zoom in. For this we have to mention the first variable as a pure number. The second variable that is slab as alphanumeric characters. This is something which we'll be using v lookup.

I'll just complete this particular slab and then I'll get back for V lookup there are some parameters that were already aware of that is the first variable should be constant, it should be unique. Now there is one additional criterion as if we are using true as a parameter the criterion is the data that we have to use as a base should be sorted in ascending Order. In just a few moments, we'll understand why. Now first, let's do the formatting. Now do remember I put in at point 001. And that means even one month of experience is considered under zero to 10 years slab category.

And if a person is put zero as experienced, then the experience is missing. Just select this and convert it into a normal number using Ctrl Shift exclamation mark. I'll name this experience lab. And once done, I press Enter. And there it is. I simply copy this format and paste it after as it's a divider for me.

Once done, let's use it in one of the formulas. So here are the experience inputs. This time I'll be using v lookup to do so I'll use equals v lookup that is vl and tab and we can see it's getting overlapped. Just use the left arrow and the best option might be let the formula v lookup in the formula bar. So v lookup select the value or j can be constant is not necessary that constancy has to be applied it is just for the sake is in case by using the formula after copying and pasting it. Then experience lab now I wish to have the second column as my answer.

And this time rather than going with a false attribute we'll go with the true attribute. Now true attribute is where we get the appropriate or the nearby slab answers. So as we press enter, we do get missing slab. Now if I drag it down and check with the filters, I do have all the slabs ready with me. If I filter down any of the parameters based on the selection that I have done, I do get the relevant answers. And now I'll just complete this part for the rest of the sheets as well.

In the next video, we'll see how to get the quarters using the same concepts till then keep practicing. See you in the next video. Thank you