Microsoft Excel Training for HR and Payroll Management in Uganda

Through the two-day training, HR & Payroll Professionals will learn the tips that save hours to resolve the difficulties they face daily in doing employee compensations, salary, leave, benefits, etc.

In this practical training, participants will learn formatting techniques to convert data from different sources, and how to make the best use of the most important formulas for HR.

Payroll is not just about issuing checks. For instance, Payroll Specialists must learn the legalities of exempt versus non-exempt employees. Learn how to deduct taxes; how to make statutory deductions.

Additionally, Payroll Specialists must comply accurately and timely with a variety of federal and state payroll reporting requirements, not just for taxation purposes, but for laws covering things like final and/or unclaimed paychecks.

Participants will be empowered to manipulate charts and diagrams, use logical functions, and link their spreadsheet to other worksheets and applications.

You will learn to automate some common Excel tasks, apply advanced analysis techniques to more complex data sets, troubleshoot errors, collaborate on worksheets, and share Excel data with other applications like the HRMS.

We also offer Corporate Training for Advanced Excel 2016 & 2019 versions to other teams in the organization.

TRAINING OUTCOME 

By the End of the Training Programme, Participants Will Be Able to Manage HR Data Including but Not Limited to:

  • Set Up an HR Database Using Excel
  • Preparing A Payroll
    • Compute the Allowances Per Staff
    • Compute the Departmental Allowance (Retainer)
    • Establish the Total Allowances
    • Establish the Gross Pay (Chargeable Income)
    • Compute the Statutory Deductions
      • S.S.F
      • A.Y.E
      • Local Service Tax (LST)
    • Compute the Total Deductions
    • Compute the Net Pay
  • Preparing Performance Ratings and Reporting Template
  • Preparing Pay Slips for every Staff

What You’ll Learn:

This training session covers the rules for identifying, filing, retaining, protecting, and destroying your important payroll records. By attending, you and your team will learn:

  • Which records must you keep – and for how long?
  • Recommended record retention processes
  • Do record retention and how
  • How to know when it’s safe to scan a document and dump the paper original
  • Must payroll records be kept separate from HR records?
  • Prepare monthly Payroll Schedule, identifying all due dates including but not limited to changes, timesheets, expense reports, payments, etc
  • Payment of salaries to employees. Facilitate distribution of Worker payments for compensation, including salaries and supplemental income (overtime, benefits) as directed by your organization
  • Facilitate distribution of your approved worker expense reimbursement
  • Withholding and payment of all required taxes on those payments to relevant authorities. Process monthly contributions to the Social Security Administration, or similar authorities, on behalf of our clients
  • Maintain timesheet records, vacation, and sick leave balances, etc. for each employee
  • Provision of market-based salary and benefits advice to your organization
  • Report in detail, as required and agreed, on salaries and benefits paid to employees.

Compliance Requirements for Payroll

  • Learn how to ensure compliance with all applicable laws related to employment and social costs, including labor laws, rules, regulations, codes, ordinances, and orders, as well as data security/privacy laws.
  • Notify your organization of any change of local labor law that increases (or decreases) employee costs and affects your budget, including but not limited to social security obligations, tax on salary, etc.
  • Guide in regards to recouping the costs of any lost or damaged equipment by your request.
  • Assist your organization with data for audits as well as providing your staff with guidance on record maintenance in the local field office location.
  • Report with immediate effect of any data breaches.
  • Ensure all appropriate licenses and/or registrations necessary for the employment of Worker in the country are completed.

TARGET PARTICIPANTS

HR Managers, HR Officers, Employee Benefits Staffs & their Teams, Finance Managers, Officers & Teams, Payroll Managers & Officers, Small & Medium Business owners who run their payroll, Other Organizational & Business Leaders who would like to Master Excel

TRAINING TOPICS

DAY 1

Lesson 1: Summary Outline

  • File formats, styles, types, columns, and rows
  • Formatting and editing worksheets
  • Defining the print and page setup
  • How to apply functions
  • Creating and editing charts

Lesson 2: Outline

  • Learning formula fundamentals
  • Creating formulas and their automatic application
  • Using references & named ranges
  • Using special logical & text functions for HR applications

Lesson 3: Outline

  • Using a pivot table and charts
  • Create a PivotTable Framework
  • Lookup function for HR usage
  • Protecting your data forms from invalid data entry
  • Conditional Formatting

DAY 2

Lesson 4: Summary Outline

  • Recording MACROS & automating Work
  • Linking several worksheets
  • Combining several workbooks to create a summary
  • Securing and reviewing your worksheet
  • Tracking changes and comments
  • Hiding and protecting formulas

Lesson 5: Overview of the Essential Contents of Excel Payroll Data both Organizational & Regulatory

  • Gross and net pay
  • Correct Formula for NSSF contributions for both Employees and Employers for Excel
  • PAYE Formula
  • Generating a Payslip
  • Mail Merge
  • Appraisal Rating Keys

Lesson 6: Using Employee Data to Prepare Payroll in Excel

  • How to Create the Column Names
  • How to Create Some Payroll Formulas
  • How to Customize & Save Templates

TAILORED TRAINING SOLUTIONS FOR HUMAN RESOURCE MANAGEMENT

Microsoft Excel Training Courses for Human Resource (HR) and Payroll Management  

No. of Hours

Microsoft Excel Basic Training | Excel 2013 Courses Online | Beginners 5h
Microsoft Excel 2013 – Advanced 12h
Project – HR Dashboard using Excel 6h
Project – Advanced HR Dashboard 7h
Project on Excel VBA – Attendance Register using Microsoft Excel VBA 3h
Project on Excel VBA – Restaurant Billing System using Microsoft Excel VBA 3h 6m
Microsoft Excel 2019 – Beginners 16h
Microsoft Excel 2019 – Advanced 16h
Project – Creating Interactive Dashboards using VBA 3h
Project – Creation of Basic CRM by using Microsoft Excel VBA and SQL Express 4h
Project – Interactive Dashboards using Microsoft Excel VBA 3h
Project – Microsoft Excel Dashboard Training 6h
Microsoft Excel for Business Professionals and Managers 2h

Course Requirements

First of all, you need to be an HR Practitioner to do this Excel for the HR Training course. If you want to do this Excel for HR Training, then only you will get the most out of this course.

To get the most out of this course, it’s recommended that you use Microsoft Excel 2016 or 2019 Professional Plus or standalone edition running on Windows 7 or later. If you are using a different version of Excel, you should be able to follow very well as the instructor facilitates the learning sessions. You’ll also be able to complete most of the homework, and quizzes,

Regional & Locale Settings

This course is based on the English (Uganda) Region and Locale settings. This means that Excel formulas will use commas for list separators. We bring this up only to make you aware that your regional settings may be set to use a semicolon as your list separator. There is no need to change your regional settings – just be aware to swap out commas in formulas we demonstrate or provide with a semicolon and dates are formatted in mm/dd/yyyy format.

COMPANY PROFILE

Facebook Posts

Microsoft Excel Training | Uganda, Kenya, Tanzania & RwandaLearn Microsoft Excel in Uganda & Get a free e-Book Worth USD $100 which comes with an certificate of Training.This course that will show you how to get the best out of Advanced Microsoft Excel that you can complete in 3 Days!What You'll Learn in this CourseCreating Charts -Pivot Tables, Power Query and Dashboards-Macros & VBA to really speed up your work!Course ModulesMODULE 11.1 Introduction1.2 OverviewMODULE 22.1 Combine what you can enter in a cell2.2 Relative and Absolute Cell Referencing2.3 Entering Formula2.4 Order of Operations2.5 Date Serial NumbersMODULE 33.1 Copy and Drag3.2 Working with rows and columns3.3 Working with sheetsMODULE 44.1 Functions4.2 SUM Function4.3 Copy and Drag Formula4.4 More Basic Functions4.5 Named Ranges4.6 Names Constants and Formula4.7 Shortcuts4.8 More ShortcutsMODULE 55.1 Formatting Font5.2 Formatting Alignment5.3 Formatting Borders5.4 Formatting Numbers5.5 Conditional Formatting Pre-Configured5.6 Conditional Formatting with Formula5.7 Conditional Formatting Dialogue Box Formula TrickMODULE 66.1 Icons Shapes and Formatting6.2 Printing Page Layout6.3 Printing Headers FootersMODULE 77.1 Data Sort7.2 Filtering7.3 Tables7.4 Text to Columns7.5 Flash Fill7.6 Data Validation7.7 Group and Outline7.8 Freeze PanesMODULE 88.1 Relative and Absolute Referencing8.2 VLOOKUP8.3 Index Match8.4 IF8.5 Nested If8.6 Countif Countifs8.7 SUMIF SUMIFS8.8 LEN8.9 RIGHT LEFT MID8.10 SEARCH8.11 Common Error Types8.12 IFERRORMODULE 99.1 Chart Basics9.2 Chart Series and Column Charts9.3 Bar Charts9.4 Pie Charts9.5 Composite ChartsMODULE 1010.1 Power Query Intro10.2 Power Query Consolidation10.3 Pivot Tables10.4 Setting up a Pivot Table10.5 Pivot Table Field Settings10.6 Pivot Table Calculated Fields10.7 Pivot Table Groupings10.8 Pivot Table Slicers and Timelines10.9.1 Dashboards Part 110.9.2 Dashboards Part 2MODULE 1111.1 What is a macro?11.2 Recording a Macro11.3 Relative and Absolute MacrosMODULE 1212.1 Introduction to VBE12.2 Object Model12.3 Module Worksheets Classes12.4 Variables and Constants12.5 vba Formatting12.6a If Statement12.6b Select Case12.7a For Loop12.7b DoWhile DoUntil Loop12.7c ForEach Loop12.8a Errors12.8b Errors12.9 ConsolidateWhether you are a complete beginner or even at an intermediate level, this course will rapidly build your skills and confidence and have you doing your work in Excel very quickly and productively.You can go through the course with the confidence that it's taught by a highly experienced professional from Uganda who has used Excel for over 10 years.When you sign up, you get a book worth $ 100How much does it cost to take your course?UGX 1,190,000 ... See MoreSee Less
View on Facebook
Microsoft Excel Training | Uganda, Kenya, Tanzania & RwandaLearn Microsoft Excel in Uganda & Get a free e-Book Worth USD $100 which comes with an certificate of Training.This course that will show you how to get the best out of Advanced Microsoft Excel that you can complete in 3 Days!What You'll Learn in this CourseCreating Charts -Pivot Tables, Power Query and Dashboards-Macros & VBA to really speed up your work!Course ModulesMODULE 11.1 Introduction1.2 OverviewMODULE 22.1 Combine what you can enter in a cell2.2 Relative and Absolute Cell Referencing2.3 Entering Formula2.4 Order of Operations2.5 Date Serial NumbersMODULE 33.1 Copy and Drag3.2 Working with rows and columns3.3 Working with sheetsMODULE 44.1 Functions4.2 SUM Function4.3 Copy and Drag Formula4.4 More Basic Functions4.5 Named Ranges4.6 Names Constants and Formula4.7 Shortcuts4.8 More ShortcutsMODULE 55.1 Formatting Font5.2 Formatting Alignment5.3 Formatting Borders5.4 Formatting Numbers5.5 Conditional Formatting Pre-Configured5.6 Conditional Formatting with Formula5.7 Conditional Formatting Dialogue Box Formula TrickMODULE 66.1 Icons Shapes and Formatting6.2 Printing Page Layout6.3 Printing Headers FootersMODULE 77.1 Data Sort7.2 Filtering7.3 Tables7.4 Text to Columns7.5 Flash Fill7.6 Data Validation7.7 Group and Outline7.8 Freeze PanesMODULE 88.1 Relative and Absolute Referencing8.2 VLOOKUP8.3 Index Match8.4 IF8.5 Nested If8.6 Countif Countifs8.7 SUMIF SUMIFS8.8 LEN8.9 RIGHT LEFT MID8.10 SEARCH8.11 Common Error Types8.12 IFERRORMODULE 99.1 Chart Basics9.2 Chart Series and Column Charts9.3 Bar Charts9.4 Pie Charts9.5 Composite ChartsMODULE 1010.1 Power Query Intro10.2 Power Query Consolidation10.3 Pivot Tables10.4 Setting up a Pivot Table10.5 Pivot Table Field Settings10.6 Pivot Table Calculated Fields10.7 Pivot Table Groupings10.8 Pivot Table Slicers and Timelines10.9.1 Dashboards Part 110.9.2 Dashboards Part 2MODULE 1111.1 What is a macro?11.2 Recording a Macro11.3 Relative and Absolute MacrosMODULE 1212.1 Introduction to VBE12.2 Object Model12.3 Module Worksheets Classes12.4 Variables and Constants12.5 vba Formatting12.6a If Statement12.6b Select Case12.7a For Loop12.7b DoWhile DoUntil Loop12.7c ForEach Loop12.8a Errors12.8b Errors12.9 ConsolidateWhether you are a complete beginner or even at an intermediate level, this course will rapidly build your skills and confidence and have you doing your work in Excel very quickly and productively.You can go through the course with the confidence that it's taught by a highly experienced professional from Uganda who has used Excel for over 10 years.When you sign up, you get a book worth $ 100How much does it cost to take your course?UGX 1,190,000 ... See MoreSee Less
View on Facebook

Recent Posts