Microsoft Excel For HR

Microsoft Excel for HR

Duration: One day

Prerequisites: This course requires that you are familiar with Excel. It is suggested that you successfully completed Excel 1 and Excel 2, or had more than 6 months using the software.

Description:

Is your HR Department wasting time manipulating canned reports from HCM and payroll systems? Do you need help accessing and analyzing data quickly? Are data errors causing you concerns? Whether auditing, reconciling bills, calculating bonuses and PTO, or analyzing turnover data, Excel offers tools to help. Based on guidance from HR experts and our interaction with supporting members, we identified the most common and helpful Excel tips that can benefit new and experienced HR individuals.

The course explores using lookups to pull information out of multiple workbooks, bringing in delimited information from other sources, filtering information, using date calculations to figure out things like tenure and turnover, visually representing data to make it simple to review, and many tips and tricks that can help most every Excel user increase their productivity and decrease errors.

Contents:

 Just some of what you will learn!!

• Introduction to Lookup Functions
• Date and Time Functions
• Count Functions
• If Functions
• Conditional Formatting
• Advanced Filtering options
• Changing comma delimited data into separate columns
• Navigation and Selection Time Savers
• Splitting text into additional columns
• Much, much more

*NOTE: Half , Full & Multi-Day Computer Skills classes are not eligible for AAIM’s All Access Training Pass usage.

*Registration will close TEN business days prior to the event.

For Cancellation/Reschedule and Inclement Weather Policy please click HERE

HRCI Accreditation:

N/A|N/A|N/A

---

SHRM Accreditation:

N/A|N/A|N/A

---

CPE Accreditation:

Professional Development Credits Awarded: 7 Recommended

AAIM Employers’ Association is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.learningmarket.org.|Professional Development Credits Awarded: 7 Recommended

AAIM Employers’ Association is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.learningmarket.org.|Professional Development Credits Awarded: 7 Recommended

AAIM Employers’ Association is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.learningmarket.org.