كورس محاسبة الاجور والمرتبات والحضور والانصراف
Learn key concepts with simple explanations and practical examples. Master the fundamentals easily!
Course Content
كورس محاسبة الاجور والمرتبات والحضور والانصراف is an all-levels Udemy course taught by Dr Abdelrahman Raoof Tawfik. It runs 2h 37m, is taught in Arabic, and includes a certificate of completion. Learners rate it 4.6 out of 5 from 156 reviews, with 5,614 students enrolled. It is a paid course, last updated November 2023.
Master Excel for HR: Attendance, Payroll & More
Unlock the power of Excel to streamline your HR tasks! This comprehensive course equips you with the essential skills and techniques to efficiently manage employee attendance, calculate accurate payroll, and handle HR-related financial processes. Perfect for HR professionals, payroll clerks, and anyone responsible for employee time and compensation.
What You'll Learn:
- Attendance & Time Management:
- Establish robust attendance files in Excel.
- Calculate working hours and understand time differences.
- Accurately calculate employee tardiness.
- Determine salaries based on worked hours.
- Advanced Excel for HR & Accounting:
- Master essential accounting Excel functions.
- Utilize time and date functions effectively.
- Navigate Excel commands and settings for optimal performance.
- Practical Applications:
- Calculate annual performance rates for employees.
- Track employee work hours, including delays and absences, with a customizable attendance form.
- Implement the American Journal system with a detailed general ledger.
Why Choose This Course?
- Concise & Focused: Learn key topics quickly with short, targeted video lessons.
- Self-Paced Learning: Access lessons anytime, allowing you to revisit concepts as needed.
- Comprehensive Coverage: A complete solution to simplify your HR data management needs, eliminating extensive research.
- Certification: Earn a certificate upon completion of all lectures.
Hands-On Projects:
- Project 1: Annual Performance Report: Master data sorting, filtering, custom options, data types, worksheet renaming, performance rate calculation, performance charts, and conditional formatting.
- Project 2: Attendance Form: Apply basic Excel calculations, time difference calculations, overtime calculation using functions, and absence calculation using Excel functions.
- Project 3: Payroll Management: Learn to add images, format tables, calculate deductions, overtime pay, and gross pay. Generate professional payroll reports.
- Project 4: Grade Result: Practice data formatting, calculate grades using functions, determine failing grades, calculate overall grades, create dropdown lists, and format numbers.
- Project 5: American Journal: Copy formatting, create comparisons, define data entry rules and error messages, calculate debits, credits, and totals, and manage a general ledger.
Hire the developers behind TutorialSearch.io
We built this site — full-stack web apps, AI integration & automation. Tell us what you need and we'll build yours.