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

Shereen Elmasry

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

Transcript

00:00And in time it comes with the video they wait for and love.

00:05I personally prefer it very much

00:07Which contains the explanation of the list of data

00:11As you see it

00:13The subject is easy because it is very compressed in the cell

00:16And take my data

00:18I choose what I want from it without a letter office

00:20I mean I hope

00:22We can do this easily in Excel.

00:25Or we can do it in a very easy way

00:27It doesn't get any easier than this.

00:28We don't see each other

00:30If I like to have a set of data

00:34It will be like this

00:35I can choose what I want from it

00:38Or I let the entry employee choose what I want without writing anything

00:41I can have the list clipped anywhere.

00:44For example, let it be something like this

00:46We would like to inform you that these are the names of the employees who carry out the daily operations.

00:51I write their names

00:53And I started using them on the menu.

00:55For example, if I choose this list, it will appear.

00:58For those who enter data, it will appear in column I.

01:01Okay?

01:02I tell him to do something here to make me forget or to do something here to check the data.

01:07We enter the data verification data

01:10I tell him what is his value to me?

01:13Okay?

01:14Okay?

01:15Where is the source list? Click here.

01:17I go and specify the data I want

01:20The first thing I have is the data written in a place to the side.

01:23Of course, it is preferable that it be far from controversy so that it is not visible.

01:28Then I select the column in which I want the data to appear.

01:33I told him I want data to verify the data integrity.

01:37When I tell him I want a list, he tells me the source is there, so I learn here and go choose the data.

01:42Okay? After I choose it, I tell him "yes"

01:45Look, connect to any cell.

01:48What will it show me?

01:50I will choose from these employees’ data because what do I want? Shaimaa, all of them, Shaimaa

01:55Leave it to someone else

01:57Because all the employees are asleep, meaning only Shaimaa is the one who gets bored here

02:02Good, beautiful, very strong

02:04How do we take it together? We will carry it. I will teach it.

02:07And I go again from the data verification data

02:11Why do you leave it as a valuable verse?

02:13I tell him, "Okay, so what?"

02:16Value comfort and for the data entered, I will remove it normally

02:20Or I tell him from the main tape what does it do for me?

02:23Erase all or erase content only, because I want to forget, it is better

02:27Ok, I will do it with you again after I write the information

02:31I will specify the column and tell it from the data

02:35verification

02:37Choose a list for me

02:39And its source is Qady

02:43And agree

02:47Where should I go with it? Choose what you want for us while you rest in the cell.

02:51Ok, come on

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

Category

Transcript

Recommended