Excel Techniques for HR, Benefits and Compensation Professionals

Duration: 90 Minutes
You're not getting any less data. And, you're getting asked to report it in more and more ways. HR, Compensation and Benefits professionals have to deal with a wide variety of data from many disparate sources. And your data is deep and wide unlike many other types of data. It can get a little overwhelming getting everything to work together. If all you have at your disposal is what you were able to learn on your own, it's probably not enough to get the job done efficiently and effectively. Excel can offer just about everything you need, if you know where to look for the tools. Microsoft Certified Trainer Melissa Esquibel can help uncover these and pack your toolbox to the brim. As a business owner, Melissa has learned to leverage her business data for year-over-year success. As an Excel instructor, she has the benefit of knowing just what tools are available to approach nearly any data challenge.
Excel Guidance for HR
Instructor: Melissa P Esquibel
Product ID: 504562
Objectives of the Presentation
  • Effectively importing data from various sources
  • Getting data in the right shape to optimize the Excel tool set
  • Efficiently scrubbing data with text functions and other tools
  • Effectively leverage tables, pivot tables, and the PowerPivot add-in to quickly crunch millions of data records
  • Easily generate reports, dashboards and other tools for the end-user
  • Wrangle date math to yield what you need with rounding or scrubbing up infinitesimal decimal differences
Why Should you Attend
Big data is just getting bigger. There's more and more of it and more and more to gain from it. Now is the time to acquire the skills needed to do this effectively and efficiently. Knowing how to leverage the powerful tools in Excel can set you apart from your peers and add value to your professional portfolio.

Areas Covered
  • Using external data sources
  • Text functions: LEFT, RIGHT, MID, LEN, FIND, TEXT
  • Text-to-Columns and Flash Fill
  • Table style formatting
  • Pivot tables
  • Date mat for parsing, manipulating and calculating date data
  • Introduction to dashboard arrangement and population
Who will Benefit
Compensation and benefits director, hr manager, payroll manager, hr assistant, personnel director, recruiter, recruiting manager, director of human capital, hr data analyst, payroll data analyst, human resources.
$300
Recorded Session for one participant
Get life time access with download option!
Book this course
Pay Now
  $450.00 Training CD
Free shipment within 4 Working Days of placing the order. Get life time access for unlimited participants.
  $550.00 Training USB Flash Drive
Free shipment within 4 Working Days of placing the order. Get life time access for unlimited participants.
For multiple location please contact our customer care team +1-510-857-5896.
How it works
Live Session - How it works
  • Login to onlinecompliancepanel with your registered username and password https://www.onlinecompliancepanel.com/login
  • The webinar joining link, username and password for joining the webinar will be updated on your OCP Account 24 hours prior to the webinar
  • Presentation handouts in Downloadable PDF format will be updated on your OCP Account 24 hours prior to the live session
  • Login to the audio conference on the scheduled date and time
  • Get answers to your queries through interactive Q&A sessions via chat at the end of the session
  • Download the Certificate of Attendance and Purchase Invoice from your OCP Account 24 hours after the completion of the session
  • Please let us know your thoughts and views at the end of the webinar, your valuable feedback will help us improve
Recorded Session - How it works
  • Login to onlinecompliancepanel with your registered username and password https://www.onlinecompliancepanel.com/login
  • Upon purchase of the recorded session a link will be updated on your OCP Account within 24 hours
  • Please click on the link to access the Recorded Session
  • Presentation handouts in downloadable PDF format will be updated on your OCP Account within 24 hours of the purchase of the product
  • Download the Certificate of Attendance and Purchase Invoice from your OCP Account after 48 hours of the product Purchase
  • Please share your valuable Feedback at the end of the session
Instructor Profile:
Melissa Esquibel specializes empowering office software users to get the software to work for them, rather than the other way around. As a Microsoft Certified Trainer (MCT) and Microsoft Office Specialist Master (MOSM) with more than 25 years in business application technology, Melissa has a unique ability to make learning programs enjoyable and valuable. Her consulting career spans banking, engineering, construction, government, manufacturing, telecommunications, energy and insurance, which allows her to provide real-world examples and applications. She has enabled everyone from rocket scientists to real estate brokers to put the "productive" back in office productivity software. Her practice also includes business continuity planning, SharePoint governance, and information security policies. Melissa graduated summa cum laude from Strayer University with a Bachelor of Business Administration, majoring in Legal Studies.
View More