BEGIN:VCALENDAR
PRODID:NingEventWidget-v1
VERSION:2.0
METHOD:PUBLISH
BEGIN:VTIMEZONE
TZID:America/New_York
X-LIC-LOCATION:America/New_York
BEGIN:DAYLIGHT
TZOFFSETFROM:-0500
TZOFFSETTO:-0400
TZNAME:EDT
DTSTART:19700308T020000
RRULE:FREQ=YEARLY;BYMONTH=3;BYDAY=2SU
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:-0400
TZOFFSETTO:-0500
TZNAME:EST
DTSTART:19701101T020000
RRULE:FREQ=YEARLY;BYMONTH=11;BYDAY=1SU
END:STANDARD
END:VTIMEZONE
BEGIN:VEVENT
UID:2140535:Event:468430
DTSTAMP:20260523T221246Z
SUMMARY:Excel Tools and Training for HR Professionals
DESCRIPTION:Overview\n\nHR professionals frequently supervise, manage 
 and/or analyze and report many types of HR data. This overflow of pers
 onnel data ranges from employee time sheets to payroll records to depa
 rtment, divisional and company-wide employee information including: hi
 ring date, salary, position, employee class, department, division, emp
 loyee evaluation ratings and much more.\n90 minutes of concise, focuse
 d Excel training designed specifically for HR professionals can simpli
 fying these tasks for you. You will learn how to use Excel to track an
 d report your most frequently reported and analyzed HR data.\nHR Profe
 ssionals will learn Excel tips and techniques that will save hours of 
 time resolving the difficulties you face on a daily basis in completin
 g and analyzing employee time sheets, payroll, company-wide reports an
 d more!\nThis webinar is also helpful for professionals who do not wor
 k in HR but are administrative or supervisory personnel who want to le
 arn how to better utilize Excel.\n  \n\nWhy you should Attend\n\n\nC
 alculate hours worked and sick leave or vacation leave for each work p
 eriod on an employee time sheet using Excel date and time arithmetic\n
 \"Time and date-stamp\" your documents automatically\nCalculate period
 ic payroll from an employee time sheet\nDisplay first name, last name 
 with prefix in one single column from three different columns, or vice
  versa\nFind years of service of employees and instantly highlight sen
 ior employees\nHighlight above and below average performers, instantly
 , for thousands of employees\nHighlight employees earning over $100,00
 0 per year instantly and count them department-wide and by department\
 nExtrapolate the top five percent of earners (or top 50 earners) from 
 a data base of over 100,000 employees - instantly\nFind the total sala
 ry expenses in different regions, different departments - instantly!\n
 Total the number of employees in the company and in different departme
 nts and average their salaries by department - instantly!\nFind the to
 tal salary given to employees of a particular department or designatio
 n\nFind number of employees joined on particular date/month in any dep
 artment or employee classification for the entire company - instantly\
 nCount number of employee titles in each department of the company or 
 for the entire company and calculate the total salaries, instantly\nDi
 splay the records according to department, by hire date, by salary etc
 .\nView summarized salary for all the different departments\nFind tota
 l number of employees working in specific department from specific dat
 es\nHighlight above and below average performers - instantly\nCalculat
 e the number of working days between dates easily and instantly\nCalcu
 late the total days between dates easily and instantly\nGroup employee
 s into useful categories by salary, year of hire, more - instantly!\nO
 btain a strong introduction to the power of Excel Pivot Tables\nSee ho
 w to create an HR Excel KPI Dashboard\nView the Next Level of Computer
  Power and AI: Microsoft Power BI\n\n\n\n\n\n\nFor more information vi
 sit https://medtechiq.ning.com/events/excel-tools-and-training-for-hr-
 professionals
DTSTART;TZID=America/New_York:20210602T100000
DTEND;TZID=America/New_York:20210602T110000
CATEGORIES:online, event
LOCATION:Online event
WEBSITE:https://www.traininng.com/webinar/excel-tools-and-training-for
 -hr-professionals-202536live
URL:https://www.traininng.com/webinar/excel-tools-and-training-for-hr-
 professionals-202536live
CONTACT:5109628903
ORGANIZER;CN="Joseph Wilcox":https://medtechiq.ning.com/profile/Joseph
 Wilcox
ATTACH;FMTTYPE="image/jpeg":
ATTENDEE;ROLE=REQ-PARTICIPANT;PARTSTAT=ACCEPTED;RSVP=TRUE;CN="Joseph W
 ilcox":https://medtechiq.ning.com/profile/JosephWilcox
END:VEVENT
END:VCALENDAR