يعد هذا الكورس من أكثر الكورسات التي تحتاجها في سوق العمل وكذلك الدراسة وهو عبارة عن ثلاثة كورسات في كورس واحد أولهم كورس الاكسيل للمبتدئين، وفيه تتعلم الأساسيات العامة لاستخدام البرنامج، ثم كورس الاكسيل التأهيلي والذي يؤهلك لسوق العمل بكافة مجالاته كمستخدم عام لبرنامج الاكسيل، ويليهم كورس الاكسيل المستوى المتقدم والذي يتدرج لمستوى المحترفين حيث يؤهلك للعمل في قطاعات أكبر ومعرفة التعامل بشكل احترافي مع البرنامج.
00:00Peace be upon you and welcome to a new video from Al Excel.
00:05In which we will learn about cell formats, especially fonts.
00:10We can format the fonts to work professionally in Excel.
00:16For the things we want to differentiate
00:19How do you say this? Let's see together.
00:21If I have cells that I need to have the line itself be under one line or under two lines, or the text is written on it. If I want it to be under the line or above the line, what do we do? Come on, let’s see.
00:36For example, I will specify here, let’s say on this cell, right click and format cells, but my wife will choose the tab called “Font” for it.
00:46Hoda, I tell him that my cover, if he wants it to be under my words, is a line, for example, a single line, and the color of the line under it, as you can see, should appear like this.
00:58Can I tell him no, let the color of the line below it, for example, be red, and it will remain that way
01:02And I tell him, for example, to make the font itself bold, which is what we call bold.
01:08Can I also make size 26?
01:12From here I choose the type of font I want, for example this type of font
01:19And I will tell him, “Okay.” I will write him any word, for example, “The Beginning.”
01:24You see how it looks like when you talk to me?
01:29Ok, let's try something else. If you want the text to have two lines under it instead of one, right click and format the cells.
01:37Also, should I make it the same type of font in front of me or not? I don’t remember, or what.
01:43Let's choose this font and choose a color for it, for example this color
01:48This time I will tell him that the underlining is double, for example.
01:52It will stay like this and make it dark
01:5626 sizes OK
02:01I will write him the end, for example.
02:04Do you see the difference between the fonts? How do I do that? We make a big difference in our design depending on what each person wants to use.
02:14Ok, come here, let's try something new in the fonts. Right click, format cells.
02:19Should we try the italic line, okay? We choose for it, for example, the form of our framing, individual accounting, in this way
02:30And the color is purple, for example, large size, so we can see.
02:36We will also write the beginning for him
02:40Do you see how it looks? Each one has a completely different look than the one before it.
02:46Okay, let's also try to see if there is something else in my line.
02:52Let's try right-clicking on cells together.
02:55This time I will start choosing these things
02:58What are these things that have a line in the middle that looks like it was written on?
03:01You see it will be like this?
03:03We change its color, for example, to green.
03:08Size 26
03:11We try it finally
03:16It doesn't look that strong
03:20But what does it mean?
03:22We have very clear differences.
03:25These are our mechanisms
03:26I have a line, above the line or below the line
03:29What we call subscript and superscript
03:32Click me if you want to format the cells
03:35Under this line, do you know what chemical symbols are?
03:39When I tell him, for example, we symbolize water H2O
03:41Falto or number two remains under the line
03:43I'll tell him it's low
03:45Do you see how it will be?
03:46I'll leave it at 26
03:51The size remains the same.
03:53We choose this color for him, for example.
03:55Let's leave it at the beginning
03:57I don't know if a minority is commenting on this.
03:59You see the difference now?
04:01Between the regular line and the one below the line
04:03Under the line
04:05Come on, we have the same needs
04:07Let's try it above the line
04:09Click me cell formatting
04:11This time we will choose the high one
04:13Who will come above the line
04:15I will choose an example for him
04:17Font color
04:19Okay
04:21Okay
04:23okay
04:25The same goes for the 26th one.
04:27I will tell him I agree
04:29Choose another line for him
04:31Like this
04:33Like this
04:37the end
04:39Do you see the difference between
04:41Above the line and below the line
04:43It is the high, the low, and the regular line.
04:45These are the basic growths.
04:47Which lines do we have?
04:49Excel, we choose any style
04:51We are back
04:53To start with, we are
04:55We write and create our own tables professionally.
Be the first to comment