Excel Tools and Training for HR Professionals


Instructor: Joe Weil
Product ID: 706725

  • Duration: 90 Min
HR professionals frequently supervise, manage and/or analyze and report many types of HR data. This overflow of personnel data ranges from employee timesheets to payroll records to the department, divisional and company-wide employee information including hiring date, salary, position, employee class, department, division, employee evaluation ratings, and much more. This 90-minutes of concise, focused Excel training designed specifically for HR professionals can simplify these tasks for you.
Purchase option for this webinar is currently unavailable. Please contact our Customer Care for more info. Webinar All Access Pass Subscription


Customer Care

Fax: +1-650-362-2367

Email: [email protected]

Read Frequently Asked Questions


Why Should You Attend:

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 resolving the difficulties you face daily in completing and analyzing employee timesheets, 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.

Learning Objectives:

At the end of 90 minutes, you will learn how to do the following:

  • 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 Webinar:

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:

  • 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
Instructor Profile:
Joe Weil

Joe Weil

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

Mr. Weil earned his Master of Accounting Degree at Florida State University. His training clientele include Harley-Davidson, Hewlett-Packard, Oracle, Deloitte, Florida Power and Light, Motorola, National Institute of Science and Technology, and many others.

Follow us :



Refund Policy

Our refund policy is governed by individual products and services refund policy mentioned against each of offerings. However in absence of specific refund policy of an offering below refund policy will be effective.
Registrants may cancel up to two working days prior to the course start date and will receive a letter of credit to be used towards a future course up to one year from date of issuance. ComplianceOnline would process/provide refund if the Live Webinar has been cancelled. The attendee could choose between the recorded version of the webinar or refund for any cancelled webinar. Refunds will not be given to participants who do not show up for the webinar. On-Demand Recordings can be requested in exchange. Webinar may be cancelled due to lack of enrolment or unavoidable factors. Registrants will be notified 24hours in advance if a cancellation occurs. Substitutions can happen any time. On-Demand Recording purchases will not be refunded as it is available for immediate streaming. However if you are not able to view the webinar or you have any concern about the content of the webinar please contact us at below email or by call mentioning your feedback for resolution of the matter. We respect feedback/opinions of our customers which enables us to improve our products and services. To contact us please email [email protected] call +1-888-717-2436 (Toll Free).




6201 America Center Drive Suite 240, San Jose, CA 95002, USA

Follow Us

facebook twitter linkedin youtube


Copyright © 2023 ComplianceOnline.com MetricStream
Our Policies: Terms of use | Privacy

PAYMENT METHOD: 100% Secure Transaction

payment method