00:00Welcome to practical application number three
00:03We will get to know each other in this practical application.
00:06How do we make the payroll sheet and calculate salaries for employees?
00:11If you think about the last time or the last project
00:15We took attendance and departure together and made the full month
00:18This whole month I will assume that he has a specific employee.
00:21And I start by naming his devil or his workhorse
00:26On behalf of the employee, and for you, for example, Hadeer
00:29Then we'll go make Kabylie the devil
00:33A little bit of his work paper
00:36And we go, I tell him, "Good luck, Cap."
00:39We will go. I will see what I will call this thing. We will go, for example, Moftu And.
00:45And to make another copy of it, I tell him, “Create a copy of my work, okay?”
00:49So I'll go down with her like this, we'll go, I'll double-dip on her, or name her, or a little of what she's sleeping on
00:55Let's go, I will name her Hadeer, for example
00:57I will repeat the matter with the rest of the attendees and I will start by changing their data, whether it is attendance or departure, and the functions are as they are, nothing has been changed in them
01:09Okay, very nice. After that, in today’s project, we will start by making the salary devil.
01:16I will start by drawing his shape. I will tell him here, for example, a series.
01:21Instead of writing on a small line, we can start marking the entire area we want.
01:28And I start to tell him control 1 from the keyboard
01:31Let the font size be 20 so you can see it in the recording.
01:36Here will be the series of the ark
01:40Then the employee's name
01:42Above I find a special section for deductions
01:49There is a second part dedicated to it that we will do together.
01:52Here the deductions will include more than one thing.
01:56The first thing I will do in deductions is to calculate tardiness and absence.
02:04And according to the Slavs as well
02:08And according to the tax and disciplinary details
02:12We knew that we could combine this whole part through something called Merge in the table called Home Merge Center.
02:27After that, I will come back again and do something called the additional
02:31I will start by putting all the extra cells
02:37And here, of course, I will correct my words.
02:40Here is the extra time I will start putting in the extra time
02:44Which is the operatime
02:46I will also start to put the incentive
02:50I will give him transportation allowance
02:57Housing allowance
03:01And the basic salary will be reduced
03:07Here is the salary due
03:10I have put my basic elements now, now I will start adjusting the spaces
03:17I start by putting the things I need in my sheet
03:23So that my salary comes out correctly
03:26These are my basic settings. I will start working on them.
03:31Maybe I have limits for it or I will leave the limits for the next part
03:35Just try to work together on the basic form of our practical application.
03:40Because after that we will start to complete it
Comments