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.
03:33We know what their performance was
03:35So, all of us have this video content.
03:38Come on, try it
Comments