حساب الإضافي & الراتب المستحق، طباعة التقرير

Shereen Elmasry

يحتوي الكورس على مجموعة مميزة ومختصرة من الشروحات المعدة بشكل دقيق لتناسب كافة احتياجات العمل والدراسة حيث يتناول بالشرح استخدام الأدوات والدوال المختلفة مع توظيفها في نفس الوقت في مشاريع عملية مختلفة ليستفاد الدارس أقصى استفادة وكأنه قام بدراسة عدة كورسات اكسيل في نفس الوقت من خلال كورس واحد يضم (الاستخدام العام لبرنامج الاكسيل - الاكسيل المحاسبي - شرح الدوال والعديد من الأساليب المتقدمة في الاكسيل)

Transcript

00:00In the previous part, we learned how to calculate the deductions for each part separately.

00:04For the time being, we will start calculating together the overtime and the salary due.

00:08And finally, we print the salary report.

00:12Let's start first with the extra time.

00:15I will start by calculating the value of the extra time.

00:20For example, an hour costs fifty pounds.

00:22We start by multiplying this value by the number of overtime hours worked by the employee.

00:28So how do I do it? I will start by telling him it is worth fifty.

00:31I will go back to Hadeer's group to get the number of extra hours here and cover for him Inter

00:38He starts to bring me 360

00:41I will write him a random number for the tree incentive, for example, nine hundred.

00:47Transportation allowance is six hundred, for example.

00:50And I will write instead of the population one thousand five hundred

00:53What random numbers did you write?

00:56I will start after that, I want to calculate the salary due

01:00The salary due to the employee is the basic salary.

01:04Added to it are the additions and subtracted from it are the deductions

01:07Fahd, because how did I do it? I will tell him here, it is equal to

01:10His basic salary is 12 thousand

01:14Plus cm

01:18The extra one here in these cells has a stop sign.

01:21Now if I did an interview for him, I would get the salary I deserve

01:25With extra

01:27I also want to remove the deductions from it.

01:29So I started to enter everything between the brackets

01:31I will tell him the result that will come out, subtract from it the total which is cm

01:35I have deductions

01:37I will close the door of poison and enter

01:40He started telling me that her due salary is 11601 and this fraction

01:45So we have finished the salary model.

01:50We want to start printing it now.

01:52So that I can print in the mail

01:54I start by determining the extent to which I want to print.

01:57For example, do it with Control B from the keyboard.

02:00Which is short for Brit

02:02This looks upset me

02:04The default is in my settings

02:06print active sheets

02:08The whole sheet. I don't want the whole sheet. I just want my schedule.

02:12So, click on it and choose print selection.

02:15I will give you only part of the table that I want, not the whole table.

02:18I dare to tell him

02:20Here, let my direction be widthwise.

02:22Instead of portrait, make it landscape.

02:26She will start to add the visible part to me.

02:30But not everything will appear

02:31So that it all appears with me

02:33I would like to tell him here

02:34Instead of no scaling

02:36Leave it

02:37fit sheet on one page

02:39This way the whole table appears to me in print

02:42And I start to determine the number of copies that I want to print.

02:44For example, nine of you

02:46I specify the printer I will print on.

02:48And I start telling him print

02:50He starts by doing an impression with me.

02:52Come on, try it

Category

Transcript

Recommended