التعبئة التلقائية للبيانات في الاكسيل

Shereen Elmasry

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

Transcript

00:00And it's time for us to automate data filling.

00:04What does automatic filling mean? We start by telling the program

00:08Write us your data automatically to save us time and effort.

00:13For example, I want to create a series of numbers to write data in this series.

00:18So he started writing one, then two, and then three.

00:22Can I have it auto-fill the data or numbers in my range?

00:28Okay, if I want, for example, to have him write this information for me in a specific way

00:34For example, between each cell and cell, it will add two numbers, for example, it will add three, it will add five.

00:40Well, I want the direction to be, for example, up, down, right, left, whatever it is. How do I do this?

00:46Come on, let's see, one by one, if I want to do an automatic filling

00:52First, I might like this data to be repeated only for me.

00:56So I start by seeing the trend, for example, repeating itself with me below.

01:00My sheet is Arabic, of course, from right to left.

01:04So I started standing on the cell from below, opposite to the direction of the sheet.

01:09The sheet from right to left remains I will stop the cell to the north

01:12From under my gifts, I have a black plus sign, if it appears in the photo with you.

01:17And pull down this one, it will be repeated

01:21Ok, no, I don't want to make one for myself. I want it to be an Arkham series.

01:25So I stopped in the same way and the black one appeared to me.

01:29But I want to increase my accumulation

01:32Press the control button on the keyboard

01:37And pull down

01:39We notice that I work on the Arkham series

01:42Ok, very nice

01:44I'm either working on an Arkham series or filling out data entry

01:48Ok, if I want the data to be on the left side, I will specify it on the left side.

01:53And I will go from the main ribbon tab and tell him to fill here

01:57left

01:59What does the one on the left do to me?

02:03Ok, I want this one on the right. I will specify the range in which I want one to write.

02:08I will tell him to swear

02:11I want it down and I'll come like this

02:15And I will tell him down

02:17And so on

02:19Ok, I would like him to make me an Arkham series, for example.

02:22There is a certain difference between them, so I will do this.

02:25I will specify my range and tell him to fill it up.

02:27For example, I will have the value of the mistake.

02:31I mean, how much does it increase between each one and the other?

02:33For example, here you go

02:35five

02:36The stop value is twenty-five.

02:38Let's take care here if I am limited to empty water

02:41But when I have twenty-five, it's time to stop.

02:43Okay, it will stop at number twenty-five.

02:45He has nothing to do with the behavior I have specified, so tell him I agree.

02:49You see?

02:51One more, six more

02:53eleven sixteen twenty-one

02:55Of course, twenty-five is not appropriate for her, because if five is added, it will be twenty-six.

02:59It stops at twenty-one

03:01Ok, let's try it again. We'll decide here.

03:05I will tell him to fill the chain

03:09Let it be worth eight, for example.

03:15And the value of the stoppage began, I told him, “Okay.”

03:21Can I make it history?

03:23Date, for example, twelve thousand nine hundred and twenty

03:27I specify and tell him to fill up

03:31series

03:33Can I leave it like this?

03:35Step 3 chemistry

03:37Can I make it a working day, a month or a year?

03:39Let it be for a month

03:41Two step chemistry

03:43So he can give me two months and I can tell him I agree

03:45It starts here

03:47Provides two months

03:49Every time

03:51Here I consider that this nine is the month

03:57So, there remained a month, nine, a month, twelve, one, a month, three, five, seven, nine, eleven, one, and so on.

04:03This way we fill our containers in a very easy and simple way. Come on, try it.

04:09War rifle

04:11ill

04:17behind

04:19Now I'm bored

04:20second

04:21behind

Category

Transcript

Recommended