وب سایت تخصصی شرکت فرین
دسته بندی دوره ها

Master in Automated Payroll Accounting in Microsoft Excel

سرفصل های دوره

Human Resource,payroll certification,payroll management,financial accounting payroll,hr payroll,payroll uk,us payroll


1. Chapter -01 Introduction to Payroll Accounting and Payhead Types
  • 1. Introduction to Payroll Accounting and Payhead Types

  • 2. Chapter -02 Seven Steps For Prepare the Automated Payroll Accounting
  • 1. The 7 Steps For Prepare the Automated Payroll Accounting

  • 3. Chapter -03 Automated Payroll Accounting Related Excel Formulas And Functions
  • 1.1 Automated Payroll Related Excel Formulas And Functions.xlsx
  • 1. Introduction to Automated Payroll Related Excel Formulas and Functions
  • 2. Vlookup and Data validation
  • 3. Convert range to table
  • 4. Count and Countif functions
  • 5. Insert Hyperlink
  • 6. Datevalue and EOMonth Functions
  • 7. IF Function
  • 8. Iferror function
  • 9. Pivot tables , Pivot Charts and Slicer
  • 10. Conditional Formatting
  • 11. Macro Recording
  • 12. Save as Macro enable Workbook file
  • 13. Text Function

  • 4. Chapter -04 Organiztion's Requirements For Payroll Accounting
  • 1.1 Organiztion's Requirements.xlsx
  • 1. Organization Requirements

  • 5. Chapter -05 Prepare Employee's Basic Information Table (Step-01)
  • 1. Introduction of 1st step for payroll accounting
  • 2.1 Automated Payroll Accounting Template.xlsx
  • 2. Introduction to Automated Payroll Accounting Template
  • 3. Prepare Employee's Basic Information Table with Employee ID
  • 4. Set Employee ID as name range and Add or Remove a Record
  • 5. Identify table and range

  • 6. Chapter -06 Prepare Employee's Payroll Information Table (Step-02)
  • 1. Introduction to Prepare Payroll information table
  • 2. Prepare Payroll information table
  • 3. Add or Remove A New Employee

  • 7. Prepare Automated Employee's Payroll Attendance Table (Step-03)
  • 1. Introduction to Prepare Automated Employee's Payroll Attendance Table
  • 2. Creation of Helping table
  • 3. Setup Year,Month,Start date and End date
  • 4. Add Year and Month to All Templates
  • 5. Setup Day, Date and Holiday identification
  • 6. Setup Employees ID and Name
  • 7. Highlight Sat day and Sun day
  • 8. Highlight Public Holiday
  • 9.1 MISS . M.A. Fathima Ameena - 5002.pdf
  • 9.2 MR. M.A. Anees - 5001.pdf
  • 9.3 MR. M.F. Ahamed Aathil - 5008.pdf
  • 9.4 MR. M.K. Asmee - 5006.pdf
  • 9.5 MR. M.R. Mohamed Sahee - 5010.pdf
  • 9.6 MR.M.S.Mohamed Rinaas -5005.pdf
  • 9.7 MR.M.S.Mohamed Riswaan - 5004.pdf
  • 9.8 MRS . M.S. Fathima Sareena - 5009.pdf
  • 9.9 MRS. M.A. Fathima Rumaisa - 5007.pdf
  • 9.10 MRS. M.I. Fathima Haneesa - 5003.pdf
  • 9. Enter the Attendance for All Employees
  • 10. Create Attendance Matrix
  • 11. Add or Remove an employee
  • 12. Create Clear All Buttons
  • 13. Save as Macro enable workbook file
  • 14. Enter 10 Employee's Attendance

  • 8. Chapter-08-Prepare Automated Employee's Payroll Sheet Table (Step-04)
  • 1. Introduction to Prepare Automated Employee's Payroll Sheet Table
  • 2. Extract Data from Basic information table and Payroll Information table
  • 3. Extract No of Workdays and No of Present day
  • 4. Calculate All Payheads Amounts

  • 9. Chapter-09-Prepare Automated Employee's Payslip (Step-05)
  • 1. Introduction to Prepare Automated Employee's Payslip
  • 2. Extract Data from Basic information table and Attendance sheet
  • 3. Extract Data from Payroll sheet Table
  • 4. Testing the Payslip
  • 5. Prepare Pie chart for Total Earning
  • 6. Prepare Pie chart for Total Deductions
  • 7. Prepare Pie chart for Net Salary

  • 10. Chapter-10 - Prepare Payroll Dashboard - (Step-06)
  • 1. Introduction to Prepare Payroll Dashboard
  • 2. Fill The table in Dashboard
  • 3. Create Pivot Table
  • 4. Create Pivot Charts
  • 5. Insert Slicer
  • 6. Insert Clear All and Filter Button

  • 11. Chapter-11 - Prepare Payroll User Interface - (Step-07)
  • 1. Introduction to Prepare Payroll User Interface
  • 2.1 image (1).zip
  • 2.2 image (2).zip
  • 2.3 image (3).zip
  • 2.4 image (4).zip
  • 2.5 image (5).zip
  • 2.6 image (6).zip
  • 2.7 image (7).zip
  • 2.8 image (8).zip
  • 2. Prepare Buttons and Insert Images
  • 3. Prepare Buttons and Insert Images to Other Excel sheets
  • 4. Insert Hyperlinks to All Buttons

  • 12. Chapter -12 Prepare Next Month Salary with Adding New Employees
  • 1. Add the new Employee into Payroll Book
  • 2. Create Refresh All button for Pivot table

  • 13. Chapter -13 Prepare Next Month Salary with Removing An Employees
  • 1. Remove an Employee From Payroll Book

  • 14. Chapter -14 Setup the Reports for Printing
  • 1. Setup Print for Attendance sheet
  • 2. Setup Print for Payroll sheet
  • 3. Setup Print for Payslip
  • 4. Setup Print for Payroll Dashboard

  • 15. Chapter-15 Protect the Workbook with Password
  • 1. Protect the Workbook with Password
  • 139,000 تومان
    بیش از یک محصول به صورت دانلودی میخواهید؟ محصول را به سبد خرید اضافه کنید.
    افزودن به سبد خرید
    خرید دانلودی فوری

    در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

    ایمیل شما:
    تولید کننده:
    شناسه: 16520
    حجم: 4411 مگابایت
    مدت زمان: 395 دقیقه
    تاریخ انتشار: ۲۹ تیر ۱۴۰۲
    طراحی سایت و خدمات سئو

    139,000 تومان
    افزودن به سبد خرید