Excel for Human Resource Professionals
Duration: 90 minutes
Speaker: Melissa Esquibel
Webinar Description
As an HR professional, you keep getting more and more data, and getting asked to report it in more and different ways. Feeling overwhelmed? We’ve got help!
Excel has long been considered the premier tool for crunching numbers and communicating data. But, if all you have at your disposal is what you were able to learn on your own, it’s probably not enough to get the job done efficiently and effectively. Benefits, compensation, and human resource professionals have deep, wide datasets that lengthen and broaden over time. Your organization’s managers and executives are clamoring for reports to help them make decisions about people and pay. If this job falls to you, Excel can offer just about everything you need. Microsoft Certified Trainer Melissa Esquibel will help you pack your toolbox to the brim with what you need to get the job done right. Not only will you learn to do things the right way (instead of the long way), you’ll reduce, if not eliminate frustrating and error-prone manual processes.
Know how to employ:
-
Big List Tools & Techniques
-
List Repair Tools (Text functions, and Data Tools)
-
Date Math
-
Table Style Formatting
-
Basic Pivots and Dashboards
Agenda
In this session you’ll learn:
-
How to take the huge datasets you get and turn them into high-functioning flat databases so you can take advantage of Excel’s robust toolset.
-
How to analyze multiple sets of data at once using lookups and data models
-
How to wrangle date data to give you exactly the metrics you’re looking for
-
The right way to use Pivot Tables and Charts for fast and effective reporting.
Technical Considerations
The session will be presented from Excel 2016 and Excel 2010, but will be applicable to all versions of Microsoft Office from 2007 forward.
It is recommended that you dial in about 10-15 minutes before the start time of the webinar to ensure you will get the full visual benefit. You will be asked what version of the software you are using in the Question and Answer period, and Melissa will be happy to adjust her answers to suit the version you are using.
CONTINUING EDUCATION
Continuing HRCI Credit Information
This program has been pre-approved for 1.5 hours of General recertification credit hours through the HR Certification Institute. Use of the seal is not an endorsement by the HR Certification Institute of the quality of the program. It means that this program has met the HR Certification Institute's criteria to be pre-approved for recertification credit.
Continuing Legal Education Credit Information
This webinar has been approved in the following states for continuing legal education credit by The Marino Legal Academy:
California: 1.5 credit hours
The Marino Institute for Continuing Legal Education is a State Bar of California approved MCLE sponsor and this course qualifies for 1.5 credit hours of participatory CLE credit.
New Jersey: 1.5 credit hours
This webinar has been approved by the Board on Continuing Legal Education of the Supreme Court of New Jersey for 1.5 CLE credit hours.
New York: 1.5 areas of professional practice credit hours
This course has been approved in accordance with the requirements of the New York Continuing Legal Education Board for veteran attorneys for 1.5 credit hours, of which 1.50 credit hours may be applied toward the Areas of Professional Practice.
Pennsylvania: 1.5 credit hours
This Distance Learning program has been approved by the Pennsylvania Continuing Legal Education Board for 1.5 hours of substantive law, practice and procedure CLE credit.
To receive CLE credit for this webinar in those states, please request such credit by writing toinfo@parkavenuepresentations.com. Your request will be forwarded to The Marino Legal Academy for processing.
CLE credit for this webinar may also be awarded in a number of other jurisdictions. For more information, please contact a Marino Legal Academy legal education consultant at (212) 249-3779,x104.
Logistics
- 90 minutes (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.