Excel for HR Management Professionals

Wednesday July 17, 2019
1:30 pm - 3:00 pm ET
90 minutes

Register for Live Webinar: $219

Register for Live Webinar Plus Recording Download: $329

Register for Live Webinar Plus CD (includes shipping and handling): $369

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.

 

Description

Excel is one of the most powerful tools in today’s workplace. You will almost always see in job postings for management jobs, including HR positions, that Excel skills are required.  HR professionals need to organize, analyze and communicate data, which is the purpose of Excel.

In HR, it is virtually impossible to do compensation, benefits, project management or any HR function without knowing some Excel, and it is impossible to be a true business partner without knowing Excel. Using Excel is not merely having the ability to enter names into lists. Excel saves you time while bringing understanding to piles of data. Before Excel, it could take weeks to organize, analyze and present data that can now be accomplished better in an afternoon.

The power of Excel is the ability to use the data entered into its spreadsheets to perform mathematical calculations as well as other financial functions. Excel’s functions can provide answers for simple to complex statistical and financial questions. Pivot tables allow you to slice and dice data to gather significance from data. Connections between data can be represented visually as charts, graphs, or histograms to provide better understanding.



Agenda

This webinar will teach you the basics of Excel functions at which today’s HR management professionals are expected to be proficient.

  • Customizing Excel.
  • Using date functions.
  • Formatting sheets and cells.
  • Creating formulas.
  • Nested functions.
  • Database functions.
  • Data protection.
  • Importing and exporting data.
  • Creating charts from your data.
  • Building a simple Pivot Table.
  • Building a basic Gantt Chart.
  • Using printing and page layout functions.  

Faculty

Teri Morning, MBA, MS, SHRM-SCP, specializes in solving company “people problems” and linking employee performance with compensation. Teri also sources software solutions for employee relations, compensation and performance management. Teri has over 15 years human resource and training experience in a variety of professional fields, including retail, distribution, architectural, engineering, consulting, manufacturing (union), public sector and both profit and non-profit company structures.

Teri has enjoyed consulting with employers on their problems and trained managers and employees for over 15 years, meeting and working with employees from all types of businesses. In addition to a MBA, Teri has a Master’s degree in Human Resource Development with a specialization in Conflict Management. She was certified by the State of Indiana in mediation skills, is certified in Project Management and IT Management, qualified as a Myers-Briggs practitioner and holds the SHRM certification of a Senior Certified Professional.


 

Continuing Education Information
 

Approved Provider

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.

SHRM Recertification Provider

Continuing SHRM Credit
Park Avenue Presentations is recognized by SHRM to offer Professional Development Credits (PDCs) for the SHRM-CPSM or SHRM-SCPSM. This program is valid for 1.5 PDCs for the SHRM-CPSM or SHRM-SCPSM. For more information about certification or recertification, please visit www.shrmcertification.org


 

Webinar Overview

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

Register for Live Webinar: $219

Register for Live Webinar Plus Recording Download: $329

Register for Live Webinar Plus CD (includes shipping and handling): $369

Click Here to See Other Upcoming Park Avenue Presentations Webinars