التحقق من صحة البيانات في الاكسيل - تاريخ - video Dailymotion

Shereen Elmasry

يعد هذا الكورس من أكثر الكورسات التي تحتاجها في سوق العمل وكذلك الدراسة وهو عبارة عن ثلاثة كورسات في كورس واحد أولهم كورس الاكسيل للمبتدئين، وفيه تتعلم الأساسيات العامة لاستخدام البرنامج، ثم كورس الاكسيل التأهيلي والذي يؤهلك لسوق العمل بكافة مجالاته كمستخدم عام لبرنامج الاكسيل، ويليهم كورس الاكسيل المستوى المتقدم والذي يتدرج لمستوى المحترفين حيث يؤهلك للعمل في قطاعات أكبر ومعرفة التعامل بشكل احترافي مع البرنامج.

Transcript

00:00In the previous video, we created an entry message so that the employee knows what he is supposed to enter in this field.

00:06We also made an error message.

00:08Ok, in this video we will learn how to remove the input message and remove the error message.

00:13We also start by verifying the validity of the data if the data is a date.

00:20Come on, let's see together how we will work.

00:22One of the second columns that contains the data, if I want to change my color

00:27And even I tell him here to verify the validity of the data

00:31I will go to the entry message and delete it completely

00:36And the warning and its response, I will remove it

00:39I will tell him the right thing to do

00:41So it enters and no message appears, nor does the error message that I had set for it appear again.

00:46Ok, very nice

00:48Come on, let's see if we go down in history how we can deal with it.

00:52First, I can go to the main bar

00:56And I started to threaten him that the type of data that he enters is any data that is a date

01:02I will tell him, for example, a short history, not a long history.

01:06And I will return again to his data. I will tell him to verify the validity of the data.

01:12But my wife, I will tell him in the settings, what? Make it history.

01:16Ok, my date might be between two specific dates or it might be greater than a specific date.

01:22I will tell him, for example, what is between

01:28Tartasher seven thousand two hundred and twenty-three

01:36Sixteen thousand seven hundred and twenty-three

01:40Okay, I'll tell him okay.

01:44What kind of history is this? What can we see with it?

01:46I will tell him, for example, four and seven, two thousand and twenty-three.

01:52I'll take it normally

01:54I will tell him, for example, twenty-nine thousand seven, two thousand twenty-three.

01:58He will start getting upset now and send messages

02:00It remains the same as what we did with the rubble.

02:04We can do it with history

02:06The only difference is that we change the format

02:08History means we choose

02:10And make you forget where

02:12Ok, very nice

02:14If we pay attention to what I have here on the system

02:16My history is a day

02:18Month of the year

02:20If I came to enter history here

02:22My month, day, year will come out with me

02:24Aero will come out intent

02:26The result is not correct

02:28We take into account that I am history

02:30Mine is here like

02:32System history formatting

02:34Day Month Year Wider or

02:36Month Year Day etc.

02:38We try to make him like him

02:40So that the result does not come out wrong with me

02:42Come on, come closer

التحقق من صحة البيانات في الاكسيل - تاريخ

Category

Transcript

Recommended