SIGN UP NOW!
It's FREE!

Create a Profile and Start Networking with HR Professionals
Register Now - It's Free Registration info
 
Member Content
Blogs | Questions | Files | Events | HR Groups | Members
PHR/SPHR Exam Prep Course
HRCI Recertification


Advertise Here

An Alternative HRIS Strategy, Using Excel and VBA

Topic:
An Alternative HRIS Strategy, Using Excel and VBA
Date:
June 12, 2012 at 1:30 - 2:30 PM ET
Presenters:
Roy Farrell, Managing Director(HR Value, LLC)
Svetozar Batoev, VBA Developer(HR Value, LLC)
webcastImgVirtual
Description
C-Suite credibility requires mastery of planning techniques and the ability to model pay and performance options quickly and clearly for a busy, non-specialist audience. This requires an enabling technology.

Technology promises to deliver solutions, but often falls short:

• Core HR technology solutions are built to address the very important compliance and administration tasks of their profession, largely driven by Payroll, Benefits, and record keeping. It is very difficult to develop robust planning tools or administer multiple approaches with a payroll system

• Even when using 'The Best’ software, you are tied to the capabilities and functionality of your HRIS system that often delivers a rigid and plain vanilla process.

• Add-on packages claim to solve your problems, but you soon discover you simply trade one set of limitations for another, or create information silos that restrict meaningful analysis - all at a considerable expense

• There is little interest in spending more money on expensive systems or system modifications that cannot demonstrate a positive ROI.

There are also many tasks for which there are no dedicated applications. These tasks need to be accomplished, and your day becomes consumed with paperwork or repetitive spreadsheets, which leads to higher costs and lower productivity. This is not what leadership wants.

There is an alternative. The bottom line is that you already have powerful software and a network available for employees to use, so the investment in software and computer infrastructure has already been made.

VBA allows construction of powerful and sophisticated business tools in Excel. We will give an overview of:

• The basic principles of the VBA language.
• The concept of a VBA project.
• The concept of a VBA procedure.
• How to manage and use VBA modules that store VBA code
• The basic operation of the VBA Editor

In addition, we will show some specific examples of what can be done to simplify any process, and the specific VBA code that is used to automate many time-intensive processes.

This will not be a VBA training course. We will show you an alternative to cumbersome spreadsheets, expensive system modifications, or costly “add on” software that usually trades one set of limitations for another and creates data silos. Excel and VBA can be part of an HRIS strategy that uses the core HRIS for what it does well, and Excel and VBA to give you all the ‘good stuff’ you need to be an effective business partner.
Who Should Participate
Anyone who wants to learn a new way to overcome the technology barriers to being an effective business partner.
What You Will Learn
1. There is an alternative to your rigid HRIS and cumbersome spreadsheets that is cost effective and powerful 2. Excel with VBA can create powerful and sophisticated business solutions that rival applications costing millions of dollars 3. We will present a 'road map' to the VBA process
Recommended Resources
There are many books on VBA
Communities
Compensation
Core HR: Payroll for HR and HRIS
Performance Management
Workforce Planning and Analytics
HR Scorecards
PM Metrics
Pay For Performance
Technology
ERP - Enterprise Resources Planning
HRIS Benefits
Total Compensation Management
Pay for Performance Planning and Management
Workforce Analytics - Strategic HCM
HCM and Integrated Financials
Compensation Measurement, Reporting and Analysis
Compensation Planning and Management
Compensation Modeling and Forecasting
ECS - Enterprise Compensation Solutions
Payroll
Sales force compensation
Compliance in Compensation Management
Salary Survey Planning and Management
Stock Planning and Administration
Pay for Performance Planning and Management
Presented by
spacer
speaker spacer
Roy Farrell
HR Value, LLC

View Profile
spacer
spacer
speaker spacer
Svetozar Batoev
HR Value, LLC

View Profile
spacer
Event Sponsors
HR Value, LLC
You want solutions, not more software. We provide the technology solutions to help manage customers, employees and information, so you can align talent, rewards with key business drivers. We have the tools to administer even the most complex prog
File List
Feedback
Name Comment Rating
Image of Leticia Watson Leticia Watson
CNA Financial Corporation
3 / 5
Good Presentation
Image of Shirley Yei Shirley Yei
IBM Corporation
2 / 5
Poor Presentation
Image of Catherine Rooney Catherine Rooney
Navistar, Inc.
3 / 5
Good Presentation
Image of TODD FAST TODD FAST
HOUSING HOPE
4 / 5
Very Good Presentation
4 / 5
Very Good Presentation
Image of Rebecca Becker Rebecca Becker
High Plains Library District
4 / 5
Very Good Presentation
4 / 5
Very Good Presentation
Image of Consuelo Foster Consuelo Foster
Northstar Aerospace - Chicago
5 / 5
Excellent Presentation
Image of Christina Zigler Christina Zigler
Legalzoom.com
5 / 5
Excellent Presentation
Image of Dalene Crowder Dalene Crowder
Verizon Telecom
4 / 5
Very Good Presentation
Image of Ben Mullins Ben Mullins
Spectrum Brands, Inc
3 / 5
Good Presentation
Image of Leon Audain-Jacobs Leon Audain-Jacobs
D's Audio Visual Solutions
3 / 5
Good Presentation
Image of Phillip Holt Phillip Holt
Unemployed
5 / 5
Excellent Presentation
Image of Robin Christianson Robin Christianson
Hennepin County Human Resouces
5 / 5
Excellent Presentation
3 / 5
Good Presentation
Image of Nancy Sweeterman, PHR Nancy Sweeterman, PHR
The E.W. Scripps Company
3 / 5
Good Presentation
Image of Claire Bedford Claire Bedford
Booz Allen Hamilton Corporate Headquarters
2 / 5
Poor Presentation
5 / 5
Excellent Presentation
Image of Ludovick Chong Ludovick Chong
Rocky Mountain Equipment
4 / 5
Very Good Presentation
Image of Annette Cassada Annette Cassada
Guilford County
5 / 5
Excellent Presentation
Image of Jennifer Riddick Jennifer Riddick
Rex Healthcare
3 / 5
Good Presentation
4 / 5
Very Good Presentation
Image of Jeremy Reah Jeremy Reah
Intact Insurance
4 / 5
Very Good Presentation
5 / 5
Excellent Presentation
Image of Carly Hoszkiewicz Carly Hoszkiewicz
Okemo Mountain Resort
3 / 5
Good Presentation
Image of Christina Choi Christina Choi
Scientific Research Corporation
3 / 5
Good Presentation
4 / 5
Very Good Presentation
Image of Julie DeVine Julie DeVine
Indiana Lumbermens Mutual Ins Co
4 / 5
Very Good Presentation
Image of Diane Clemens Diane Clemens
Minneapolis Public Schools
4 / 5
Very Good Presentation
2 / 5
Poor Presentation
Image of Ned Stainsby Ned Stainsby
DELAWARE NORTH
5 / 5
Excellent Presentation
Image of Angela Robinson Angela Robinson
Laurus Strategies
5 / 5
Excellent Presentation
Image of LaToya Massey LaToya Massey
RealPage, Inc.
5 / 5
Excellent Presentation
Image of Elvira Wolford, PHR Elvira Wolford, PHR
Bethune-Cookman University
3 / 5
Good Presentation
Image of Marie Friedman Marie Friedman
Post Holdings, Inc.
Can you please send the files that you referenced during the presentation to me? 4 / 5
Very Good Presentation
Image of Donald Sabathier Donald Sabathier
Sabathier & Associates
I think this topic is too complex for just a one hour presentation. Needs more time. 4 / 5
Very Good Presentation
Image of Dorothea Hills Dorothea Hills
Unemployed
I thought both of the speakers did an excellent job. I thought they spoke in terms that a prospective client would understand. Furthermore I believe they left the listener wanting to know more about the service / product. 4 / 5
Very Good Presentation
Image of Ericka Browne, SPHR-CA, GPHR Ericka Browne, SPHR-CA, GPHR
Blue Water Thermal Solutions
I would like to receive the examples. 5 / 5
Excellent Presentation
More on VBA Please send me his slides on the Excel VBA Screens. Thank you 5 / 5
Excellent Presentation
Image of Alethea Arnold Alethea Arnold
Wacker Siltronic Corp
Most valuable presentation yet. Can't wait to try some of what I learned. Thank You 4 / 5
Very Good Presentation

Do you have any comments that you would like to share about the value of this session?

Please help others considering viewing the archive understand the value of the session. How would you rate this presentation?
Excellent        Very Good        Good        Fair        Bad       

Are you becoming an industry expert? Each One Hour Webcast on HR.com is reviewed and can qualify for an Institute for Human Resources credit. The Institute for Human Resources Certification Program provides HR Professionals with an opportunity to specialize in one vertical or domain, making them an Industry Expert. Each of HR.com’s webcasts are reviewed and evaluated against the verticals/domains criteria, and one credit hour can be applied to the appropriate vertical or domain.
For more information regarding the IHR Certification Program, please click here or visit: http://www.hr.com/en/ihr_certifications/
Did you know that each one-hour webcast is submitted to qualify for HR Certification Institute recertification credits? The archive of the webcast also qualifies recertification credits, for one (in some cases two) year(s) after the original broadcast. You can get your PHR, SPHR, GPHR and credits all without ever leaving your desk. We know how busy today's successful HR professionals are, which is why we're committed to delivering the best education to you in an easy and entertaining format. For more information about certification or recertification, please visit the HR Certification Institute homepage at www.hrci.org
"The use of this seal is not an endorsement by HR Certification Institute of the quality of the program. It means that this program has met HR Certification Institute’s criteria to be pre-approved for recertification credit."
WorldatWork Society of Certified Professionals. Recertification credit for this event applies to the Certified Compensation Professional (CCP®), Certified Benefits Professional® (CBP), Global Remuneration Professional (GRP®), Work-Life Certified Professional (WLCP®), Certified Executive Compensation Professional (CECP™) and Certified Sales Compensation Professional (CSCP™) designations granted by WorldatWork Society of Certified Professionals.

Recertification credit for this event can be taken by entering it into your online WorldatWork Society recertification application and entering the program date, title and length. Please note that the CECP and CSCP designations require a minimum number of credits from executive and sales compensation-related activities. For more information on recertification, visit the WorldatWork Society recertification webpage at www.worldatworksociety.org/recertification.