Excel Dexterity: Payroll Analysis Methods

Website https://www.onlinecompliancepanel.com/webinar/Excel-Dexterity-Payroll-Analysis-Methods-503626/MARCH- | 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

Accountants

CPAs

CFOs

Financial consultants

Controllers

For Registration

https://www.onlinecompliancepanel.com/webinar/Excel-Dexterity-Payroll-Analysis-Methods-503626/MARCH-2018-ES-OURGLOCAL

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