تنسيقات الخلايا - نوع البيانات في الاكسيل - video Dailymotion

Shereen Elmasry

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

Transcript

00:01Peace be upon you, and I greet you again in a video on cell coordination

00:06We don't know in the video

00:07Data type

00:08What is the data type or why do we specify it and let's see it enter to write

00:14Most of the SO formatting is not specified as to the type of data or tahun.

00:21Most of the devils are not there. What is the point of walking?

00:24But there are things for which we need to specify the data type.

00:26We know the type of data

00:29Let's see what can determine the type of religion.

00:33For example, here is this cell

00:36Ok, I want to write him a fraction, so I say to him, for example, four over five.

00:44Okay

00:45Come on, let's see the criminal who went out. I wrote to him on May 4th.

00:48No, I'm telling you, May 4 is broken. What did you bring me a date for?

00:52He doesn't understand what I want. Does it have a specific format that it takes with the data?

00:58For example, we write a mobile number. I will write a random mobile number. This is not a real mobile number. Sorry.

01:03Zero twelve, such and such, such and such, anything

01:07You see, he keeps taking the zero, one for himself, and so on, without even asking?

01:11Is this okay? This is just a mobile number. We need to find out what we can do.

01:16Apparently every number, for example, three numbers, then four, then the remainder

01:22What is this shape? It takes this shape because it was not predetermined.

01:27What type of data will you enter?

01:29So, it remains natural for him that this is the default number or general data.

01:34Well, I want to specify the data and I want to know that I start by choosing from here or

01:38Click who and I will tell him the creative coordination that we advise

01:41The first thing I have is the tab that will be numbered.

01:44There is a general rule that is not specific coordination. It takes anything but puts it in the way it knows how.

01:51He doesn't know what my data is or doesn't specify it accurately.

01:58Ok? Ok, I want to enter data, for example numbers.

02:01So I started telling him the number

02:03He tells me you have two decimal places. What do you mean by decimal places?

02:07That means after the decimal point there will be two numbers.

02:10I can tell him no, let it be three

02:12Can I tell him to leave it, one is enough, four is enough, each one according to his own needs?

02:17Does he like it? Here I have to use the thousands separator.

02:21These are the people who work on accounting and data that includes numbers, money, and such.

02:26There must be a separator after the thousands, right?

02:30Because if we had a large number like this, we would know how to read it.

02:33Of course, anyway, we won't be able to read it, but we don't mean it.

02:36We like to separate large numbers with commas like this.

02:42So that we know how to deal with it

02:44Here he brings me the default we have in the Arabic language

02:47The default is the comma after every three numbers.

02:51Before the numbers, the decimal point will be the point symbol.

02:59Okay? I will tell him ok

03:01Do you see how the shape works?

03:03Here, for example, let's replace the last number with one.

03:09Excuse me, I want to leave the line

03:25Also one okay?

03:27You see, I don't have a decimal point after one. Let it be, for example, the number six.

03:33And so on

03:35I have every three numbers separated by a comma.

03:37And before the decimal number, he starts to put a point or period for me.

03:42Ok, very nice

03:44Let's see something other than numbers.

03:46Right click

03:48Forget the cells or outside from here

03:50Which two are right?

03:51He has the currency

03:52Ok, what is the difference between currency and number?

03:54They both have the same number of decimal places.

03:57We determine it and I have the mark that is after these three numbers.

04:02But here I have an increase in the currency, as it brings me the currency symbol itself.

04:06We are here, we are here, Egyptian, Fatakideem, Egyptian

04:10Villagers here for example currency

04:11For example, our ten are in trouble

04:13All-Knowing, I count

04:33I have a gray hair symbol far away

04:35I am her danger and she is the symbol of Europe

04:39Beautiful

04:41Here I can choose the currency from here

04:44I can choose the currency symbol from here.

04:48I choose and less

04:52I can reduce the numbers.

04:58decimal point

05:01Of course, I have a window mark here for the Ministry of General Data on Cell Size.

05:06I have general data, numbers, currency data, no problem here

05:12I have accounting data that is exactly like currency.

05:16Ok, can I get it from the cell formatting?

05:20Accounting is like currency, with decimal places and currency symbols.

05:26Nothing will change for me

05:29I have the history

05:31History begins. I need different formats for it.

05:35For example, my language is Egyptian Arabic, Syrian Arabic, Omani Arabic, or Qatari Arabic.

05:42Depending on my language and country, it will start choosing the type of calendar for me or show me the types of calendars from which to choose.

05:50I want a calendar for the mother of the ball, or an English name, or a French name, or a Western name, or a French name, or a Gregorian name.

05:58Or according to what he uses

06:00Ok, for example, I chose the coordination of the mother of the ball

06:02It appears to me that he will show me the name of the day

06:06Today's number and month in which we are among us

06:10Neither the number nor the name of the day nor the shape is like this

06:14Choose what I want. For example, I chose this shape. I told him, “Okay.”

06:18I will write him any date

06:20For example, twenty-four

06:22Eight

06:26I have to, or it is the 26th of Muharram, I don’t know what

06:30I didn't write 24th Muharram and 26th Muharram

06:32What I announced

06:34He started taking the numbers or data that I entered or kept with him in a historical format.

06:40Okay, that's very nice. As for the date, I can go and modify it at any time.

06:45Holding cells

06:48Leave it like this

06:50So tell me that it is actually the twenty-first day of the month of September, in the year twenty-four of the Hijri calendar, and so on.

06:58It makes you forget the history that I choose

07:00Ok, I have other time-related reminders.

07:07If I write the hour and minutes, or write the symbol morning and evening with them

07:14I choose the symbol I want

07:16I want to start by saying that I am running and I would like you to try it. It is very easy.

07:20I have a booster percentage

07:22If we are dealing with KPI, for example

07:26Or we deal with the private parts of a certain percentage

07:32So we start by making it a strong percentage.

07:35Can we leave decimal places with it or not?

07:38For example, it must have decimal places.

07:40This is my number, how can you make it 90 only?

07:43Ninety point zero zero remains

07:46Perfect and filmy

07:48Can we leave it at 100% or put it outside?

07:50We can leave the decimal places out.

07:54I mean, we're here if we come

07:56In a cell with only a number

07:58Can we keep it one?

08:00The symbol for the amplified ratio

08:04Okay

08:06In this way

08:08Can we leave the data?

08:10Cell formatting

08:14It is a fraction

08:16Choose the fraction form

08:18What kind of shape is this?

08:20I tried one too from a very easy topic

08:22Or global

08:24My world also chooses from the decimal places

08:26Write him any number

08:28He starts to visit me

08:30In the form of things that appear in physics, mathematics and such things

08:34Can I have the data type?

08:38be text data

08:40Texts, guys

08:42It doesn't just mean letters

08:44Texts accept letters

08:46Code numbers

08:48Any of these things that come to me is considered normal.

08:50But note that if I enter numbers

08:52The cell type or cell format was text data.

08:56He does not perform mathematical operations on it.

08:58We take care of this very well

09:00I may have my data

09:02It contains text data.

09:04And the numbers entered

09:06I will come later to collect what is collected, why?

09:08Come on, do any math

09:10He doesn't do it because he thinks it's half

09:12Therefore, the text cannot be

09:14Perform mathematical operations on it

09:16We take very good care

09:18Ok, what can I do with this text?

09:20Enter me, his name is next to me, for example

09:22Enter the code with the code and so on

09:24Is it possible for me to choose a specific symbol?

09:28I want to go out later

09:30Ok, I will deal with you

09:34Or we will send it to her later

09:36How do we even get in?

09:38Special coordination between us

09:40We will know it at an advanced stage, God willing.

09:42But time is running out, we are still in the first stage

09:44I won't tell you anything about this

09:46This is very simple

09:48Data formats

09:50If we enter normal data

09:52Maybe we don't need to go in

09:54Data formatting

09:56But if we were to enter data, for example

09:58Specific to history

10:00Who chose the date format?

10:02We will enter, for example

10:04Currency formats that choose their symbol

10:06So that the data comes out to us correctly.

10:08Come on try

تنسيقات الخلايا - نوع البيانات في الاكسيل

Category

Transcript

Recommended