Master in Automated Payroll Accounting in Microsoft Excel

Focused View

A.M.A.M Mubeen (Expert In Tally & Finance & Microsoft Office & Power BI)

6:34:56

70 View

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

1. Introduction to Payroll Accounting and Payhead Types.mp4

13:53

2. Chapter -02 Seven Steps For Prepare the Automated Payroll Accounting

1. The 7 Steps For Prepare the Automated Payroll Accounting.mp4

01:26

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.mp4

01:37

2. Vlookup and Data validation.mp4

07:53

3. Convert range to table.mp4

04:21

4. Count and Countif functions.mp4

05:14

5. Insert Hyperlink.mp4

03:49

6. Datevalue and EOMonth Functions.mp4

04:45

7. IF Function.mp4

02:52

8. Iferror function.mp4

02:21

9. Pivot tables , Pivot Charts and Slicer.mp4

11:53

10. Conditional Formatting.mp4

06:32

11. Macro Recording.mp4

07:52

12. Save as Macro enable Workbook file.mp4

01:54

13. Text Function.mp4

02:04

4. Chapter -04 Organiztion's Requirements For Payroll Accounting

1.1 Organiztion's Requirements.xlsx

1. Organization Requirements.mp4

13:20

5. Chapter -05 Prepare Employee's Basic Information Table (Step-01)

1. Introduction of 1st step for payroll accounting.mp4

02:52

2.1 Automated Payroll Accounting Template.xlsx

2. Introduction to Automated Payroll Accounting Template.mp4

04:04

3. Prepare Employee's Basic Information Table with Employee ID.mp4

09:02

4. Set Employee ID as name range and Add or Remove a Record.mp4

03:13

5. Identify table and range.mp4

01:23

6. Chapter -06 Prepare Employee's Payroll Information Table (Step-02)

1. Introduction to Prepare Payroll information table.mp4

02:06

2. Prepare Payroll information table.mp4

12:44

3. Add or Remove A New Employee.mp4

02:27

7. Prepare Automated Employee's Payroll Attendance Table (Step-03)

1. Introduction to Prepare Automated Employee's Payroll Attendance Table.mp4

02:33

2. Creation of Helping table.mp4

07:50

3. Setup Year,Month,Start date and End date.mp4

05:54

4. Add Year and Month to All Templates.mp4

06:57

5. Setup Day, Date and Holiday identification.mp4

07:49

6. Setup Employees ID and Name.mp4

04:13

7. Highlight Sat day and Sun day.mp4

04:27

8. Highlight Public Holiday.mp4

03:45

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.mp4

07:30

10. Create Attendance Matrix.mp4

06:18

11. Add or Remove an employee.mp4

01:49

12. Create Clear All Buttons.mp4

06:42

13. Save as Macro enable workbook file.mp4

01:19

14. Enter 10 Employee's Attendance.mp4

05:30

8. Chapter-08-Prepare Automated Employee's Payroll Sheet Table (Step-04)

1. Introduction to Prepare Automated Employee's Payroll Sheet Table.mp4

01:58

2. Extract Data from Basic information table and Payroll Information table.mp4

11:34

3. Extract No of Workdays and No of Present day.mp4

03:54

4. Calculate All Payheads Amounts.mp4

15:58

9. Chapter-09-Prepare Automated Employee's Payslip (Step-05)

1. Introduction to Prepare Automated Employee's Payslip.mp4

01:33

2. Extract Data from Basic information table and Attendance sheet.mp4

08:09

3. Extract Data from Payroll sheet Table.mp4

06:11

4. Testing the Payslip.mp4

01:03

5. Prepare Pie chart for Total Earning.mp4

04:44

6. Prepare Pie chart for Total Deductions.mp4

02:50

7. Prepare Pie chart for Net Salary.mp4

04:29

10. Chapter-10 - Prepare Payroll Dashboard - (Step-06)

1. Introduction to Prepare Payroll Dashboard.mp4

01:40

2. Fill The table in Dashboard.mp4

07:30

3. Create Pivot Table.mp4

10:30

4. Create Pivot Charts.mp4

13:21

5. Insert Slicer.mp4

09:17

6. Insert Clear All and Filter Button.mp4

04:19

11. Chapter-11 - Prepare Payroll User Interface - (Step-07)

1. Introduction to Prepare Payroll User Interface.mp4

01:39

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.mp4

17:27

3. Prepare Buttons and Insert Images to Other Excel sheets.mp4

05:10

4. Insert Hyperlinks to All Buttons.mp4

06:35

12. Chapter -12 Prepare Next Month Salary with Adding New Employees

1. Add the new Employee into Payroll Book.mp4

10:11

2. Create Refresh All button for Pivot table.mp4

02:50

13. Chapter -13 Prepare Next Month Salary with Removing An Employees

1. Remove an Employee From Payroll Book.mp4

03:10

14. Chapter -14 Setup the Reports for Printing

1. Setup Print for Attendance sheet.mp4

09:22

2. Setup Print for Payroll sheet.mp4

06:02

3. Setup Print for Payslip.mp4

05:17

4. Setup Print for Payroll Dashboard.mp4

12:28

15. Chapter-15 Protect the Workbook with Password

1. Protect the Workbook with Password.mp4

03:32

Description

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

What You'll Learn?

Solid Understanding About Payroll Accounting In Microsoft Excel
Learn About Different Payheads Types In Payroll Accounting
Solid Understanding About Automated Payroll Accounting Related Excel Formulas Ans Functions
Understanding About Seven Steps For Automated Payroll Accounting In Microsoft Excel
Prepare Employee's Basic Information Table in Excel (Step-01)
Prepare Payroll information table in Excel (Step-02)
Prepare Automated Employee's Payroll Attendance Table (Step-03)
Prepare Employee's Automated Payroll Sheet Table (Step-04)
Prepare Automated Employee's Payslip (Step-05)
Prepare Automated Payroll Dashboard - (Step-06)
Prepare Payroll User Interface - (Step-07)
Understanding About Prepare Next Month Salary By Using Excel Template
Understanding about Add or Remove A Employee
Understanding About Protect the Workbook with Password

Who is this for?

HR Managers

Payroll management team

HR Assistant

Accountants

Financial Managers

You want to put this skill on your CV

Small And Medium Entrepreneurs

You are going to take responsibility for Payroll

You are going for jobs which have a requirement for you to be able to know payroll And Payroll Process

You are an accountant and will be offering payroll services

You run your own business and want to know how to run the payroll for yourself

What You Need to Know?

Microsoft Office Software Installed

No prior Excel knowledge is needed

More details

Description
Seven Reasons why you should choose this Master in Automated Payroll Accounting in Microsoft Excel
course

Best Rated Course on Udemy
Carefully designed curriculum By Proficient In Payroll Accounting Expert
you can complete this course In Short time
Payroll related examples and case studies Provided
Example And practice exercises Are Able to Download in The Recourse Section
Your queries will be responded by the Instructor With In Short time
A Verifiable Certificate will Be Provided On the Completion

This Master in Automated Payroll Accounting in Microsoft Excel Course is all about How to perform the perfect Automated Payroll Accounting By Using Microsoft Excel without WritingÂ any single VBA Code and I guide you from basic to advanced with step by step.

End of the course, you are able create your own Automated Payroll Accounting Template in Microsoft Excel by using Microsoft Excel Formulas and Functions with visually effective excel dashboard and Your are able analysis your payroll related data in different perspectives and the managerial workers are able to take important decisions by using this workbook.

I Designed this course to understand about whole payroll process by using Microsoft Excel with help of Excel Formulas and Functions andÂ Pivot table and Pivot charts.

What is covered in this course?

The course contain A practical Example with Different Pay heads and calculation process. I have given task to do then video answer is available. It is suggested that you:

What are the steps for Payroll Accounting?
How to Prepare employee's Basic information and payroll information tables?
How to Prepare automated employee's attendance sheet and payroll sheet table?
How To add the formulas and functions in Automated Payroll Accounting template?
How to prepare automated employee's payslip and payroll dashboard?
How To calculate The Employee's allowances and deduction by using Microsoft excel formulas & functions ?
How to create Automated payroll accounting user interface ?
How to prepare next month salary by using automated accounting template?
How to add or remove an employee from the payroll accounting template?
How to set up the report for printing?
How to protect the automated payroll accounting template with password?
How to prepare visually effective payroll dashboard by using Microsoft excel pivot table and pivot Charts?
How to easily prepare the Pay Slip in Microsoft excel?
How to prepare next month salary report in easy way?
Who this course is for:
HR Managers
Payroll management team
HR Assistant
Accountants
Financial Managers
You want to put this skill on your CV
Small And Medium Entrepreneurs
You are going to take responsibility for Payroll
You are going for jobs which have a requirement for you to be able to know payroll And Payroll Process
You are an accountant and will be offering payroll services
You run your own business and want to know how to run the payroll for yourself

User Reviews

Rating

average 0

Total votes0

Focused display

I am the Expert in Microsoft Office ,Tally ERP 9,Accounting & Finance Related Subjects and A Degree Holder (Specialization In Finance) , I Was Working in Different Positions Such as Accountant, Senior Accountant and Financial Manager of Contract Based Company. I Have Been Teaching More Than 5 Years And I Delivered Various Lecture Programs and My All Lecture Programs are Much Dynamics & interesting as well. I Hope That You Will Enjoy My All Courses.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.