Microsoft Office Excel Made Easy


What are the basic business activities and data processing operations that are performed in the human resources management/payroll cycle?


What decisions need to be made in this cycle,

and what information is needed to make these decisions?


What are the major threats and the controls that can mitigate those threats?


All these questions will be answered on this 1-day online session!


Learn about the human resource management (HRM)

business activities and the payroll cycle business activities.


Learn to flow chart HRM business activities and payroll cycle business activities.

Understand the processing of HRM and payroll cycle transactions using computers.

Know the control practices and procedures in HRM and the payroll cycle. 



6th Payroll System in an Excel Spreadsheet

Using the Power of Excel in Your Payroll Accounting



Speaker: Ronaldo F. Turla, CHRP

Management Consultant

Sought-after Certified Trainer

on Emotional Intelligence

Partner Speaker, ARIVA Speakers Bureau


Thursday, October 01, 2020

10:00 AM – 12:00 NN PHT

2:00 PM – 5:00 PM PHT

REGISTER NOW! CALL US!

8832-9901 | 8835-9354

(Globe) 0917-3257870

(Smart) 0919-6142598

 

Webinar Description:


The human resources management (HRM) payroll cycle is a recurring set of business activities and related data processing operations associated with effectively managing the employee workforce. MS Excel’s spreadsheet format can be a helpful tool when using the application to prepare payroll for your employees.


Participants will be guided with in-class computer simulation activities to develop automated computerized spreadsheet template to set up the salary system.


This webinar will basically cover the basic functions of Microsoft Excel ( version 2013 and 2016). It will also relate the functions of HR such as payroll, compensation and employee information. 

 

Key Benefits from Attending this Webinar:


In this online learning session, your participants and your organization will be able to:

  • To describe the major business activities and related data processing operations performed in the human resources management (HRM) payroll cycle;
  • To identify the major threats in the HRM payroll cycle, and evaluate the adequacy of various internal control procedures for dealing with them;
  • To explain the key decisions that need to be made in the HRM payroll cycle, and identify the information required to make those decisions;
  • To equip the HR professional from beginner to the seasoned worker the basics of Microsoft Excel; and
  • To the participants are expected to use the basic Excel functions in relation to the relevant HR functions such as payroll, compensation and employee records management.
 

Special Requirements for Participants?


All Participants are required to bring their own laptops with MS Excel version 2013 or 2016

installed as it will be used throughout the webinar. Please make sure all laptops are fully charged.

 

Who Should Attend?


This webinar is suitable to a wide range of professionals but will greatly benefit anyone who wants to use Microsoft Excel to create spreadsheets and automate data processing.

Webinar Outline:

Part 1: Human Resource Management and Payroll Cycle

Session 1:  Payroll Activities

  • Update master payroll file 
  • Update tax rates and deductions
  • Validate time and attendance data
  • Prepare payroll
  • Disburse payroll
  • Calculate employer-paid benefits and taxes
  • Disburse payroll taxes and other deductions

Note: Activities will be done per step




Session 2: Control : Objectives, Threats and Procedures

  • Hiring of unqualified or larcenous employees
  • Violation of employment law
  • Unauthorized changes to the master payroll file
  • Inaccurate time data
  • Inaccurate processing of payroll
  • Theft or fraudulent distribution of paychecks
  • Loss or unauthorized disclosure of payroll data
  • Poor performance


Part 2: Using Microsoft Excel in Payroll Activities


Session 3: Basics 

  • Excel Formula Basics
  • Creating Formulas 
  • Using References and Named Ranges


Session 4: Special Text Functions

  • Using special text function ( Aggregate ) 
  • Using Logical Function ( Count / Countif )


Session 5: Pivot Table 

  • Using Pivot table and charts
  • Create a Pivot Table Framework


Session 6: Lookup Function

  • Lookup Function


Session 7: Protecting Data

  • Protecting data forms from invalid entry 
  • Recording MACROS and automating work 


Session 8: Linking Worksheets

  • Linking several worksheets
  • Combining several workbooks for summary 


Session 9: Security for Worksheets

  • Securing and Reviewing your Worksheet
  • Tracking changes and comments
  • Hiding and protecting formulas


Practical Applications 

  • The following human resource ( HR ) activities will be discussed as part of seminar. 
  • Payroll Computation 
  • Attendance and Tardiness Tracking 
  • Manpower Plantilla
  • Extracting Employee Information based on Demographics
  • Computing for Salary Distortion ( e.g Minimum Wage Implementation) 
  • Computing for Salary Structure 
  • Merit Pay/ Increase Budgeting

Exercise 1: Formulas

Exercise 2: Pivot Tables and Charts

Exercise 3: VLook up 

Exercise 4: Linking Worksheets

Final Exercise: Case Study ( Payroll and Compensation related )


 

Learning Investment

Reserve Your Spot NOW and SAVE Php. 2,000


(Pay on or before September 01, 2020)

Best Value Rate


P 3,998 + VAT

per Participant


(Group discount is given to 3 or more participants

from same organization.)

BFF Rate


P 4,998 + VAT

per Participant


(Minimum of 2 Participants)

Super Saver Rate

P 5,998 + VAT

per Participant

Pay on or before September 01, 2020



Early Bird Rate

P 6,998 + VAT

per Participant

Pay on or before September 17, 2020



Regular Rate

P 7,998 + VAT

per Participant

Pay on or before September 18, 2020



LEARNING INVESTMENT INCLUDES:


Enjoy a “Fun-filled” e-Learning experience, complete with online session materials

and e-certificate of attendance after online course completion.


PAYMENT METHOD

  • Paypal / Gcash / Paymaya
  • Credit Cards / Debit Cards 
  • Bank Transfer / Electronic Funds / Telegraphic Transfer
  • Direct Bank Deposit: Cash and Cheque 

Click here for the PAYMENT GUIDELINES

Claiming eCertificates


An eCertificate of Attendance will be awarded to participants who successfully completed the entire Virtual MasterClass.


Survey Online Questionnaire will be emailed after the e-Learning Event for participants to give feedback.


An eCertificate of Achievement will be emailed to the registered email address of the participants upon completion of the online Feedback Form.


Please ensure email address provided during registration is accurate or eCertificates may not be received.


Online Certificates will be available 3-5 days after the e-Learning Event.



OUR LIVE WEBINAR SERIES ARE

PURE 100% HIGH VALUE CONTENT!


View the Upcoming FREE Live Webinars: Click Here…


Unlock Your Dream e-Learning Journey Now! Click Here…


Virtual MasterClass Series powered by ARIVA Academy

UNLOCK

YOUR SPECIAL ACCESS AND RESERVE YOUR SPOT TODAY!


Did You Miss Our Live Webinars?


Watch the full session of our webinars and

get unlimited access on our YouTube Channels.

Subscribe to ARIVA Academy’s

YouTube Channel

Subscribe to ARIVA Talks

YouTube Channel

GENEROUS PARTNERS AND SPONSORS

DISPRZ LOGO
SALARYJET
ILAHUI
BOSSJOB
KITTLESON & CARPO LOGO
SERT TECHNOLOGY LOGO
ENCHANTED KINGDOM LOGO
PHINMA PROPERTY LOGO
COSMOTECH
HSBC LOGO

Stay on top of our insights and updates!

Join the ARIVA ACADEMY Facebook Group

Like ARIVA ACADEMY

facebook Page

Follow ARIVA ACADEMY LinkedIn Page

Visit our Website



FacebookLinkedInInstagramTwitterYouTubeEmail Address

ARIVA! Academy Philippines, Inc.

Betterliving Subdivision Brgy. Don Bosco, Parañaque City, 1711

Telephone: +632.8832-9901 | +632.8835-9354

Mobile: +63.917-325-7870