University of North Florida
Training Programs Accounting Payroll Practice and Management with Microsoft Excel (Voucher Included)
phone  Call Us: 855.520.6806
cart-icn

You already have a course in your cart

You can only add one course to your cart at a time! By adding this course, you will replace the existing course from your cart. How would you like to proceed?

Keep existing course Replace course

Attention Enter your first name.

Attention Enter your last name.

Attention Enter your email.

Attention Enter your phone number.

By submitting this form, you acknowledge that you are 16 years of age or older and agree to be contacted by email, telephone, or text for the specific purpose you have submitted your information above.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

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.

Payroll-Practice-Management-Excel-2019-Voucher
$2,395.00 (USD)
List Price: $2,445.00
Save: $50.00 (2% off)

ENROLL NOW phone  Call Us: 855.520.6806
Have a question?We're here to help
REQUEST INFO

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
Back to top
University of North Florida

12000 Alumni Drive
Division of Continuing Education
Jacksonville, FL 32224 US
MAIN CONTENT
Career Training

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