• No products in the basket.

Course Overview

Whether you are looking to improve your career prospects in human resources or just want to improve your engagement and leadership skills, this ‘Online HR & Payroll Diploma with MS Excel Course’ is for you.

Our course will emphasize on the successful human resources management strategy to help you select the right employee for your organization and strategically manage talent across departments.

This course will take you through topics like employee engagement, employment law, resourcing and talent management, and talent retention & talent development. Your managerial skills are bound to be enriched with a developed in-depth skills and master teamwork within your organization.

From an accounting viewpoint, payroll is significant since payroll and payroll taxes influence the net income of most businesses, and they are subject to the rules and regulations.

The Online HR & Payroll Diploma with MS Excel Course mainly focuses on the payroll system of the UK, including an authentic way to calculate the payroll. With this course, you’ll develop your skills to adequately perform a payroll, to create accounts, understand statutory deductions, PAYE, real-time income, etc.

Moreover, you’ll focus on accounting and business operations, coding notices, tax system and procedure, and online calculators. Get skilled enough to work for businesses to ensure that the company’s tax records are prepared correctly and presented on time.

Online Hr & Payroll Diploma with MS Excel Course
$417.25 inc Vat TAKE THIS COURSE

Course Sneak Peeks


Once you’ve successfully completed your course, you will immediately be sent a digital certificate. Also, you can have your printed certificate delivered by post (shipping cost £3.99). All of our courses are fully accredited, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in your chosen field. Our certifications have no expiry dates, although we do recommend that you renew them every 12 months.

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


5 ratings
  • 5 stars4
  • 4 stars1
  • 3 stars0
  • 2 stars0
  • 1 stars0
  1. Corey Todd


    Loved the bundle. Exactly what I needed.

  2. Alexander Charlton


    Personally recommended.

  3. Jayden Warner


    In separate modules this course combines hr & managerial basics, payroll & excel formulas. All in one I can say!

  4. Ella Sharpe


    I completed two more accounting courses from another provider before this one. Personally I think this one is better…….far better actually, and I got some hr fundamentals as well.

  5. Dominic Pearce


    Admin, managerial and secretariat professionals must try this course. It’s best for accelerating your productivity.

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