Park Avenue Presentations: Coping with an Employee's Mental Illness: Relevant Laws and Best Practices

Use Excel to Measure HR Performance

Wednesday, June 10, 2020 at 1:30 pm ET

Duration: 90 minutes

Special Feature: If you register for this webinar and cannot attend, you will be able to access a one-time instant replay without charge for up to 90 days after the date of the webinar.

Bonus for Each Registrant: The webinar speaker will answer one written question that you may submit by email within one week after the webinar.

Webinar Description

HR analytics is the process of creating metrics, obtaining relevant data, and analyzing data to describe and predict human capital information. This is often referred to as big data. HR metrics are the guide to determine what data can be used to quantify the cost and the impact of talent management programs. These data analysis results will inform HR process optimization and maximize the success of HR initiatives.

EXCEL is a great tool for turning complex information into more simple snapshots to inform your stakeholders, as well as organize your data. This course is meant for HR professionals who want to gain skillsets necessary to work with functions and lists, analyze data, and use PivotTables and PivotCharts.

Upon course completion you will be able to create advanced workbooks and worksheets that provide a more in-depth understanding of organizational intelligence. The end goal of this course is for attendees of this webinar to be able to analyze massive amounts of data, extract actionable information from it, and present that information to decision makers at a high level.

AGENDA

Create HR metrics that are relevant and aligned with organizational goals by using Page Setup
Use Other Excel Functions
Use Conditional and Custom Formats
Create Web Based External Objects
Use AutoFilter
Work with Tables
Use Large Worksheets

Logistics

90-minute webinar (Travel-Free) delivered over the Internet.
Unlimited listeners per connection - bring the entire department.
Q&A session with the expert.

This event will be presented live with a PowerPoint presentation to be viewed on your computer. You may listen to the audio of the webinar by telephone or through your computer. The PowerPoint slides will be provided shortly before the event. Once you register, you will receive an email which is your receipt and which includes your instructions for dialing in and logging on. You will also receive an email reminder 24 hours before the webinar.

What is a webinar?

A webinar is a live Internet based seminar. Webinars are a way for participants in many different locations to see and hear a presentation and view PowerPoint slides. You can also have your colleagues attend the webinar using one connection.

What kind of equipment do I need?

You will need a computer with an Internet connection (high speed service such as DSL or cable works best) and a telephone. You may listen to the webinar through your computer speakers, in which case you will not need to use a telephone connection. Internet access is not required for phone-only participants, but you will not be able to see the speaker’s slides.

How can I share the webinar with my colleagues who may not be able to attend the event?

CDs of each program will be available for sale and can be shared with your business associates.

Can I get a copy of the PowerPoint slides used in the webinar?

The PowerPoint slides will be available on the materials page link in the confirmation email that will be sent to you no later than the morning of the day a webinar is presented.

How do I ask a question during the webinar? Will my question be answered during the presentation?

A question and answer session will be scheduled at the end of each webinar. You can then ask a question by typing it into the question box that will be provided to you duringthe webinar. You may also ask a question through the telephone connection. As many questions as possible will be answered during the Question and Answer period.