859Analyzing Payroll Data in Microsoft Excel
There are many features and functions payroll professionals can implement 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 human resources (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 2019. David draws your attention to any differences in the older versions of Excel (2016, 2013, and earlier) during the presentation as well as in his detailed handouts. You'll also discover some features only available in Office 365 but not in Excel 2019. David also provides an Excel workbook that includes most of the examples he uses during the webcast.
Office 365 is a subscription-based product that provides new-feature updates as often as monthly. Conversely, the perpetual licensed versions of Excel have feature sets that don't change. Perpetual licensed versions have year numbers, such as Excel 2019, Excel 2016, and so on.
David H. Ringstrom, CPA Keynote Speaker at Ijona Skills. He is an author and nationally recognized instructor who teaches scores of webinars each year. His Excel courses are based on over 25 years of consulting and teaching experience. David's mantra is "Either you work Excel, or it works you," so he focuses on what he sees users don't, but should, know about Microsoft Excel. His goal is to empower you to use Excel more effectively.
Phone: +1 302-830-3132
|Target State: All States|
Target City : All Cities
Last Update : Apr 30, 2019
Number of Views: 30
|Item Owner : Ijona Skills|
Contact Phone: 302-830-3132
|Friendly reminder: Click here to read some tips.|