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

189,000 تومان

افزودن به سبد خرید

خرید دانلودی فوری

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

تولید کننده: Udemy-Training