Sign for Notice Everyday    Sign Up| Sign In| Link|

Our Sponsors

  • ESTA - Electronic System for Travel Authorization
Receive Latest News

Share Us

Excel Dexterity: Payroll Analysis Methods

View: 93

Website | Edit Freely

Category Excel for payroll, Remove Excel Conditional Formatting, Excel 2016 webcasts, David Ringstrom webcasts, Excel webinars, Excel Text to Columns feature, Excel SUMPRODUCT function, RANDBETWEEN worksheet function, Excel Table feature, Social Security Numbers, payroll production

Deadline: March 29, 2018 | Date: March 29, 2018

Venue/Country: Fremont, California, U.S.A

Updated: 2018-03-08 19:23:06 (GMT+9)

Call For Papers - CFP


There are multiple Excel features and functions payroll professionals can implement in order to improve the accuracy and efficiency of payroll production. In this comprehensive webinar, Excel expert David Ringstrom, CPA, explains: mathematics for employee timesheets, date and time formatting and stamping, conditional formatting to highlight HR requirements, password protection for sensitive payroll files and worksheets, salary information formatting, using pivot tables for HR reporting and analysis tasks, and more.

David demonstrates every technique at least twice: first, on a PowerPoint slide with numbered steps, and second, in Excel 2016. He draws your attention to any differences in Excel 2013, 2010, or 2007 during the presentation as well as in his detailed handouts. David also provides an Excel workbook that includes most of the examples he uses during the webcast.

Objectives of the Presentation

Describe the capabilities of the SUMPRODUCT function

Explain how to reformat Social Security Numbers using Excels Flash Fill feature

Identify how to apply password-protection techniques for sensitive payroll files, worksheets, and spreadsheet columns

Use the RANDBETWEEN worksheet function to create a series of random numbers

Learn to format certain words within a column of text

Apply Excel's Text to Columns feature to convert Social Security Numbers to values and then apply Excel's Social Security number format

Why Should you Attend

To learn practical Excel fundamentals to improve the accuracy and efficiency of payroll production.

Who will Benefit




Financial consultants


For Registration

Note: Use Promo Code YDEZ6H and get 10% off on registration (Valid till MARCH 31st 2018)

Keywords: Accepted papers list. Acceptance Rate. EI Compendex. Engineering Index. ISTP index. ISI index. Impact Factor.
Disclaimer: ourGlocal is an open academical resource system, which anyone can edit or update. Usually, journal information updated by us, journal managers or others. So the information is old or wrong now. Specially, impact factor is changing every year. Even it was correct when updated, it may have been changed now. So please go to Thomson Reuters to confirm latest value about Journal impact factor.