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.
03:52So we've finished this video.
03:54Come on, try it
Comments