يعد هذا الكورس من أكثر الكورسات التي تحتاجها في سوق العمل وكذلك الدراسة وهو عبارة عن ثلاثة كورسات في كورس واحد أولهم كورس الاكسيل للمبتدئين، وفيه تتعلم الأساسيات العامة لاستخدام البرنامج، ثم كورس الاكسيل التأهيلي والذي يؤهلك لسوق العمل بكافة مجالاته كمستخدم عام لبرنامج الاكسيل، ويليهم كورس الاكسيل المستوى المتقدم والذي يتدرج لمستوى المحترفين حيث يؤهلك للعمل في قطاعات أكبر ومعرفة التعامل بشكل احترافي مع البرنامج.
00:00Peace be upon you. Welcome to a new stage of the Excel program.
00:04In this stage, we will learn together about a group of commands and settings that are a bit more advanced than the commands we took in the first stage.
00:13We will start together with police coordination.
00:15We previously discussed the normal formatting. How do we change the colors of the empty spaces, the font size, and the data type, etc.?
00:22Now we will do a slightly different format called conditional formatting, which, as its name suggests, depends on a specific condition.
00:30Meaning, what should I say? This is a format for the cell if a certain condition is met.
00:34Ok, if this condition is not met, it will not receive coordination.
00:38Like what, for example, here I have an example that we will work on with a group of random student names and the grades they received.
00:47The student is supposed to get a grade, and for example, I have a sheet with a lot of Excel data.
00:53I need to know which students got, for example, a score of 90%.
01:00Or who are the students who got excellent grades, who are the students who got very good grades, and so on?
01:05How do I do this? Come on, let's see together.
01:08Here, for example, in this column, I have the estimates.
01:11I have to decide on it
01:13I will make a very normal selection or on the entire column from above so that I do not get embarrassed if there is a lot of data
01:19Ok, after I specified them, I have a tab called the main ribbon.
01:25I will find you a police officer
01:26There is a small arrow in it, which means there are still settings inside, not just one thing on the outside.
01:32Ok, I will click on the small arrow and it will show me a group of things.
01:35First of all, the cells are differentiated.
01:38It is written here greater than, less than and equal to
01:41Ok, what is greater than, less than, and equal to?
01:44It makes me differentiate based on the value of the number that is there.
01:49Is it greater than a certain value, less than a certain value, greater than and equal to, etc.
01:54Okay
01:55So I start by pressing and telling him, for example, I want something greater than 90%.
01:59Okay
02:00Here it is bigger than and I will write to it 90% and here it gives me a random number, seventy-two and a half. I will make it ninety.
02:08Okay
02:09I see it automatically before I tell him okay
02:12It started with their work for me in red.
02:14Ok, no, I don't like the color red.
02:16I will start by choosing from here, for example, the green filling, okay?
02:22Ok, I don't like the green filling. I'll see with yellow. Is it not my city except red, yellow, and green, with a difference in the color of the plan or the words inside?
02:30Ok, very nice. I don't like the red, yellow, and green. I want my own colors, depending on how you make me forget the devil himself.
02:38Press
02:39And I started telling him to forget about the special
02:41Okay
02:43I chose the font color I wanted from it.
02:47Here I have all the settings that I make on the line from outside
02:52Okay
02:52If I want to change the type or style of the font, etc.
02:56I don't want to change the style or anything, I just want the fill color
03:00Okay
03:00Cell background color
03:02For example, it is orange in color.
03:06Okay
03:07Okay, if I don't like all these colors, I can tell him additional colors.
03:11And choose from here the exact degree that I want
03:14Okay
03:15I choose based on what makes me comfortable. For example, she chose this amazing color.
03:20And I start to tell him from here I agree and from here again I agree
03:23And I agree
03:25He starts to give me the orange color on the grades that are higher than 90%.
03:30Ok, I want my opinion. I want grades that are less than, for example, 70%.
03:37The second one, be careful. I will leave the first selection or leave the first color, I will not remove it.
03:42Okay
03:43Haji in the coordination of my badges
03:45Okay
03:46I will tell him again that I am a woman who distinguishes between men and women, but sometimes she is younger than him.
03:50Younger than
03:52Less than 70%
03:54I want it to be green, for example.
03:57Ok, I will tell him I agree
04:00Do you see what he did?
04:02Its green color
04:04The orange color will be the main color, meaning that it will apply more than one of the two chevrons together on the same column.
04:10Ok, and as you can see, he applied more than one badge layout to me on the same column.
04:15KIM Institute
04:16What happened down here?
04:18What happened is that the empty cell, Lil 1, turned all of it green.
04:22Ok, I didn't divorce you like this, I want you like this
04:24I want the cell that has orkombos in it
04:28Tighten the cell that has orkombos in it
04:29Ok, very nice
04:32When I specify the cell that contains orkombas
04:34It is printed on it, okay, from the percentage of the cell under the air, why did they stay there anyway?
04:37Even though I will never cl
04:39It is more appropriate to expel the value of the cell that Maryam has data for, which is 0.
04:43If it is zero, it is less than seventy.
04:45So he will start to print on it the second condition that he is less than him
04:51Very beautiful
04:52I'll start with one of the second
04:55I have the police coordination
04:56Of course, above, as I have, bigger and smaller than it
04:59I have between and equal to the text included
05:02Okay, as for the duplicate date.
05:04What is the repeated history?
05:05Because I have a start date, for example.
05:07Or should we assume here?
05:08For example 23
05:10seven thousand twenty-two
05:13Okay
05:14Here is any other date
05:17Seven, for example, eight thousand two hundred and twenty-two
05:20And here again
05:2123 seven thousand twenty-two
05:25I have this, the date is repeated
05:27I want you to specify the duplicate date for me.
05:29I want to specify
05:31I will tell him about the police coordination
05:33Duplicate date cell marking rules
05:36Okay
05:37Here he gives me a lot of choices.
05:40yesterday, today and tomorrow
05:42In the last seven days
05:43And last week
05:44And many other things
05:46For example, I can tell him today's date.
05:50Okay
05:51Today is something completely different, of course.
05:53I need to change
05:54It remains a yellow text
05:57I tell him to leave
05:58Of course, this is the current time when he will not do anything
06:00I finally let it be today's date
06:02nineteen
06:04two thousand twenty-two
06:06Do you see the first history material today?
06:09He started to change her
06:11Okay, here I will also write nineteen
06:13two thousand twenty-two
06:15It seems to be determined.
06:17Ok, I'll come back again, police coordination
06:19And he tells him a repeated history
06:21Leave it like this
06:22this week
06:24And agree
06:26You see, he will do it on the same dates.
06:28Because today is not the same this week
06:32Okay?
06:32I change the color to green
06:34I stay here, I have the rules. The beginning of discrimination is in many things.
06:39Can I use it?
06:40For example, duplicate values are possible.
06:42Here it is
06:44I will go back to her and tell him
06:46Rules for distinguishing duplicate values
06:49Can I choose that the interest values are what will be tomorrow?
06:54Take a color, for example, yellow
06:56It remains the same as what I did in the first column, that I used more than one conditional formatting rule on the same column.
07:05So we have taken the first thing in the easy and simple police coordination
