يحتوي الكورس على مجموعة مميزة ومختصرة من الشروحات المعدة بشكل دقيق لتناسب كافة احتياجات العمل والدراسة حيث يتناول بالشرح استخدام الأدوات والدوال المختلفة مع توظيفها في نفس الوقت في مشاريع عملية مختلفة ليستفاد الدارس أقصى استفادة وكأنه قام بدراسة عدة كورسات اكسيل في نفس الوقت من خلال كورس واحد يضم (الاستخدام العام لبرنامج الاكسيل - الاكسيل المحاسبي - شرح الدوال والعديد من الأساليب المتقدمة في الاكسيل)
00:00In this video, we will start by calculating the employee’s annual performance rate.
00:06After we put his evaluations every month
00:09We will also start by changing the name of our tab or worksheet.
00:15So we put each name that expresses the worksheet and what is in it
00:21Let's start by changing the name of the worksheet.
00:24I have it under the name of the default worksheet
00:27Arabic language will be one sheet, two sheets, and so on.
00:33Here we start that I change the name of Sheet One
00:36I will click on it and I will make it a ringtone
00:39It is equivalent to naming it, for example, the annual performance rate.
00:45After I put the name, I can also change the color of my tab.
00:53Or the worksheet or my gray hair
00:56Click on who and I will start telling him
00:58Tab Cooler
00:59This tab color or worksheet color is Gene
01:03I will make it red, for example
01:05So that it is distinct from the rest of the worksheets in my portfolio.
01:09Nice or something like that the first thing in our video is over
01:13Okay, for me, the performance rate means what is the performance rate? We have a performance for a group of months of the year, twelve months, an ambush for each description.
01:22We want to know what the performance rate of each employee will be.
01:27What will the average performance of an employee for the whole year be?
01:32The arithmetic mean is calculated by dividing the number of numbers by the set of numbers.
01:37This means that the set of numbers that each employee received will be twelve.
01:42There is a function in Excel that allows you to do this instead of doing it manually.
01:47I will start using a coffee pot called Afrij
01:50Of course, we can easily get the Dallah Afrig from the program, but I want students to know how to write the Dallah in their hands, so that later on, if any problem occurs in it or they want to change it.
02:01They should understand what they are doing. It should not be a matter of them stepping on something and that's it.
02:05In order to make the tool's rate, I will start by telling it to equal Afrij.
02:11Of course my language must be English
02:14Afrij brings me all the things that have this word in them. This is the first one I've read. Click on it.
02:21And he opens a cup with me, so he becomes equal to Afrij and opens a cup with me
02:25I will start by specifying the evaluations for all the months of the year, of course.
02:30Ok, after I finish, I will close the cup and leave
02:34He starts to look like this to me
02:36Ok, why does it appear like this to me, if you remember the previous video?
02:40We know that before we enter our data, we must determine the type of data in which the cell will not appear.
02:46So I will start by telling him about them
02:50Make the data type here number or percentage
02:56It will start showing me the percentage of the tool's boost.
03:00I started to withdraw so that I could get the next employees.
03:04Their tool was in the water
03:06We still have to do it together
03:08I will start after I change the data type
03:10And choose that it is percentage
03:12I will start to spend in the cell and I will tell it to equal average
03:16After I wrote her name average and opened the box
03:22We open the key with the nine key on the keyboard and close it with the zero key.
03:26I will start by specifying the months in my data.
03:32This employee's environment means I will take my empty row and all the numbers in it
03:36After I finished, I closed my cup and saw zero enter.
03:38He starts to answer me that this employee's tool rate is 87/91 percent.
03:46And his employees remained, and he brought me their annual tool average.
