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


  • Upcoming Events
  • Past Events
  • Public Events
My Events
View and edit your current events.
Add Event

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

Advertise Here

Automate your Spreadsheets – Part 2

Topic:
Automate your Spreadsheets – Part 2
Date:
February 20, 2013 at 11:00 - 12:00 PM ET
Presenters:
Roy Farrell, Managing Director(HR Value, LLC)
Kenn Williamson, Consultant(HR Value LLC)
webcastImgVirtual
Description
Technology promises to deliver solutions, but often falls short because 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.

In Part I, we showed how 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. It would be helpful to review this presentation prior to viewing Part 2.
http://www.hr.com/en/webcasts_events/webcasts/archived_webcasts_and_podcasts/automate-your-spreadsheets-%E2%80%93-using-excel-and-vba-p_h7v5td2z.html

VBA allows you to automate the spreadsheets, and develop powerful and sophisticated business tools in Excel. If you regularly use spreadsheets to produce a series of monthly charts and reports, or send spreadsheets to managers, you can have VBA do the same task for you in a matter of seconds.

Part 1 provided an overview of:
• Why the Macro recorder simply doesn’t work
• 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

We use the specific example of Salary Planning Tools to show how you can use VBA code to automate many time-intensive processes in developing tools, such as importing data . Part 2 will focus on using GUIs to develop a flawless and foolproof workflow. We will show you how ‘Userforms’ in VBA can display information and allow you input data.

We will show:
• The input box and the message box
• Creating a Userform
• Calling and Hiding a Userform
• Adding controls to an existing form
• Using Basic form controls
• Adding Option buttons to a userform

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.
Who Should Participate
Any HR professional. Not necessarily to lear VBA, but to understand the power of this sophisticated tool
What You Will Learn
  1. VBA with Excel can automate spreadsheets, and create powerful and sophisticated business solutions. All with the software you already have on your desktop
  2. Userforms and GUIs can create a flawless and foolproof workflow
  3. How to build a userform
Recommended Resources
There are numerous books on Excel and VBA. Look for the one that suits your learning style
Communities
Benefits
Compensation
Human Resources Management
Core HR: Payroll for HR and HRIS
Training and Development
Performance Management
Workforce Planning and Analytics
Rewards and Recognition
Presented by
spacer
speaker spacer
Roy Farrell
HR Value, LLC

View Profile
spacer
spacer
speaker spacer
Kenn Williamson
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
2 / 5
Poor Presentation
Image of Stacey Riden, PHR Stacey Riden, PHR
Microvision Inc.
4 / 5
Very Good Presentation
Image of Carolyn Keogh Carolyn Keogh
The Timken Company
4 / 5
Very Good Presentation
Image of Milagros Franco Milagros Franco
Bacardi U.S.A., Inc.
3 / 5
Good Presentation
Image of Jason Walker Jason Walker
Hewlett-Packard, Plano, TX
5 / 5
Excellent Presentation
4 / 5
Very Good Presentation
Image of Heather Courville Heather Courville
Coca-Cola Enterprises Inc. (Corporate Headquarters)
4 / 5
Very Good Presentation
Image of Lynette Harris, PHR Lynette Harris, PHR
Kaleidoscope Inc
3 / 5
Good Presentation
Image of Antonius Tran Antonius Tran
Syniverse Technologies
4 / 5
Very Good Presentation
Image of Annette Cassada Annette Cassada
Guilford County
4 / 5
Very Good Presentation
3 / 5
Good Presentation
Image of Michelle Rancourt Michelle Rancourt
Easter Seals New Hampshire
4 / 5
Very Good Presentation
Image of Phyllis Cayenne Phyllis Cayenne
Visionary Graphics Inc
4 / 5
Very Good Presentation
Image of Bernadette Bondoc Bernadette Bondoc
Farmers Insurance
4 / 5
Very Good Presentation
Image of Sayyad Imran Sayyad Imran
CDI Corporation
4 / 5
Very Good Presentation
Image of Mike Hammer Mike Hammer
Independent Consultant
4 / 5
Very Good Presentation
Image of Michelle S Michelle S
New York Community Bancorp Inc
4 / 5
Very Good Presentation
5 / 5
Excellent Presentation
Image of Margie Gyurisin Margie Gyurisin
Summit Health Chambersburg Hospital
4 / 5
Very Good Presentation
Image of Luis504 Mendez Luis504 Mendez
Myron Corp
5 / 5
Excellent Presentation
Image of Iliana Howes Iliana Howes
JBS USA LLC
3 / 5
Good Presentation
4 / 5
Very Good Presentation
Image of Kelly Marshall, PHR Kelly Marshall, PHR
Parkview Adventist Medical Center
5 / 5
Excellent Presentation
Image of Kari Steele Kari Steele
Ace Parking Management, Inc.
5 / 5
Excellent Presentation
Image of Vicki Costello Vicki Costello
University Of South Florida Physician Group
5 / 5
Excellent Presentation
Image of Kathy Dunbar Kathy Dunbar
City of Peoria, AZ
3 / 5
Good Presentation
Image of Katherine Naranjo Katherine Naranjo
Matthews Benefit Group, Inc
5 / 5
Excellent Presentation
Image of Kristal Morales Kristal Morales
CFE Management Group, LLC
5 / 5
Excellent Presentation
Image of Elizabeth Gage Elizabeth Gage
American Red Cross
3 / 5
Good Presentation
4 / 5
Very Good Presentation
Image of Kelly Shaw Kelly Shaw
St. Louis Public Schools
4 / 5
Very Good Presentation
Image of Ann Watson Ann Watson
Suncoast Hospice
3 / 5
Good Presentation
Image of Michelle Trajanovska Michelle Trajanovska
North Carolina State University
4 / 5
Very Good Presentation
Image of Michael Dougherty Michael Dougherty
Mercy Health System
Can you please send the files from Part 1? Thanks 4 / 5
Very Good Presentation
Image of Lou Anne Geissler Lou Anne Geissler
State of Nevada - DMV Personnel Services
do you have any spreadsheets working with FMLA tracking forms usage etc.? 4 / 5
Very Good Presentation
Image of Wendy Alexander Wendy Alexander
Cold Spring Harbor Laboratory
I enjoyed the presentation and it inspired me to learn more about Excel and VBA. I missed Part One and will watch it now because I would have liked to see how one little piece of VBA code was created tested and placed within Excel to know how to get started. I would like you to send examples Excel files of VBA code to me.Thank you 4 / 5
Very Good Presentation
Image of Ryan Burns Ryan Burns
Echo Global Logistics
I enjoyed the presentation and was hoping to get the code examples for reference. Thanks in advance! 3 / 5
Good Presentation
Image of Kimberly McLean Kimberly McLean
URS Corporation
I was completely lost. I signed up for webinar and it seems as if I missed something. This format is very confusing. I couldn't figure out how to ask questions. I give up. 3 / 5
Good Presentation
Image of Cheryl Sullivan Cheryl Sullivan
LeaseTeam, Inc.
I wasn't able to get into the presentation right away. Still new to this whole virtual conference thing. I think there needs to be breaks between presentations for bio breaks and work stuff. This presentation was all over and didn't follow his slides very well. 3 / 5
Good Presentation
Image of Malabika Das Malabika Das
Planned Parenthood Federation of America, Inc.
I would like the examples sent to me. Thank you! 4 / 5
Very Good Presentation
Image of Julia Di Renzo Julia Di Renzo
VistaPrint Spain
"I would like to receive the excel files with the VBA examples presented in this presentaion. If I could also get the examples from ""automating your spreadsheets part1"" that would be even better. My name is Julia I am the HR Analyst for Vistaprint HR Strategy Planning & Analytics team. Many thanks!" 4 / 5
Very Good Presentation
Image of Kamarrah Killion Kamarrah Killion
Missouri Botanical Garden
"I would like to receive the VBA code from part 1 & part 2 sessions so I can begin leverage Excel more in my day to day work operations. Also what books did you recommend using; the audio broke up before I could hear your recommendations. Thanks again for sharing this information. I just had an Oprah ""Ah Ha"" moment." 5 / 5
Excellent Presentation
Image of Olga Valencia Olga Valencia
Universidad de Burgos
I would like you to send me the spreadsheets of the example. Thank you 3 / 5
Good Presentation
Image of Melinda Wade Melinda Wade
Automobile Club of Missouri
I would love to have a copy of the VBA Code Examples please. I'm going to view the part one when I get a chance. 5 / 5
Excellent Presentation
Image of Frank Lyons Frank Lyons
Director
Missed presentation due to system failure would like Examples you discussed. Thanks 3 / 5
Good Presentation
Image of Sarah Bratcher Sarah Bratcher
Catalina Foothills School District
Please send excel files 5 / 5
Excellent Presentation
Image of Brian Allen Brian Allen
Northeast Georgia Medical Center
Please send me any materials mentioned today for Part I and Part II. Thanks for the excellent Webinar! 5 / 5
Excellent Presentation
Image of J Hock J Hock
Daiichi Sankyo, Inc.
Please send template mentioned at end of presentation 3 / 5
Good Presentation
Image of Sandra McMullen Sandra McMullen
Tech Data Corporation
Please send the me formula spreadsheets. Thank you! 4 / 5
Very Good Presentation
Image of Debbie Suettinger Debbie Suettinger
Broadwind Towers and Heavy Industries
please share template by sending. thanks much! 4 / 5
Very Good Presentation
Terrific info. Great ideas. Showing examples is great. 4 / 5
Very Good Presentation
Image of Tim Keeler Tim Keeler
Virginia Mason Medical Center
Thanks! I would like to receive the Excel files used in the presentation as well as part one of the presentation and any associated Excel files for that. 4 / 5
Very Good Presentation
The speaker mentioned some excel examples that could be sent upon request. I would like to receive those please. 4 / 5
Very Good Presentation
Image of T. Russell Walker T. Russell Walker
Deseret Mutual
The VBA stuff was more technical than what I can personally do but I got a lot of ideas that I can use with the help of our technical staff. Thanks. 4 / 5
Very Good Presentation
Image of Miriam Berger Miriam Berger
A Hire Authority

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.