يحتوي الكورس على مجموعة مميزة ومختصرة من الشروحات المعدة بشكل دقيق لتناسب كافة احتياجات العمل والدراسة حيث يتناول بالشرح استخدام الأدوات والدوال المختلفة مع توظيفها في نفس الوقت في مشاريع عملية مختلفة ليستفاد الدارس أقصى استفادة وكأنه قام بدراسة عدة كورسات اكسيل في نفس الوقت من خلال كورس واحد يضم (الاستخدام العام لبرنامج الاكسيل - الاكسيل المحاسبي - شرح الدوال والعديد من الأساليب المتقدمة في الاكسيل)
00:00In this video, we learned how to calculate employee delays.
00:06In this video we start calculating the employee's absence days during the week.
00:14We will use the country count f to calculate the number of days the employee is absent.
00:22We don't use the country count if because we are actually living life
00:29We start in spite of the employee's absence during the employee's absence he must
00:39Reduce employee absences during the week
00:43We commit employee absence so I use the state of the account if for the pain
00:49I tell him that count F equals count F, meaning it passes me the cell if it contains a specific condition. Here, count F is an open cos
00:59I will start by defining the range that I want, then I will make it my comma or semicolon.
01:05Criteria condition: What can I tell it to be the value in this cell and press enter to close it, and it will start telling me one?
01:14Here, if I remove the word absent, it will start telling me 0, meaning it is passing by. But what are the things that I want?
01:21I want to modify the word absent, so I will modify the word absent. If I want to modify a word, for example, great, I will modify the word great, and so on.
01:29Okay, you will apply this practically to my model. If on the day the person is absent, there will be no attendance or departure.
01:37So I will start by recording his attendance and departure, for example:
01:44And I will write to him here where this part is absent
01:48So the person has been absent with me for a day
01:53I want to start by leaving his absence for the week. I will start by telling him here equals count F.
01:59I gave him a cup and started to set a time limit for him in terms of the number of hours.
02:09Then I give it my comma or semicolon and we go back to complete. I want to give this text. If it contains the word absent, then I will know the cell that contains absent.
02:20Or do it between the halves of the word absent with the same two letters.
02:24I will close the door on him and the person will be absent for one day
02:28Here I have the extra time coming out negative because it is the extra time
02:34He took it from me for a day, so I dealt with it negatively. I can just show you what the final shape will be. I don’t want this negative at all.
02:41I will start adding the hours here, for example, if he leaves today at nine o'clock
02:46So he shows up with me extra time
02:48So the first week will be counted for me. I will start now to do his coordination.
02:53I will start doing this within limits
02:58Here I make my own boundaries
03:00Okay
03:02Can I make a distinction for each day so that it is a different color from the other color?
03:09Here, for example, in this color
03:12Thursday and Saturday
03:14I start by pressing Control to mark a group of columns or more than one range. I start by coloring it at once.
03:24Like this
03:26And I start by teaching here the four
03:31Friday and Sunday
03:33I'm still pressing the control
03:38I will teach you the remaining parts
03:40So that it takes on a color, for example.
03:44Green
03:46Here is the part of the first week, which will have a distinctive color.
03:51Can I click on a turquoise color for it, for example, to make it stand out?
03:56And here I will start to give them color.
04:00For example
04:02So my first week is over, I will start copying and pasting it.
04:07Because it is impossible for me to do all the things you did in the first week for all the weeks
04:11Copy it
04:13Come here and make it paste
04:15Make sure the functions are downloaded correctly
04:19Here is cell 12
04:22G12
04:23I will start by inlaying the coffee pot if it has G12
04:27So the coffee pot is on me correctly
04:30But we must be careful not to paste from the beginning of the row.
04:36So I will start by pressing ctrl z and then I will go back to the beginning
04:40Paste ctrl v from the keyboard
04:43Make sure the kettle is on correctly
04:46And I start here again, I want to download the last week, the third week
04:53Here it is, the second week
05:00Of course, the days ended on Monday and we started on Tuesday, so this is normal.
05:05Here it remains for him history we were ending with seven nine remains here
05:10Eight nine and we start to withdraw as everything we have is accurate and correct
05:18We finished with 14 nine in the second week. Here we have 15 nine in the third week.
05:25Ok, and the 15th is the nine, so I'll start withdrawing it.
05:35We are Kabi again, the month is not over yet
05:40I will start by going down and doing it here
05:47This is the fourth week
05:51Here instead of 15 nine it will be 22 nine
06:02And we start to withdraw
06:0728 Nine is the last week, there will be fewer days, and we will start to do a different calculation. You will understand how.
06:17I will start again by pressing Ctrl+C on the keyboard
06:24And I start to go down
06:27Here is the control in
06:30And I start to make this the fifth week
06:33Here it should end with 28 nine. We will start with 29 nine.
06:41And I start to pull
06:46September is 30 days away, so I don't want to hear what's going on here.
06:54I will start by saying that I am completely empty
06:58Okay
06:59September, the fifth week or the last week, has two days, and both days are working days.
07:04I will start by making the average of the days of attendance
07:09Here it is supposed to be 16 hours and not 40 hours, if you remember the extra time we used in it.
07:15We will start by changing the number 40 to 16.
07:19And you
07:23He starts to think about me like this
07:25This is my month, I will start, I want to end it
07:32Calculate the number of days of delays, how many days of delays, how many absences, and how much overtime
07:38I will start using a bucket of poison for delays.
07:41To know his set of delays during the month
07:45And I start to define the column
07:47Of course, a pot of poison has nothing to do with us writing the lyrics.
07:50It will start to count normally as well.
07:53Here he has a 14-hour delay, thank God
07:57Here for absence equals cm
08:00I will count his absence
08:03I will close the door and enter
08:06He has been absent for 4 days
08:08And the extra is equal to cm
08:10I will start calculating the extra for him
08:13Lock the cup and enter
08:16He starts telling me he has 7 extra hours.
08:20So we have the attendance and departure form behind us.
