• CATALOG
  • MILITARY
  • LOGIN
      Forget your password?
  • Open Search Dialog
Advanced Solutions Technical Institute
Home > Training Programs > Accounting > Payroll Practice and Management with Microsoft Excel 2019
CALL
NOW

855.520.6806

Fill out the form below

*

*

*

*

*

*

By continuing you are agreeing to have ed2go contact you.
Close Window

Thank you for your interest in this program. We should be contacting you shortly.

Close Window

The Payroll Practice and Management with Microsoft Excel 2019 includes: Microsoft Excel 2019 Certification Training
Payroll Practice and Management

Payroll Practice and Management with Microsoft Excel 2019

Payroll-Practice-Management-Excel-2019
$2,295.00 (USD)
List Price: $3,390.00
Save: $1,095.00 (32% off)

OVERVIEW

DETAILS

OUTLINE

Microsoft Excel 2019 Certification Training
I. Introduction to Microsoft Excel 2019
A. Creating a Microsoft Excel Workbook
B. The Ribbon
C. The Backstage View (The File Menu)
D. Entering Data in Microsoft Excel Worksheets
E. Formatting Microsoft Excel Worksheets
F. Using Formulas in Microsoft Excel
G. Working with Rows and Columns
H. Editing Worksheets
I. Finalizing Microsoft Excel Worksheets
J. Introduction to Microsoft Excel 2019 Exam
II. Intermediate Microsoft Excel 2019
A. Advanced Formulas
B. Working with Lists
C. Working with Illustrations
D. Visualizing Your Data
E. Working with Tables
F. Advanced Formatting
G. Intermediate Microsoft Excel 2019 Exam
III. Advanced Microsoft Excel 2019
A. Using Pivot Tables
B. Auditing Worksheets
C. Data Tools
D. Working with Others
E. Recording and Using Macros
F. Random Useful Items
G. Advanced Microsoft Excel 2019 Exam
IV. Microsoft Excel 2019 Final Exam
Payroll Practice and Management
I. Introduction to Payroll
II. Determining Worker Status
III. The Fair Labor Standards Act (FLSA)
IV. Federal Employment Taxes
V. Payroll Forms
VI. Fringe Benefits – Tax-Preferred and Other Related Health Benefits
VII. Fringe Benefits – Deferred Comp, Retirement Plans, and Stock Options
VIII. Other Employee Benefits
IX. Calculating Gross Wages
X. Calculating Gross Pay – Additional Topics
XI. Paycheck Calculation – Taxes
XII. Paycheck Calculation – Voluntary and Involuntary Deductions
XIII. Gross to Net Paycheck Calculation
XIV. Compliance – Laws and Reporting
XV. Global Payroll
XVI. Payroll Process and Systems, and Audits
XVII. Paying the Employee
XVIII. Payroll Administration and Management
XIX. Basic Accounting
XX. Exploring Payroll Careers
XXI. Exam Preparation
XXII. Payroll Project

REQUIREMENTS

PREREQUISITES

INSTRUCTOR

FAQS

Advanced Solutions Technical Institute

LP#38 El Socorro Main Road
El Soccorro, TT
MAIN CONTENT

Copyright © Education To Go. All rights reserved. The material on this site cannot be reproduced or redistributed unless you have obtained prior written permission from Education To Go. Education To Go and ed2go are registered trademarks of Education To Go, a part of Cengage Learning.