The HR & Payroll Management Training with Microsoft Excel Course is the fastest, most effective way to learn payroll management with Microsoft Excel online, suitable for both aspiring professionals and those with payroll experience. In this HR management course, you will be trained in all areas of payroll administration, with step-by-step guidance on how to use BrightPay.
Through this comprehensive course, you will deepen your understanding of the role of the HR department and payroll administrator, exploring the stages of the planning, recruitment and selection process in detail. The main duties of payroll administration will also be covered, from how to conduct performance appraisals to monitoring employee engagement and employing talent retention strategies.
Learn fundamental procedures such as how to create employee databases and payslips in Excel, file a self-assessment tax return, calculate PAYE and much more, gaining the fundamental skills to fast track your career and become a valuable asset to any organisation.
There are no specific entry requirements for this course, which can be studied on a part-time or full-time basis from any device with an internet connection. Knowledge of employment law and the human resources sector would be an advantage; however, the basic topics will be covered in this course.
Learning Outcomes:
- Deepen your understanding of the role of payroll administrator and the human resource department
- Understand the different stages of the planning, recruitment and selection process
- Broaden your knowledge of organisational culture and the key elements of a positive working environment
- Know how to conduct a performance appraisal, what should be included in it, and understand its key objectives
- Develop your understanding of the payroll process and payroll management systems
- Get step-by-step guidance on how to file for a self-assessment tax return
- Learn how to create payslips and employee databases on Microsoft Excel
- Get to grips with BrightPay payroll software and learn how to navigate the employer porta
Assessment and Certification
At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. After you have successfully passed the final exam, you will be able to order an Accredited Certificate of Achievement at an additional cost of £19 for a PDF copy and £29 for an original print copy sent to you by post or for both £39.
Career Path
Once you have successfully completed the course, you will receive a recognised certificate of achievement which you can use as proof of your new skills. You will be able to utilise Excel’s functions and features to manage payroll and employee databases confidently, which is required for the following professions:
- HR & Payroll Administrator
- HR Manager
- Payroll Specialist
- Payroll & Finance Assistant
- 1 year
- Level 3 - Diploma
- Course Certificate
- Number of Units79
- Number of Quizzes0
- 15 hours, 47 minutes Gift this course
Course Curriculum
HR Management Training | |||
Human Resource Management | 00:30:00 | ||
HR Planning, Recruitment and Selection | 01:00:00 | ||
Induction, Training and Development | 00:30:00 | ||
HR Department’s Responsibilities | 00:30:00 | ||
Organisational Culture | 00:30:00 | ||
Motivation, Counseling, Resignations and Retirement | 00:40:00 | ||
Performance Appraisal | 00:30:00 | ||
Remuneration Policy | 00:15:00 | ||
Records and Statistics | 00:30:00 | ||
Industrial Relations | 00:15:00 | ||
Payroll Management | |||
Introduction | |||
Introduction to the Course and Instructor | 00:10:00 | ||
An Overview of Payroll | 00:17:00 | ||
The UK Payroll System | |||
Running the payroll – Part 1 | 00:14:00 | ||
Running the payroll – Part 2 | 00:18:00 | ||
Manual payroll | 00:13:00 | ||
Benefits in kind | 00:09:00 | ||
Computerised systems | 00:11:00 | ||
Total Photo scenario explained | 00:01:00 | ||
Brightpay | |||
Brightpay conclude | 00:03:00 | ||
Find software per HMRC Brightpay | 00:03:00 | ||
Add a new employee | 00:14:00 | ||
Add 2 more employees | 00:10:00 | ||
Payroll settings | 00:04:00 | ||
Monthly schedule – Lana | 00:14:00 | ||
Monthly schedule – James | 00:08:00 | ||
Directors NI | 00:02:00 | ||
Reports | 00:02:00 | ||
Paying HMRC | 00:05:00 | ||
Paying Pensions | 00:04:00 | ||
RTI Submission | 00:02:00 | ||
Coding Notices | 00:01:00 | ||
Journal entries | 00:07:00 | ||
00:00 | |||
AEO | 00:06:00 | ||
Payroll run for Jan & Feb 2018 | 00:13:00 | ||
Leavers – p45 | 00:03:00 | ||
End of Year p60 | 00:02:00 | ||
Installing Brightpay | 00:13:00 | ||
Paye, Tax, NI | |||
PAYE TAX | 00:13:00 | ||
NI | 00:11:00 | ||
Pensions | 00:06:00 | ||
Online calculators | 00:07:00 | ||
Payslips | 00:03:00 | ||
Conclusion and Next Steps | |||
Conclusion and Next Steps | 00:08:00 | ||
Tax Accounting | |||
Tax System in the UK | 01:00:00 | ||
The Requirements | 00:03:00 | ||
The Timeline | 00:06:00 | ||
Planning Checklist | 00:10:00 | ||
Getting & Providing Support – Things to Consider | 00:11:00 | ||
Changes ahead for accounting firms | 00:09:00 | ||
Conclusion and Next Steps | 00:04:00 | ||
Self Assessment Tax Return | |||
Logging into the HMRC System | 00:06:00 | ||
Fill in the Self Assessment Return | 00:06:00 | ||
Viewing the Calculation | 00:03:00 | ||
Submitting the Assessment | 00:02:00 | ||
Conclusion | 00:05:00 | ||
MS Excel | |||
Navigate the Excel User Interface | 00:28:00 | ||
Use Excel Commands | 00:10:00 | ||
Create and Save a Basic Workbook | 00:19:00 | ||
Enter Cell Data | 00:12:00 | ||
Use Excel Help | 00:05:00 | ||
Create Worksheet Formulas | 00:15:00 | ||
Insert Functions | 00:17:00 | ||
Reuse Formulas and Functions | 00:17:00 | ||
Insert, Delete, and Adjust Cells, Columns, and Rows | 00:10:00 | ||
Search for and Replace Data | 00:09:00 | ||
Use Proofing and Research Tools | 00:07:00 | ||
Apply Text Formats | 00:17:00 | ||
Apply Number Formats | 00:08:00 | ||
Align Cell Contents | 00:09:00 | ||
Apply Styles and Themes | 00:12:00 | ||
Apply Basic Conditional Formatting | 00:11:00 | ||
Create and Use Templates | 00:07:00 | ||
Preview and Print a Workbook | 00:10:00 | ||
Set Up the Page Layout | 00:08:00 | ||
Configure Headers and Footers | 00:07:00 | ||
Manage Worksheets | 00:05:00 | ||
Manage Workbook and Worksheet Views | 00:07:00 | ||
Manage Workbook Properties | 00:05:00 | ||
Order your Certificate | |||
Order your Certificate | 00:00:00 |
Course Ratings
No Ratings found for this course.