يحتوي الكورس على مجموعة مميزة ومختصرة من الشروحات المعدة بشكل دقيق لتناسب كافة احتياجات العمل والدراسة حيث يتناول بالشرح استخدام الأدوات والدوال المختلفة مع توظيفها في نفس الوقت في مشاريع عملية مختلفة ليستفاد الدارس أقصى استفادة وكأنه قام بدراسة عدة كورسات اكسيل في نفس الوقت من خلال كورس واحد يضم (الاستخدام العام لبرنامج الاكسيل - الاكسيل المحاسبي - شرح الدوال والعديد من الأساليب المتقدمة في الاكسيل)
00:00In the previous video, we prepared the devil that we will work on to make the salaries.
00:04I will start with this thing, which is that I apply all the calculations related to deductions and additions, so that in the end I get the salaries due to me.
00:12First, regarding delays, we start by calculating the employee’s delays in specific financial amounts.
00:20For example, if we assume that the hour of delay is calculated for each employee at 40 pounds.
00:24So I start by multiplying the number of hours of delay by the amount of 40 pounds to get it
00:29The delays that will be deducted from this employee
00:32I will start by telling him that it is equal to 40 in
00:34The total of the delays for the employee Hadeer who will be here in her office Hadeer
00:44I will start to know him and cover him
00:47Here he brings me the summary of her delays.
00:50As for absence, to calculate it, I start by seeing what this employee’s salary is.
00:54I will not assume, for example, 12 thousand
00:56One day's absence is 12,000/30, so I get it every day of absence.
01:04I will start by telling him that my absence is equal to
01:06What is between the brackets? This salary is on 30
01:10To get the value of one day
01:13The value that will come out, I will start by multiplying it for him by the number of days of absence related to him.
01:18And I started to press enter
01:21He started telling me that her absence was worth 1600.
01:24Okay, as for the predecessors
01:26Let's assume, for example, that she made a 1000 pound loan.
01:29So I wrote it
01:31For me, the tax is assumed to be 5%, for example.
01:35So I will start calculating the tax for her at 5% of her basic salary.
01:39I will tell him to do it
01:41The number that is here
01:44The decimal point after that is 05
01:48We Inter
01:49He started telling me that her tax was 600 pounds.
01:52Okay, as for the preliminary details.
01:54It may have some preliminary details.
01:56I can't assume that she doesn't have any preliminary details.
