• CATALOG
  • MILITARY
  • FINANCIAL ASSISTANCE
  • LOGIN
      Forget your password?
  • Open Search Dialog
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: $2,390.00
Save: $95.00 (4% off)

OVERVIEW

OBJECTIVE

OUTLINE

  1. Microsoft Excel 2019 Certification Training
    1. Introduction to Microsoft Excel 2019
      1. Creating a Microsoft Excel Workbook
      2. The Ribbon
      3. The Backstage View (The File Menu)
      4. Entering Data in Microsoft Excel Worksheets
      5. Formatting Microsoft Excel Worksheets
      6. Using Formulas in Microsoft Excel
      7. Working with Rows and Columns
      8. Editing Worksheets
      9. Finalizing Microsoft Excel Worksheets
      10. Introduction to Microsoft Excel 2019 Exam
    2. Intermediate Microsoft Excel 2019
      1. Advanced Formulas
      2. Working with Lists
      3. Working with Illustrations
      4. Visualizing Your Data
      5. Working with Tables
      6. Advanced Formatting
      7. Intermediate Microsoft Excel 2019 Exam
    3. Advanced Microsoft Excel 2019
      1. Using Pivot Tables
      2. Auditing Worksheets
      3. Data Tools
      4. Working with Others
      5. Recording and Using Macros
      6. Random Useful Items
      7. Advanced Microsoft Excel 2019 Exam
    4. Microsoft Excel 2019 Final Exam
  2. Payroll Practice and Management
    1. Introduction to Payroll
    2. Determining Worker Status
    3. The Fair Labor Standards Act (FLSA)
    4. Federal Employment Taxes
    5. Payroll Forms
    6. Fringe Benefits – Tax-Preferred and Other Related Health Benefits
    7. Fringe Benefits – Deferred Comp, Retirement Plans, and Stock Options
    8. Other Employee Benefits
    9. Calculating Gross Wages
    10. Calculating Gross Pay – Additional Topics
    11. Paycheck Calculation – Taxes
    12. Paycheck Calculation – Voluntary and Involuntary Deductions
    13. Gross to Net Paycheck Calculation
    14. Compliance – Laws and Reporting
    15. Global Payroll
    16. Payroll Process and Systems, and Audits
    17. Paying the Employee
    18. Payroll Administration and Management
    19. Basic Accounting
    20. Exploring Payroll Careers
    21. Exam Preparation
    22. Payroll Project

REQUIREMENTS

PREREQUISITES

INSTRUCTOR

FAQS

Cape Cod Community College
The Center for Corporate and Professional Education
2240 Iyannough Road
West Barnstable, MA 02668 US
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.