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

Shereen Elmasry

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

Transcript

00:00Welcome back to a new video from the Excel explainer videos.

00:03We will learn together about cell arrangements in more detail.

00:09We knew before, so we make the words colored inside the cell.

00:13We leave the cell colored, but now we will take the filling in more detail.

00:19Come on, let's see together then

00:20For example, if I have a group of cells in the first row in my own table

00:25I would like to color them

00:27Default here to fill in the cell

00:30And choose the color from these colors

00:31I don't like all these colors, or is there a specific color I would like to use?

00:35This color has a certain degree that is not available here.

00:38So what do I do? I start telling him additional colors.

00:42I will tell him instead of making it standard, make it custom

00:46Okay, you see here there is more color gradation.

00:49I start by choosing to withdraw like this

00:51And he brings me the degree because I want it

00:53Is it possible if I don't work in graphics and I know the color codes?

00:58I start by taking the color

01:01copy paste here

01:02Which is hexadecimal code?

01:03color specific

01:05Of course, people who work with graphics know these things very well.

01:07Or I can do an online search.

01:10On color codes

01:12Hexadecimal color code

01:14It will give you a set of codes.

01:16Take the code you want or the color degree you want

01:20Take his code and put it here

01:21Ok, you can change instead of what your pattern or model is RGB.

01:26Leave it HSL

01:28Choose what you want

01:30But it is better that we work on RGB

01:32Because most of us work on it

01:34This is the default mode for any program.

01:36Very sweet

01:37I choose a color for him

01:39For example, you have a degree of religion.

01:41Okay, I say yes

01:42This is the way

01:44One of the methods we use to fill the cell

01:48good

01:49In other ways or in other and more detailed ways than this

01:52How did Sherine Horiko how?

01:55We will specify here a group of cells as well.

01:57But this time, instead of bringing it from outside, he brought it from inside.

02:00Right click

02:01And I started to tell him to format the cell.

02:04My cell formatting is defaulted to the tab called Number.

02:08We will know that later

02:09But now in this video we will know the filling

02:12Packing and bringing me a set of colors

02:15I start by choosing the color I want and I tell him additional colors.

02:19Which is the same one we brought from outside

02:21Of course, this is not another holiday

02:22Here I have something called fill effects.

02:25If I wanted it to be more than one color

02:31This color

02:34Okay?

02:36Ok, so I will make my color a gradient between two colors.

02:41What does this gradient look like?

02:42Unlock what is like this

02:44Nor vertical

02:45He will remain standing

02:46Don't go up

02:49Nor down

02:51Not from this angle

02:53Or from the middle

02:55Everyone has their own style of coordination.

02:58Okay?

02:59Can I change the color again?

03:01Leave it for example

03:02Purple

03:03Uncover

03:04Do you see how it looks?

03:05I'll say okay

03:06And here too I agree

03:08Ok, very nice

03:10After I got this color, I felt that I didn't want it

03:12I want it to return to its normal shape, without any color.

03:16I will determine it

03:17And this is what I said here

03:19Leave it unfilled

03:21Remove the color

03:23Or control Z if it was the last step

03:25We are navigation

03:27Good, beautiful

03:28Is there any other?

03:29I also have a group of patterns.

03:31We can use it for cells. Come and see it together.

03:34Kalil Kemin

03:35I will tell you cell formatting

03:37From the tab called Filling as well

03:40Instead of bringing additional effects and colors

03:42This time I will go to the color of the engraving and the pattern of the engraving

03:45If I don't choose the engraving style

03:47You see a group of patterns in it.

03:49If, for example, we do

03:51Sheet of attendance and departure

03:52We have holidays

03:54I don't want the employee to interfere in anything.

03:56I want someone to see

03:58This shit knows these are holidays

04:00Or formal occasions or days out

04:02I choose the pattern I want

04:04Here I will choose the color that I would like it to be in.

04:08I will tell him okay

04:10You see, it came down to me like this?

04:12Have another one

04:14I will start telling him click who

04:16Cell coordination

04:18Engraving style

04:21For example, this time I will choose this style for him.

04:23And the color I will choose for it is green, for example

04:27I tell him OK

04:28Give me my shape

04:30The same thing if I wanted to remove the color

04:32I start by identifying the cells.

04:34I am here

04:35I will tell him without filling

04:37Easy and simple topic

04:39But you need to try it

04:41music

04:43music

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

Category

Transcript

Recommended