تعديل قائمة الخيارات المخصصة - انواع البيانات المختلفة في الاكسيل - video Dailymotion

Shereen Elmasry

يحتوي الكورس على مجموعة مميزة ومختصرة من الشروحات المعدة بشكل دقيق لتناسب كافة احتياجات العمل والدراسة حيث يتناول بالشرح استخدام الأدوات والدوال المختلفة مع توظيفها في نفس الوقت في مشاريع عملية مختلفة ليستفاد الدارس أقصى استفادة وكأنه قام بدراسة عدة كورسات اكسيل في نفس الوقت من خلال كورس واحد يضم (الاستخدام العام لبرنامج الاكسيل - الاكسيل المحاسبي - شرح الدوال والعديد من الأساليب المتقدمة في الاكسيل)

Transcript

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

تعديل قائمة الخيارات المخصصة - انواع البيانات المختلفة في الاكسيل

Category

Transcript

Recommended