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