يحتوي الكورس على مجموعة مميزة ومختصرة من الشروحات المعدة بشكل دقيق لتناسب كافة احتياجات العمل والدراسة حيث يتناول بالشرح استخدام الأدوات والدوال المختلفة مع توظيفها في نفس الوقت في مشاريع عملية مختلفة ليستفاد الدارس أقصى استفادة وكأنه قام بدراسة عدة كورسات اكسيل في نفس الوقت من خلال كورس واحد يضم (الاستخدام العام لبرنامج الاكسيل - الاكسيل المحاسبي - شرح الدوال والعديد من الأساليب المتقدمة في الاكسيل)
00:00In the previous video, we learned about the concept of our fourth practical project or our fourth practical application.
00:07We start by putting some data or our vision on the table.
00:13Come on, in this video we will start making this visualization in a professional and organized way so that in the end it will start to give us the result we want.
00:22First, we have many subjects for each class or each semester.
00:28We want to start showing it in a good way, not like this, so I will start by teaching it
00:35Here I have six subjects for the first semester, six for the second semester, and two subjects that are behind me. I have determined all of this.
00:42Here, from above, there is a tab called Here, which contains some formatting for word alignment.
00:50Something called AB
00:52I find in it that I can adjust the direction of my speech so that it remains
00:56Rotate Text Up
00:57I will start by changing the Volvo so that it appears to me in this form, which is of course better than the first form.
01:03Ok, very nice
01:04Here, I can make the size of the first separator a little bigger, as well as the size of the second separator.
01:11I will teach them all so that they all get the same format at once.
01:18I will make them 28, for example, since it will remain like this
01:24Ok, very nice
01:25So for me, the first semester is when I can start.
01:29I make my speech average. It is already averaged for subjects 2, 3 and 4.
01:36I will make the second semester the same thing, averaging on subjects 2, 3 and 4
01:42I noticed that my font size changed, so I started to see what my sleeve size was and left it as it was.
01:5028 where
01:53So I start to set limits for this part.
01:58Here, for me, the cell above, we were fed before in previous projects, that we are merging so that it all becomes one thing
02:05No, this time I will not merge
02:08I'm going to start doing something that will give me the same look without all the filling in.
02:12I will start by making it one fill color, and the fill color is the same as the border color, so it will appear as if it is one cell.
02:19I will make it a single control from the keyboard
02:21I will tell him the color of the filling, and for example, this color
02:24At the same time, the border color is the same color.
02:31I don't remember if it was the same grade or the third grade
02:34I will start by setting my boundaries from all directions.
02:39I tell him okay
02:41This way it looks like it's a single cell that has been merged.
02:45In the second semester I start doing the same thing.
02:48I will start telling him one control
02:50Give me this border color
02:54from all directions
02:56With this right side so that the color of this cell does not change
03:02And I started telling him the color of the filling
03:05Third degree okay
03:07It started to look like this
03:10The backward materials I will start by increasing the area of the cell a little bit
03:14As she will remain with me the same thing
03:23Control One
03:25You will give it a different color
03:27For example, this color
03:29We now know that it is the fill color and the border color.
03:33I will start by marking all the borders on the right side so that the color of this cell does not change.
03:42I tell him okay
03:44And the sediment materials are the same.
03:54I will teach them both control one
03:57You will find her a color
04:00For example, here is the third degree.
04:03The color of the milk is also the same color.
04:08Okay
04:10And the general appreciation
04:12Can I do it on a single cell?
04:18I also start with the fact that I am in control
04:21And you will find a specific color for her, for example this color
04:24Okay
04:25Ok, after I made this shape, I will start to give each category a color.
04:30As is the waste there is
04:34I will add control 1
04:36We do the third degree
04:41We do the third degree
04:43We start with the third level.
04:47I will add control 1
04:52I like the waste to be darker than the underlying data.
04:57Distinguish it from the materials of the control unit 1
05:00I will start to show her the second degree
05:03Finally, the overall rating is in the left part.
05:08I will start to show the degree
05:12Here after free colors it is possible to take any colors from the repeated colors
05:16For example, the student's name will be in green.
05:19Control 1
05:24I will change the color of the header to be for the faint
05:30And the series I will start with its colors
05:36The header is different
05:41This is what it looks like in the series
05:45I will be able to install it
05:49I will be able to install it
05:51Here is the student's name. I will write any random names for him so that we can fight over them.
05:57For example, mercy
05:59Marwa
06:01rare
06:03Mayar
06:05Any names
06:07And the materials I will assume that the material is 50
06:11for example
06:1350
06:1547
06:1730
06:1849
06:19and Article 5
06:23For example 50
06:25And also 50
06:27I will have all the material
06:29He has the materials.
06:30Here he has the materials.
06:31Here he has the materials.
06:32Certain maintenance
06:33for example
06:35where
06:37This degree is very good
06:39And these materials
06:41Under the row that has the girl's name
06:44And insert it
06:47He will make me a row, it won't be one, it will be a number only
06:51In the class I start to work on here are the estimates
06:56I will start putting random numbers for these materials here.
07:00I will see you in the next video so we can start to see how to make these estimates.
