Excel for Payroll

Wednesday, October 10th, 2018 • 1:30 - 3:00 pm Eastern Time



Register for Live Webinar: $219

Register for Live Webinar Plus Recording Download: $329


Register for Live Webinar Plus CD (includes shipping and handling): $369

Special Feature: If you register for this webinar and cannot attend, you will be able to access a one-time instant replay without charge for up to 90 days after the date of the webinar.

Bonus for Each Registrant:  The webinar speaker will answer one written question that you may submit by email within one week after the webinar.

Description

Excel is great at crunching numbers. This would seem to make it an ideal tool for payroll data analysis and reporting. So, why doesn’t it seem like it’s harder than it should be? The secret to getting Excel to do its magic is knowing the tools to get your data into the right shape, then applying tools like formulas, functions, and pivot tables to get it to tell you what you need to know. In this session, you will learn the secrets the pros use to whip data into shape and parse it to the detail that’s needed. Then, we’ll extrapolate additional information to feed essential analysis for compensation. Finally, we’ll look at reporting tools like pivot tables and graphs to provide easy-to-understand reports that can effectively support decision-making.
 

Agenda

  • Text functions and Flash Fill to parse payroll system data to its details
  • Text functions to “repair” dates from external HR systems
  • Date math for determining benefits and bonus eligibility
  • If, VLookUp, AverageIf and more essential functions to connect employee data with compensation data
  • Workbook troubleshooting tips
  • Pivot table basics, Graphs, charts & Sparklines and Conditional formatting to generate meaningful, actional reports


Faculty


Melissa Esquibel specializes in transforming those confused by technology into empowered users of these powerful software tools. As a Microsoft Certified Trainer (MCT) with more than 25 years in business application technology, She has a unique ability to make learning programs enjoyable AND valuable.

Whether teaching how to crunch numbers with Excel, deliver compelling presentations in PowerPoint or generate business-winning proposals and reports with Word, Melissa keeps it relevant, accessible and fun. Melissa's consulting career spans banking, 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


 

Continuing Education Information
 

Approved Provider

Continuing HRCI Credit Information
This program has been pre-approved for 1.5 hours of General recertification credit hours through the HR Certification Institute. Use of the seal is not an endorsement by the HR Certification Institute of the quality of the program. It means that this program has met the HR Certification Institute's criteria to be pre-approved for recertification credit.

SHRM Recertification Provider

Continuing SHRM Credit
Park Avenue Presentations is recognized by SHRM to offer Professional Development Credits (PDCs) for the SHRM-CPSM or SHRM-SCPSM. This program is valid for 1.5 PDCs for the SHRM-CPSM or SHRM-SCPSM. For more information about certification or recertification, please visit www.shrmcertification.org

Webinar Overview

  • 90 minutes (Travel Free) delivered over the Internet.
  • Unlimited listeners per connection - bring the entire department.
  • Q&A session with the expert.

This event will be presented live with a PowerPoint presentation to be viewed on your computer. You may listen to the audio of the webinar by telephone or through your computer. The PowerPoint slides will be provided shortly before the event. Once you register, you will receive an email which is your receipt and which includes your instructions for dialing in and logging on. You will also receive an email reminder 24 hours before the webinar.
 

Register for Live Webinar: $219

Register for Live Webinar Plus Recording Download: $329


Register for Live Webinar Plus CD (includes shipping and handling): $369

 


Click Here to See Other Upcoming Webinars »