يحتوي الكورس على مجموعة مميزة ومختصرة من الشروحات المعدة بشكل دقيق لتناسب كافة احتياجات العمل والدراسة حيث يتناول بالشرح استخدام الأدوات والدوال المختلفة مع توظيفها في نفس الوقت في مشاريع عملية مختلفة ليستفاد الدارس أقصى استفادة وكأنه قام بدراسة عدة كورسات اكسيل في نفس الوقت من خلال كورس واحد يضم (الاستخدام العام لبرنامج الاكسيل - الاكسيل المحاسبي - شرح الدوال والعديد من الأساليب المتقدمة في الاكسيل)
00:00In the previous video, we learned how to draw a simple table and create a table using keyboard shortcuts.
00:06In this video, we will start together with our first practical application.
00:10We will know together how to make a series of data arrangement and data zeroing
00:17So at the end of this part, we will start to present together a small practical project or a small practical application for employee evaluations during the different months of the year.
00:27The first thing we will start with is to make a table for ourselves. I have my table or my table, direction and north.
00:35The beginning of my first column from the north side of the I column
00:38Ok, we want to write data in Arabic, so I would like to move my data to the right side to make it more comfortable to use.
00:47I will start by clicking on the tab called page layout.
00:52Choose something called sheet right to left and it will start moving the column whose name is on the right side.
01:01So I will start by working on the right side. It is very nice. I will start by saying what I want to draw for it. My table.
01:08I will know the range I want, any range randomly, I do control L on the keyboard
01:14And I will tell him my table has headers
01:16This is our schedule.
01:19Ok, I want to start by putting my data in the columns.
01:23The first column will contain the Arkham series.
01:26Or we will make it a series word just so it is one word
01:33This series has consecutive arcs.
01:37In order to do the ark in a row, I have more than one method. We will take two methods.
01:42The first emergency is that I follow the cell
01:45I have the opposite direction of the sheet
01:48On the one below
01:51The oil mark shows the effect of the liquid on the cell.
02:05What does it mean, "opposite direction"?
02:08The direction of the devil is opposite in the cell from below and I started to drag down to the bottom to be able to serialize the numbers
02:15It will appear to me like this and make me a data captcha
02:18Ok, I want a series that remains one, two, three, four, and so on.
02:22I will find a check mark under it that says Auto Fill Options.
02:26I will choose Fill Serious from it because I can do a serial number.
02:32Ok, I will do it again for you to see.
02:36I will find the number with me pulled down
02:39Then I'll click on it and choose Fill Serious.
02:43I will make a series of numbers for myself
02:45I will find the first way to make a serial number
02:48The second way is to click on the cell.
02:52Reverse the direction of the devil from below
02:54I will press Ctrl and drag down.
02:57I'll do two plus some
02:59Big plus and small plus
03:01I will start to withdraw
03:03I will do the sequence of numbers once without clicking here.
03:06And specify the settings
03:08Beautiful and strong
03:10I have a serial number
03:12good
03:13I can filter this series of numbers for data.
03:16I can arrange it for him
03:18Let's write any name here randomly.
03:21For example, Rasha
03:24I want to start sorting data here.
03:27So that the numbers remain in order instead of being in ascending order.
03:30descending pattern
03:31I will start pressing the arrow
03:33And he will say to him
03:35Sort Largest to Smallest
03:37I mean, start by making an arrangement for me from big to small.
03:41Which is the descending order
03:42I told her to add the verse
03:44So he started arranging for me 13 12 11 and so on
03:49I found that the name Rasha was transferred with her
03:52For the people who say
03:53When we start, we make arrangements.
03:55Will he take the data with him?
03:57The world will not be in turmoil with us
03:58For any world that will not be confused
04:00Each row will have their own data.
04:03Okay, I would like to arrange the data in an ascending order again.
04:08I will start if I press again
04:10And I will tell him
04:11Sort Smallest to Largest
04:13Arrange them from smallest to largest
04:15I'll start. He's arranging my ascension order.
04:17And so we made a series of numbers
04:20We changed the direction of the devil
04:21We started to arrange the ascending and descending order.
04:25Very beautiful
04:26I want to start filtering data.
04:29What does data filtering mean?
04:30That means I leave certain data as the only data that remains.
04:33For example, I want data for numbers higher than 7.
04:37So I start by selecting here or clicking on this mark.
04:40I have something called Number Filters
04:43Since this is digital data
04:45I have the first thing
04:47Equals: Data that is equal to something
04:49Can I tell him Equals, for example 7?
04:51If I want the one that equals 7 only
04:53I will have seven left
04:55I wanted to come back again to see the rest of the data
04:57I want to press it
04:59And I tell him Clear Filter
05:01I want to do another filter before I do it.
05:04I have Doesn't Equals
05:06Can I tell him that it is not worth seven?
05:08He brings me all the data, it's seven
05:12In this way
05:14Here is six followed by eight
05:16I will also start by removing my filter like a straw
05:20Press Number Filters again
05:22Can I tell him that he is a good grader?
05:24Who is greater than seven
05:26And he says to him okay
05:28Can I click again?
05:30Number Filters
05:32I will tell him the time that is bigger than and equal to
05:34I will bring the seven with me
05:36It will be seven or more
05:38Instead of being from the beginning of the eighth
05:40All numbers above seven will remain
05:43I also have something called list then.
05:46The one who is less than
05:48I'll tell him less than seven
05:49So it starts with six, five, four, three, two, one.
05:51In this way
05:55less than or equal to
05:57less than and equal to
05:59Can I tell him less than and equal to seven?
06:01Give me numbers from one to seven
06:03I have it too
06:05Can I tell him the numbers?
06:07between five and nine
06:09small number
06:11The one above then below the big number
06:13okay
06:15I have it too
06:17Can I tell him 10?
06:19Top 10 Values
06:21or less 10 values
06:23I can make it less than 5
06:25or 4 values
06:27It doesn't have to be 10.
06:29I will have to provide the data according to the availability.
06:31I have it
06:33Abab Afraj
06:35The one above the stubborn
06:37We have seven extremists
06:39He answered me starting from eight
06:41I have a blue eye
06:43Who is less than stubborn
06:45The Seven
06:47After I made the filter
06:49I start to carry it
06:51This is for the filter for the number.
06:53Ok, if I have it
06:55Colorful things in different colors
06:57For example, I will come here from here
06:59The color that has the letter A
07:01This is the font color
07:03Can I color the font in a different color?
07:05For example, red
07:07From here
07:09And from here again
07:11The one next to the letter A
07:13In a sign like this
07:15The shape of the color palette
07:17Or the color palette
07:19Choose any color for the cell
07:21stay here
07:23This is the font color and this is the cell color
07:25I made a different color for the font.
07:27and different color for the cell
07:29Can I filter through?
07:31The scoundrel cell color
07:33I need Number Filters
07:35Filter by numbers
07:37Or according to the color
07:39Depending on the color
07:41It may depend on the cell color.
07:43Or font color
07:44What I want
07:45You stay with me
07:46If I want
07:47colored cell
07:48But she is the one who remains
07:49or colored cell group
07:50I will tell him Filter By Cell Color
07:52I will choose the color I like from them
07:54Or Filter By Color
07:56I will choose the color for him
07:58The calligrapher
08:00He will stay with me
08:02Only the cell with a different line color
08:04Or I will carry it for him
08:05Filter Holes
08:07It is also possible for me to arrange it based on color.
