عمل قائمة منسدلة بالاكسيل

Shereen Elmasry

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

Transcript

00:00We previously learned about the Excel program and how to verify data.

00:04We were able to see some examples of digital data, history, etc.

00:10In this video we will learn together how to create a balanced value.

00:14So we require the person or data entry

00:18He chooses from a set of values that we have determined in advance.

00:22How do I do this from the tab called Data?

00:25I will go to verify the data to do it

00:29But first, I write my information to him.

00:32I will write him a set of data. Now I will write him only normal text data, girls’ names.

00:38Sherine Laila Marian anything

00:42Here, when I write my value

00:46I will start by leaving after I finish it completely

00:51For the place where you want to apply this data, for example, the column...

00:56I will tell him to verify the data

00:59Start by giving me permission, any permission, on the list

01:03This list is supposed to have a source for me.

01:08Click here, select the range, and click again.

01:11I will tell him I agree

01:13Come on, let's see together because I click on any cell

01:16This data group appears to me. I cannot enter any other data.

01:20Okay, nice. Or when I think that I write him any letters that he doesn’t accept?

01:26I need to have only the data from the list that I chose for him.

01:31Ok, how do I do it again? I go and tell him to verify the data.

01:36And I specify on the list

01:40I will go and specify my source for him

01:43I will tell him, "Okay," and it will apply to the extent that I specified here.

01:47Easy and simple topic, come try it

Category

Transcript

Recommended