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

  • Upcoming Events
  • Past Events
  • Public Events

More Virtual Conferences

9 April - 10 April 2014

Technology Enabled Learning

27 March - 28 March 2014

HR in California

My Events
View and edit your current events.
Add Event

Click the "add event" button to create a listing for your event

Advertise Here

An Alternative HRIS Strategy, Using Excel and VBA

An Alternative HRIS Strategy, Using Excel and VBA
July 11, 2012 at 11:00 - 12:00 PM ET
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.
Extra Learning Material

All Registered members are also eligible for:

  1. A copy of the slides presented in this presentation. These are available before and after the presentation.
  2. A Real Media file of the presentation. This file can be downloaded to your iPod or MP3 player after the presentation.
  3. Access to more than 400 podcasts with HR Gurus and Industry Leaders (downloadable files available 24 hours after the live broadcast) as well as access to our blogs, polls, surveys, 25,000+ article library, Business Book Reviews and so much more!
Recommended Resources
There are many books on VBA
Core HR: Payroll for HR and HRIS
Performance Management
Workforce Planning and Analytics
HR Scorecards
PM Metrics
Pay For Performance
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
Sales force compensation
Compliance in Compensation Management
Salary Survey Planning and Management
Stock Planning and Administration
Pay for Performance Planning and Management
What You Will Learn
  • There is an alternative to your rigid HRIS and cumbersome spreadsheets that is cost effective and powerful
  • Excel with VBA can create powerful and sophisticated business solutions that rival applications costing millions of dollars
  • We will present a 'road map' to the VBA process
Sponsored by
HR Value, LLC
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
Presented by
speaker spacer
Roy Farrell
HR Value, LLC

View Profile
speaker spacer
Svetozar Batoev
HR Value, LLC

View Profile
Who is Eligible

This webcast is available to all registered members for free. You are currently subscribed to as a Free Member.

Click the button to access this webcast. Archives, MP3 and PowerPoint slides

What is Required to Attend

Participants in the live webcast will need access to a computer connected to the Internet. highly recommends you test your computer in advance of the webcasts.

Once you register for the webcasts, full login instructions will be sent to you 24 and 2 hours prior to going live. You must run the system test to ensure you can access the session.


Name Comment Rating
5 / 5
Excellent Presentation
Image of Kristin Whitt Kristin Whitt
Children's Emergency Services
5 / 5
Excellent Presentation
Image of Alice Similien Alice Similien
Going Places Travel, Nassau, Bahamas
2 / 5
Poor Presentation
Image of Eddy Parham, SPHR Eddy Parham, SPHR
City Of Danville
1 / 5
Bad Presentation
Image of Nicole Dobson Nicole Dobson
Pacific Mortgage Group Inc.
2 / 5
Poor Presentation
Image of Nicholas Behrman Nicholas Behrman
Altria Client Services
1 / 5
Bad Presentation
Image of Ericca Nolan Ericca Nolan
Ozburn Hessey Logistics
2 / 5
Poor Presentation
3 / 5
Good Presentation
Image of Zulikat Abiola Zulikat Abiola
management transformation ltd
2 / 5
Poor Presentation
Image of Jim Perkins Jim Perkins
Self Employed
2 / 5
Poor Presentation
Image of Monica Brown Monica Brown
Roper St. Francis Healthcare
3 / 5
Good Presentation
Image of Lisa Weakland Lisa Weakland
Wythe Will Tzetzo
2 / 5
Poor Presentation
2 / 5
Poor Presentation
Image of Michelle Penoli Michelle Penoli
Fragomen, Del Rey, Bernsen & Loewy, LLP
2 / 5
Poor Presentation
Image of Olive Moore Olive Moore
Career Education Corporation
3 / 5
Good Presentation
Image of Shalini Kapoor Shalini Kapoor
St. Michael's Hospital
3 / 5
Good Presentation
Image of Lynne Logan Lynne Logan
Kearns Enterprises
3 / 5
Good Presentation
Image of Joseph Davis Joseph Davis
MEP Engineering
3 / 5
Good Presentation
Image of Krista Isselmann Krista Isselmann
Ktr Capital Partners
4 / 5
Very Good Presentation
5 / 5
Excellent Presentation
Garden Fresh Restaurant
"A test of the audio connection before the presentation started would have helped greatly. It was hard to follow along with all the interruptions at the beginning of the presentation. That being said 1 / 5
Bad Presentation
Image of Traci Jancasz Traci Jancasz
R.J. O''Brien & Associates
Are there full sessions available for tutorials on the VBA processes? I am very interested in using this program feature. 3 / 5
Good Presentation
Image of Arlene Haraden Arlene Haraden
Cablevision Systems Corporation
audio was poor as was slide progression. It was difficult at times to understand Svet and at times he seemed unprepared. I would like a copy of the slides as well. 3 / 5
Good Presentation
Image of Mhel Meyer Mhel Meyer
VMware, Inc.
I was really excited to attend this VBA webinar as this functionality something that we think we can use in our organization. I had a full understanding that this will be some of an introduction and I'd want to learn more. Given that this is a new topic the technical difficulty from start to finish made it VERY difficult to follow the presentation. Although I fully understand the benefits of it and would still like to learn more. 2 / 5
Poor Presentation
It is preferable if you could hold more courses on each topic so that we gain more information. 3 / 5
Good Presentation
Image of Richard Garcia Richard Garcia
WVU Healthcare
Please be better prepared to make full use of the short time available for your presentation. For these types of webinars it's unnecessary to spend time explaining what added value these tools bring to the table just show us how to use them. 2 / 5
Poor Presentation
Image of Greg Frueh Greg Frueh
Standard Register Co
Please send any information that you have on this topic. Thanks 4 / 5
Very Good Presentation
Image of Joyce Harrouff Joyce Harrouff
Lockheed Martin Corporation
Please send me the example code: 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 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’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:
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
"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

Sitemap   |   Advertise With Us