Excel Dexterity - Payroll Analysis

$49.00 each

Course ID: CPE Credits Field Of Study Author or Speaker:
DR-612.19  2 Credits   Computer Software and Applications  David Ringstrom
Instructional Method: Advanced Preparation: Program Prerequisites: Experience Level:
 Interactive Self Study  None   None   Basic 

 

Course Description:

Excel offers multiple features and functions payroll professionals can implement to improve the accuracy and efficiency of payroll production. In this comprehensive course, Excel expert David Ringstrom, CPA, demonstrates and 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, and using pivot tables for HR reporting and analysis tasks.

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.

View Cart

cart empty