يعد هذا الكورس من أكثر الكورسات التي تحتاجها في سوق العمل وكذلك الدراسة وهو عبارة عن ثلاثة كورسات في كورس واحد أولهم كورس الاكسيل للمبتدئين، وفيه تتعلم الأساسيات العامة لاستخدام البرنامج، ثم كورس الاكسيل التأهيلي والذي يؤهلك لسوق العمل بكافة مجالاته كمستخدم عام لبرنامج الاكسيل، ويليهم كورس الاكسيل المستوى المتقدم والذي يتدرج لمستوى المحترفين حيث يؤهلك للعمل في قطاعات أكبر ومعرفة التعامل بشكل احترافي مع البرنامج.
00:04Of course, it does not have to be text data. It can also be digital data.
00:09But we will start by checking the number of letters, symbols, numbers and spaces that are included in a certain blank.
00:18Let me explain it to you in a slightly easier way.
00:20For example, if I have the entry for the full name, which is the three-part name
00:25If I leave it open, he can write my four-letter name or he can write my five-letter name.
00:30It is possible to write "listen to a lot of vehicles" or "Oh", so the subject will be very crowded and noisy.
00:35I can specify that the entry does not exceed 30 empty characters.
00:42Okay, so to do this, we start by using data validation.
00:48For example, on column H
00:50I will tell him to check the validity of the data
00:55Who will enter the times, what is allowed during the text?
01:00The length of the text can I tell him that it is equal to
01:03For example, ten is perfect
01:08He said to him, "Okay."
01:09I will write to him, for example, Sherine El Masry
01:15He wants to tell me what suits me because here Sherine has five letters
01:21There is a space after that and the Egyptian also has five letters
01:25Ok, I will tell him to try, I can remove the distance
01:28By the way, the distance is also calculated as if it were a letter or a symbol.
01:31Ok too
01:34Oh, here the Egyptian has six letters and here it has five, so there are definitely ten letters.
01:46When I removed some letters from it, it started to pronounce normally.
01:50Ok, very nice. I will start by changing my condition.
01:53I will tell him to leave it as long as the text shows two numbers
01:58Shown for example, ten and thirty
02:04Or leave it at twenty, that's enough
02:08I'll say okay
02:09Here is Sherine El Masry
02:13You will write normally
02:15Mohamed Ahmed Mahmoud
02:20She hasn't turned twenty yet
02:24Egyptian remains
02:27He starts sending me a message, so I start telling him what to say.
02:32Cancel the order
02:33Ok, so now we know how to use
02:37Data validation with text data
02:41Or the digital data that we want to specify a specific length for.
02:44Here we use it to determine the length of the letters, whether they are capital letters.
02:50The spaces symbols are also considered as an element of the elements that entered my cell.
02:55Okay, maybe the employee doesn't know that we have to enter a specific thing here in the entry
03:02Every now and then, a message pops up for him. He doesn't understand what the mistake is.
03:06Can I send him a message so he understands what he is supposed to do? Or of course it is possible?
03:12What should I do? Should I tell him to verify the accuracy of the data?
03:16But this time I tell him to enter the message, please enter
03:25For example, a name with a length or number of letters ranging from 10 to 20 letters is fine.
03:40And I will tell him, “OK,” and the employee will come. The criminal will stop the employee from entering the cell. Then I will tell him, “Please enter a name ranging in number from 10 to 20 letters.”
03:52Okay, very nice. Not only that, but when he does something wrong, a message will appear telling him what the mistake was. I make everything easy for the employee.
04:02I will go back to verify the data and tell him to verify the data
04:08Khalil, this time I am pointing out the wrong verse.
04:11For example, this field does not accept names with less than 10 characters or more than 20 characters.
04:30For example, I mean, can I put the message because I want it?
04:33He comes here and writes to me, for example, such and such.
04:36What's the matter?
04:40He will also tell him the same message here because what did you say?
04:44The topic remains easy and simple. I can specify the number of letters, numbers, and symbols that I want.
04:50Can I put an input message? Can I put an error message? I'll try it.
