Analyzing Payroll Data in Microsoft Excel (Middletown, OH)

Analyzing Payroll Data in Microsoft Excel

Overview 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.Speaker Profile 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. Register s www.ijonaskills.us webinarDetails webinarid 532& speakerid 53& domain 4 Contact Info Ijona skills Email support(at)ijonaskills.us Visit s www.ijonaskills.us upcoming-webinar Phone 1 302-830-3132