Payroll Practice and Management with Microsoft Excel

Payroll professionals have to navigate financial laws and data to do their job efficiently. This online course covers all critical areas of payroll management and teaches you advanced practices for using Microsoft’s Excel 2019 software. You will be prepared to take the Fundamental Payroll Certification exam and the Microsoft Office Specialist (MOS) Expert certification exam for Microsoft Excel 2019. Key topics include the major components of the Fair Labor Standards Act of 1938, the Internal Revenue Code and major parts of the state labor code for your chosen state.

What You will learn:

Identify various laws and regulations that affect employers in their payroll operations
Identify various deductions, both voluntary and involuntary, that are taken out of employees' gross pay
Calculate gross and net pay
Explain the use of the forms required to withhold, deposit, and report federal income taxes
Recognize dates and regulations to ensure payroll compliance and reporting
Understand the payroll process and supporting systems and administration
Correctly apply payroll policies and procedures of a payroll department
Journalize payroll transactions and post to appropriate general ledger accounts
Be able to process payroll from start to finish (payroll project)
To create, modify, and manage Excel workbooks
To use formulas, functions and work with tables
To convert, sort, filter, and manage lists
To use conditional formatting and styles
To create pivot tables and charts
To import and export data

For more course information or to enroll, visit: https://careertraining.utep.edu/training-programs/payroll-practice-management-with-microsoft-excel-2019/

https://careertraining.utep.edu/training-programs/payroll-practice-management-with-microsoft-excel-2019/