00:00What do you mean in the previous video? How do we create custom options value for ourselves?
00:05We put the names of the employees in it.
00:08In this video, we will learn how to modify the list of options we have created.
00:13Or feel Fli
00:27Cover him again
00:30Choose AdBans from it again and go down to Add Custom List
00:37I will see the list that I want to make changes to. Another list here that I want to make changes to.
00:43I will stand in the exact place that I want, for example, I want to add Magdy and Ali after the name Nader.
00:50I will start by pressing Enter and writing to him Magdy
00:53I will press Enter again to add to
00:57And so I added what I wanted to start by telling him
01:00Here, you have adjusted with me. There is still Nader Magdy and Ali.
01:04Ok, if I want to use it, I will tell him okay.
01:08And here too, it's okay if I write any name, like Retaj, for example.
01:12And I started to pull
01:15Magdy and Ali came with me and added my data list.
01:21Ok, very nice
01:22I wanted to completely remove it from my program.
01:25I no longer need these employees to be transferred, laid off, or anything else.
01:29I will start telling him file
01:31options
01:32advanced
01:34I will go back to edit custom list
01:36I choose the list that I want to delete and I will delete it
01:40And also ok
01:43Okay
01:45I will start writing any name for him after that to try
01:47And I start to pull
01:49There will be no possibility for me to retrieve the rest of my employee data again.
01:55So we have finished the part related to the custom lists.
01:59Ok, very nice
02:01I have something called data types in Excel or any other database program.
02:07These data types are the specialization that I start to define for each cell so that it can start accepting it.
02:13There is a cell that will contain digital data.
02:15There is a cell that will contain infected data.
02:17There is a cell that will contain the time or date format, etc.
02:21Or history and so on
02:23I am supposed to enter the data before
02:25I start by specifying the data type.
02:27In the cell so that it appears to me correctly
02:29If I were here, for example
02:31I wanted to write him the date 12/10
02:33If you cover it for him
02:35So she wrote to me on October 12th
02:37Ok, I don't want to hold on to this
02:39I want it 12 10 2020
02:41I will start working
02:43So I start by choosing before I enter
02:45The data in the cell is the same data type.
02:47I will find them here
02:49It is natural that all data is
02:51General Ala Lou
02:53I came and changed the data type
02:55I have a data type of number
02:57Digital data I start writing to him
02:59Digital data appears to me like this
03:01She has two trips
03:03These two books were not decimal numbers.
03:05As long as I do not put decimal numbers
03:07I start here to increase
03:09Or reduce the numbers if I press
03:11On the right side, reduce
03:13If you press the left side, it will increase.
03:15Decimal numbers
03:17She said that I do not reduce decimal numbers.
03:19So he adds zeros to my place.
03:21I will come back again
03:23The data type is called currency.
03:25This is the currency
03:27The currency I chose
03:29I swear I gave him any number
03:31He writes to me that the currency is Egyptian, for example.
03:33Or Saudi riyal or
03:35The dirham, for example
03:37Or dinar and so on
03:39Where does he choose it from or bring it?
03:41Where does this currency come from?
03:43The currency registered in my system
03:45For example, I am the Arab Republic of Egypt
03:47The currency will remain
03:49With her the fetus is Egyptian
03:51If I were in America, for example, it would be the US dollar.
03:53And so on
03:55Ok, I'll start again
03:57Click now and I will find that I have it
03:59After or under currency
04:01Different types of currency
04:03If I don't want the fetus to be Egyptian
04:05Can I tell him that it is in dollars?
04:07Can I tell him again that it is in euros?
04:09for example
04:11Choose the currency I want
04:13I stay here with me
04:15currency and accounting
04:17Two people accept currency coordination.
04:19I choose the currency symbol I like here.
04:21If the currency symbol I want is not there
04:25Good, beautiful, very strong
04:27After that, short dates and long dates.
04:29Give me a date format
04:31In the way we see here, if the date is short, it will be a small date.
04:33He comes to me in the hall, for example
04:359.4.1999
04:37Long date
04:39He will bring me a name
04:41My month name
04:43I will say, for example, long date
04:459 days left, April 1900
04:47I will say it for example
04:499.10.2020
04:51He builds it
04:53Bring me October 9, 2020
04:55If I left her
04:57Date shorts
04:59She will start bringing me just
05:01Ok, I will start after that to look for another cell
05:03I have a time data type.
05:05Because I chose and started to write him the time format
05:09The time is 2 for example
05:11and 4 minutes
05:13and 6 seconds
05:15It comes down with me in coordination with the time next to it
05:17The symbol for morning or evening
05:19I have it later
05:21The presentation, which is the enhanced percentage
05:23If I want to have a reinforced percentage mark made for me
05:25Next to the number
05:27I choose for him to coordinate it
05:29I choose that there is no
05:31Decimal numbers
05:33If I don't want decimal numbers
05:35Or choose to bring me a broken one
05:37And the number remains on the number
05:39I start to choose it
05:41Or choose scientific for him
05:43Give me the shape of the numbers
05:45In this way
05:47Or choose for it to be text data
05:49We take care of something
05:51If I told him that the data here is text
05:53Even if numbers are entered into it
05:55You will accept numbers
05:57But you will not do an addition operation for it
05:59It means data for her
06:01I just stayed
06:03Texts or words even if they are numbers
06:05So we learned about the different types of data.
06:07Ok, how do we employ this here?
06:09I have the ratings
06:11Employees'
06:13I want it to be a strengthening percentage.
06:15So I start by knowing
06:17On employee data
06:19Before I enter it empty
06:21The data you will enter into
06:23And I will choose for him that she be
06:25Here I choose that he is
06:27There are no zeros so that I
06:29When I enter the data
06:31She starts to get on with me like this
06:33And I start to put
06:35Various data
06:37Every month
06:39So that in the end I can get out
06:41Final Report
06:43Come on, try it