• CATALOG
  • MILITARY
  • FINANCIAL ASSISTANCE
  • LOGIN
    Forget your password?
  • Open Search Dialog
Home > Training Programs > Accounting > Payroll Practice and Management with Microsoft Excel (Voucher Included)

The Payroll Practice and Management with Microsoft Excel (Voucher Included) includes: Microsoft Excel Certification Training (Voucher Included)
Payroll Practice and Management

Payroll Practice and Management with Microsoft Excel (Voucher Included)

Train for an entry-level career as a payroll specialist. This course will prepare you for the Fundamental Payroll Certification exam and the Microsoft Office Specialist (MOS) Expert certification exam for Microsoft Excel. Enrollment includes a prepaid voucher to take the Microsoft Office Specialist Excel Expert certification exam.

Payroll-Practice-Management-Excel-2019-Voucher
$2,495.00 (USD)
List Price: $2,645.00
Save: $150.00 (6% off)

Have a question?We're here to help

Overview

Objective

Outline

  1. Microsoft Excel Certification Training
    1. Introduction to Excel
      1. Microsoft Office Basics
      2. Creating a Microsoft Excel Workbook
      3. The Ribbon
      4. The Backstage View (The File Menu)
      5. The Quick Access Toolbar
      6. Entering Data in Microsoft Excel Worksheets
      7. Formatting Microsoft Excel Worksheets
      8. Editing Worksheets
      9. Working with Rows and Columns
      10. Using Formulas in Microsoft Excel
      11. Finalizing Microsoft Excel Worksheets
      12. Introduction to Excel Exam
    2. Intermediate Excel
      1. Common Functions
      2. Working with Lists
      3. Visualizing Your Data
      4. Working with Tables
      5. Advanced Formatting
      6. Intermediate Excel Exam
    3. Advanced Excel
      1. Using PivotTables
      2. Advanced Functions
      3. Auditing Workbooks
      4. Data Tools
      5. Working with Others
      6. Recording and Using Macros
      7. Advanced Excel Exam
    4. 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

You've got questions.
We're here to help.

Our highly knowledgeable Enrollment Specialists will answer any questions you might have about the course and payment options.

REQUEST INFO

Instructor

FAQs

You've got questions.
We're here to help.

Our highly knowledgeable Enrollment Specialists will answer any questions you might have about the course and payment options.

REQUEST INFO
Cal State San Bernardino’s College of Extended and Global Education
College of Extended and Global Education
5500 University Parkway
College of Extended and Global Education
San Bernardino, CA 92407 US
MAIN CONTENT

Copyright © 1997 - 2024 All rights reserved. The material on this site cannot be reproduced or redistributed unless you have obtained prior written permission from Cengage Learning. Privacy Policy