Sign for Notice Everyday    Sign Up| Sign In| Link| English|

Our Sponsors

    Receive Latest News

    Feedburner
    Share Us

    HR TRAINING 2021 - Excel Tools and Training for HR Professionals

    View: 132

    Website https://www.traininng.com/webinar/excel-tools-and-training-for-hr-professionals-202536live | Want to Edit it Edit Freely

    Category HR TRAINING 2021

    Deadline: June 02, 2021 | Date: June 02, 2021

    Venue/Country: Online event, U.S.A

    Updated: 2021-04-28 13:37:09 (GMT+9)

    Call For Papers - CFP

    Overview

    HR professionals frequently supervise, manage and/or analyze and report many types of HR data. This overflow of personnel data ranges from employee time sheets to payroll records to department, divisional and company-wide employee information including: hiring date, salary, position, employee class, department, division, employee evaluation ratings and much more.

    90 minutes of concise, focused Excel training designed specifically for HR professionals can simplifying these tasks for you. You will learn how to use Excel to track and report your most frequently reported and analyzed HR data.

    HR Professionals will learn Excel tips and techniques that will save hours of time resolving the difficulties you face on a daily basis in completing and analyzing employee time sheets, payroll, company-wide reports and more!

    This webinar is also helpful for professionals who do not work in HR but are administrative or supervisory personnel who want to learn how to better utilize Excel.

    Why you should Attend

    Calculate hours worked and sick leave or vacation leave for each work period on an employee time sheet using Excel date and time arithmetic

    "Time and date-stamp" your documents automatically

    Calculate periodic payroll from an employee time sheet

    Display first name, last name with prefix in one single column from three different columns, or vice versa

    Find years of service of employees and instantly highlight senior employees

    Highlight above and below average performers, instantly, for thousands of employees

    Highlight employees earning over $100,000 per year instantly and count them department-wide and by department

    Extrapolate the top five percent of earners (or top 50 earners) from a data base of over 100,000 employees - instantly

    Find the total salary expenses in different regions, different departments - instantly!

    Total the number of employees in the company and in different departments and average their salaries by department - instantly!

    Find the total salary given to employees of a particular department or designation

    Find number of employees joined on particular date/month in any department or employee classification for the entire company - instantly

    Count number of employee titles in each department of the company or for the entire company and calculate the total salaries, instantly

    Display the records according to department, by hire date, by salary etc.

    View summarized salary for all the different departments

    Find total number of employees working in specific department from specific dates

    Highlight above and below average performers - instantly

    Calculate the number of working days between dates easily and instantly

    Calculate the total days between dates easily and instantly

    Group employees into useful categories by salary, year of hire, more - instantly!

    Obtain a strong introduction to the power of Excel Pivot Tables

    See how to create an HR Excel KPI Dashboard

    View the Next Level of Computer Power and AI: Microsoft Power BI

    Areas Covered in the Session

    The Excel tools you will learn how to use in just 90 minutes include:

    Date and Time Arithmetic for Employee Time Sheets and Much More

    Date and Time Formatting and "Date/Time Stamping"

    Conditional Formatting to Highlight HR Required Information

    Password Protection for Sensitive Excel Payroll Files

    How to Hide and Password Protect Sensitive Worksheets and Columns

    Special Formatting Only You Can See for Salary Information

    How to Use Excel Tables for Special HR Related Reporting and Analysis Tasks

    Specific HR Examples covered include:

    Periodic attendance and leave reports

    Payroll

    Divisional and Company-Wide HR Administration/Reporting and Analysis

    Who Will Benefit

    This Special Excel Instruction is Designed for New and Experienced HR professionals from:

    Administrative Professionals

    Compensation and Benefits Professionals

    HR Reward and Payroll Professionals

    HR Managers and Directors

    Anyone who perform HR functions in their organizations on daily basis

    Also:

    All Administrative Assistant and Supervisor with a working knowledge of Excel

    All Managers who want to improve their Excel skills

    Speaker Profile

    Joseph Weil has a Master of Accounting Degree from Florida State University and is an actively licensed Florida CPA. Joe’s work experience includes staff accountant with large CPA firm, corporate controller, state agency director of auditing and former municipal CFO. Joe also started and sold his own CPA firm. Joe is the owner and CEO of the National Center for Continuing Education, a nation-wide financial and technology training firm. Joe has led over 500 seminars and over 100 webinars.

    Past in-house seminar/webinar clients have included Harley-Davidson, Hewlett-Packard, General Mills, Oracle, Burger King, Deloitte, Florida Power and Light and many similar organizations.


    Keywords: Accepted papers list. Acceptance Rate. EI Compendex. Engineering Index. ISTP index. ISI index. Impact Factor.
    Disclaimer: ourGlocal is an open academical resource system, which anyone can edit or update. Usually, journal information updated by us, journal managers or others. So the information is old or wrong now. Specially, impact factor is changing every year. Even it was correct when updated, it may have been changed now. So please go to Thomson Reuters to confirm latest value about Journal impact factor.