يحتوي الكورس على مجموعة مميزة ومختصرة من الشروحات المعدة بشكل دقيق لتناسب كافة احتياجات العمل والدراسة حيث يتناول بالشرح استخدام الأدوات والدوال المختلفة مع توظيفها في نفس الوقت في مشاريع عملية مختلفة ليستفاد الدارس أقصى استفادة وكأنه قام بدراسة عدة كورسات اكسيل في نفس الوقت من خلال كورس واحد يضم (الاستخدام العام لبرنامج الاكسيل - الاكسيل المحاسبي - شرح الدوال والعديد من الأساليب المتقدمة في الاكسيل)
00:00In the video, I will show you how to create a series of numbers, filter data, arrange our data, and change the alignment.
00:10In this video, we will learn how to save the value of custom options.
00:16What does this mean? If I have data that I use frequently, I don’t want to have to write it all down every now and then.
00:24Is it possible for me to save my data in Excel so that when I type something in it, it will start bringing me the rest of the data?
00:32For example, if I work in a specific department and this department has a group of employees, I start working on their data in different sheets.
00:41Every now and then, I give them evaluations, I give them attendance and commitment, I give them sheets of criticism, I give them sheets, for example, related to performance, and so on, and many other things.
00:50I can do it for these employees. Of course, not every time I will start by opening my sheet for him and taking his data from another sheet or something else that is open.
01:01I want to save the names of these employees so that I can use them later at any time I want.
01:06So I will start by writing down the names of the employees here, for example, Retaj.
01:11Marwa
01:14We leave Rasha as she is
01:17rare
01:18paternal uncle
01:20Mona
01:22I have any names that you and I have, for example these names
01:26Ok, I have these names and I want to save them. So what do I do? I will click on the tab or tab, “Name File.”
01:33I have something called Options. I will start by clicking on it.
01:37And I will bring him an advance
01:40Under the hood, I need names that are custom made. I will not start clicking on them.
01:45I have this form. I have the data already written in the program. So I start by clicking here on this cell mark.
01:53I know or specify the data and then I click on it again and tell it to import, meaning bring me the data in this range.
02:02It remains with me here and click with me here as a custom list or as a value for the custom data
02:09I will start by telling him okay
02:11And here too, okay?
02:13If you want to use this data at any time and in any place, just do not write anything of it.
02:18I will write to him, for example, Retaj
02:20I started to withdraw in the same way that I did in the Arkham series.
02:25Reverse direction check from north side down
02:29I will start to withdraw
02:31Hey, bring me the data. Give me Retaj, Marwa, Rasha, Nader, Omar, Mona.
02:35When my data is finished
02:37Because I withdrew more than the range
02:38The direction that I decide for myself is another one, Retaj Marwa Rasha
02:41Understanding withdrawals
02:43I don't remember what name I started with
02:45This is me writing him any name randomly
02:47for example
02:49And I will withdraw
02:51So he started
02:53Give me the data
02:55It means whether it starts with the first name
02:57It started from the second, it started from the third
02:59There is no problem. I have to arrange or sequence it under it until I have all the data there.
03:07Beautiful and strong
03:08I still have the employee data.
03:10Here I start putting my months starting January 8th
03:14And pull horizontally
03:17My auto fill should be down
03:19But can I pull to the north side as well?
03:23To get my months
03:26My months of the year come
03:28To start, we will conduct evaluations for this group of employees every month.
