يعد هذا الكورس من أكثر الكورسات التي تحتاجها في سوق العمل وكذلك الدراسة وهو عبارة عن ثلاثة كورسات في كورس واحد أولهم كورس الاكسيل للمبتدئين، وفيه تتعلم الأساسيات العامة لاستخدام البرنامج، ثم كورس الاكسيل التأهيلي والذي يؤهلك لسوق العمل بكافة مجالاته كمستخدم عام لبرنامج الاكسيل، ويليهم كورس الاكسيل المستوى المتقدم والذي يتدرج لمستوى المحترفين حيث يؤهلك للعمل في قطاعات أكبر ومعرفة التعامل بشكل احترافي مع البرنامج.
00:00Peace be upon you, and I welcome you again to complete the conditional coordination in Excel.
00:06We learned together in the previous lecture or in the previous video
00:10How do we specify or format duplicate dates?
00:17Whether the date is today's date, yesterday's date, or any of the options available in the program
00:23We also know how we apply more than one conditional formatting to the same column for our values, whether they are greater than or less than any value.
00:32And so on
00:33Okay, now we will continue together normally. In this video, we will learn how to cancel the formats that we made.
00:41How can we apply more formats specific to the same values? We create icons that distinguish these values, whether they are greater than or less than a certain value.
00:52We know other formats that we can use for the data in a hierarchical way or in a way that makes the data look like we are seeing each other.
01:03First of all, I have the same thing and the same file that we worked on last time.
01:08I want to remove the formats that I had made so that I can start working on new formats, so I will start by determining if
01:15On this cell, I just have to specify it and I tell him to format my badge and scan it for me.
01:21For the rules, here it gives me two options: either I delete it from the selected cell that I
01:27What I am selecting or defining or from the entire paper, I mean
01:31He will delete it from here and there and from any other format. I have done it perfectly, so I will tell him.
01:36For example, erase the entire paper for me. You see, the paper came back white with me.
01:41As it was nice first, we start by making formats according to our data
01:48I have some icons with me, so I tell him to coordinate my badge and make groups with them
01:54Icons Did you give me a set of icons? Are these icons random? No, they are not random.
02:00The largest one takes a certain color and the smallest one takes a different color, and so on. That is, here when I stopped
02:08On red, yellow and green, I find that green has the highest values, red has the lowest values and yellow
02:16Between this and that, it's fine. Okay, I have four colors here.
02:23Outside, he starts giving me the red one, the higher one, and the gray one, which is a little lower.
02:28The lower the bimek the more and the red the least at all. Here are the columns that express
02:34Data. It depends on what we need for our work.
02:40Except for the date media. Everyone chooses the icons they like. Okay, I have them.
02:50Here are other color scales, gradations between colors according to the highest values.
02:55We notice here something that here the gradation is green, yellow, and then color scales.
03:01Red. I find that it is not exactly attached to my column. And that
03:06What does it mean? It means that it depends on the value or the number itself that is present.
03:10It starts with the color, not the shades coming down with me.
03:14From top to bottom in the same way we saw. Okay? Okay, I'll come back here.
03:18The second one is to cancel this tissue. It's made of specific cells. I have it.
03:24Here are ten data. It will also be useful to me, I mean an area of color.
03:30Depending on the value I have, if we take care here, the water
03:34He took the whole area, seventy less. Forty-five less than it and crutched it. Okay, I'll go back.
03:41I have deleted it from the rules. Specific friends. I have a tape here.
03:49We left the data. I have the first and last value and rules.
03:53I have the first ten and the first ten percent and so on. This is the first ten and the first ten percent.
03:57Monday gave me the same result. Right? And the last ten and the last ten percent also gave me the same result.
04:03What do you mean? The first ten percent. If I, for example, made up that she
04:06Students' grades. The first ten means we will tell the first ten who brought
04:12Final grades. He will take it with us 100%. Now, after nine and nine in...
04:18He'll take the water. And so on until he reaches the top ten. Okay? In that way.
04:26For us. Of course, I can make it the first four values, for example. It doesn't have to be the first ten.
04:32Can I change it to green, for example? Okay? I tell him OK. And I come back again. Like in
04:40I have the top ten, I have the last ten, and I have above average. Above average if
04:44For example, let's assume that the grade is out of 100, so the average is 50. Above average, we'll start from
04:50Fifty-one, fifty-two, and so on until we reach the hundred every time
04:54Average. It is also possible for me to give it a color other than yellow. That is, I will start with...
05:02I'll take what I want. I'll tell him, "This is the end of the matter." Okay? I have it.
05:10Below average, we'll reverse the situation. I have additional criteria.
05:14If I sell, if I hide my own dates, I will start by telling him
05:18For example, sorting only the highest or lowest ranked values. Choose, for example:
05:25Which is the lowest, which is the lowest. That is, the last value, for example, the last
05:31Three values. I start to work on it. It takes the color.
05:38Okay? I'll make my line white. And I'll tell him
05:48OK. Mina also agrees. So he starts to apply what I tell him is less.
05:55Three values. It takes the color brown or purple. And the words that
06:01There was a white line in it. Let's do it again.
06:04We set a rule. I'll tell him, for example. Here are additional rules. By the way, rules.
06:10You will find an additional feature in any of these things. There is a possibility that we
06:14We add additional rules. Okay? I mean, I don't have to get them from anything.
06:18As I please. I will tell him, for example, unique or repeated values. And I will choose the values for him.
06:23Repeated. Okay? Its format is like the line, for example.
06:30Mine. Its color is like this. And the packaging is like this. I agree. Me too.
06:40Ok. He starts by giving her the color that I chose, which is the color.
06:47This is travel. I have to remove the rules whenever I want to erase the rules.
06:54I start adding new rules whether you are from additional rules
06:58Here or new rules here. The two of one. Okay? I'll start that I
07:03Choose what I want. Okay? Then choose settings.
07:09Its own and I tell him the format. Okay? I choose the format for the environment and the font.
07:14And the limits, if I want limits. I mean, the matter is in our hands, we can do that.
07:20Shall we put what we want, okay? And after I put it, I tell him
07:24Ok, of course. Here, because I did not enter any value at all. I am here, it is a coordination machine.
07:35The coordination that I mentioned. Of course, it is equal to Musla. Musla, yes, yes, I agree.
07:38Those who agree. Those who agree. Those who have 88 will take the format that I evaluate.
07:40And he takes the arrangement that I told him about
07:43Of course, if I don't format it, it will be left as it is in white.
07:46An easy and simple topic that just needs us to hit on it
