Skip to playerSkip to main contentSkip to footer
  • 4 days ago
يعد هذا الكورس من أكثر الكورسات التي تحتاجها في سوق العمل وكذلك الدراسة وهو عبارة عن ثلاثة كورسات في كورس واحد أولهم كورس الاكسيل للمبتدئين، وفيه تتعلم الأساسيات العامة لاستخدام البرنامج، ثم كورس الاكسيل التأهيلي والذي يؤهلك لسوق العمل بكافة مجالاته كمستخدم عام لبرنامج الاكسيل، ويليهم كورس الاكسيل المستوى المتقدم والذي يتدرج لمستوى المحترفين حيث يؤهلك للعمل في قطاعات أكبر ومعرفة التعامل بشكل احترافي مع البرنامج.

Category

📚
Learning
Transcript
00:00Peace be upon you and welcome back to the Excel program.
00:05In the previous video, we learned how to draw simple tables and set their settings as we like.
00:11Okay, the time will come when we start taking ready-made settings and applying them so that we do not get tired a lot while making our own tables.
00:19Let's begin
00:21For example, I will say that if I want this space to be my table and I want it to take the form of specific cells
00:28The words in it have a specific format.
00:31I start to define it and from here I have the patterns
00:34We create patterns for an area, a cell, or multiple cells, as we like.
00:39I see four patterns appearing with me, and if I press the watch, more patterns will appear for me.
00:45All styles mean here, for example, the style I am standing on.
00:49Why is the color of the arms so light and the words on them will be in black to this degree?
00:56Ok, I can make it orange, for example, and the words on it white.
01:00Can I make it, for example, a second shade of orange, or green, etc.?
01:04Let's try this degree, for example.
01:06I will write
01:08It will show me the shape of the writings that were in this text.
01:12Ok, come on, change it
01:14Choose something else for him, for example, the book in his hand
01:17We see that it has changed spontaneously.
01:19I don't need to stand on it and change it
01:21Very beautiful
01:23No, I won't say anything
01:25We will start by printing something else on it called the coordination table.
01:29This is a professional, religiously-based, and easy-to-use jadul.
01:33They have a variety of shapes and colors that I can choose from.
01:39For example, choose this shape for him.
01:41He tells me that it will be from cell B2 to cell G20.
01:47I will tell them OK
01:49If you want it to contain heads
01:51I will teach her here
01:53I will tell them OK
01:55The heads, as you can see, have marks on my hands.
01:57We'll take it later
01:59This is the filter mark.
02:01Okay, if it doesn't have heads.
02:03Okay, what do you mean, can we leave something else?
02:07Okay
02:08Ok, very nice
02:10If I wanted to take back my words
02:12Oil control
02:16Do you see how many times we have to return to the original paper?
02:18Let's make it, for example, another green shape.
02:20It will start to apply to me
02:26good
02:28This is what the ready-made table looks like.
02:30I can make a table for myself
02:32Or I can make a table for myself
02:34It is very easy to make my own layout.
02:36It is here in Excel.
02:38I start telling him to format it as a table.
02:40Here is a new jadole pattern.
02:42He tells me that the new table pattern
02:44How is this done?
02:46He tells me that the full table pattern
02:48I never find a way to coordinate it once.
02:50Or first column layout
02:52Second column layout and so on
02:54I tell him, for example, to plan the complete table.
02:56And coordination
02:58I start by finding the formats I want.
03:00For example, borders
03:02There are borders everywhere.
03:04Start pressing like this
03:06Borders on the vacant lot from all directions
03:08Well the borders are wide
03:10Her color
03:12It will be purple in color.
03:14Why do I know?
03:16Black will change
03:18Who was in purple
03:20Okay packing
03:22We will make it a filling, for example.
03:24In additional colors
03:26Choose it to fill
03:28For example, it is light in color.
03:30I tell him here, okay?
03:32And here again I agree
03:34And he says to him, "Okay."
03:36Now I have a new table format
03:38If you knew, for example, about the area of this
03:40I told him to format it as a table
03:42I found something above its name dedicated
03:44These are the arrangements I made.
03:46Yes, and I will tell him ok
03:48It will descend upon her
03:50So we are normal as if we are doing
03:52Our design and save it in it
03:54Table formats and answers
03:56When we carry

Recommended