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

Upcoming Conference
24 April - 25 April 2014

Rewards and Recognition

Upcoming Conference
29 April - 30 April 2014

Quality of Hire

Upcoming Conference
5 May - 6 May 2014

Performance Management

My Events
View and edit your current events.
Add Event

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

Advertise Here
Event Calendar / An Alternative HRIS Strategy, Using Excel and VBA
Details & Time Frame
An Alternative HRIS Strategy, Using Excel and VBA
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.
06/12/2012 1:30 pm o'clock
06/12/2012 2:30 pm o'clock
Roy Farrell

Webcast information

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
View full details
Speakers You must be logged in to view speakers
Approved by This event has been approved by


Type last name, first name or company.

Type last name, first name, company or email address

Enter a personal message that will be sent to the recipients above

Link Use the following code to link to this event in your emails or website:
Sitemap   |   Advertise With Us