• LOGIN
  • No products in the basket.

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
HR & Payroll Management
$419.87 inc Vat TAKE 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
102 Schedule 00:03: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 Reviews

4.8

4.8
5 ratings
  • 5 stars0
  • 4 stars0
  • 3 stars0
  • 2 stars0
  • 1 stars0

No Reviews found for this course.

© Alpha Academy is a part of Adams Academy Inc. Ltd.