• CATALOG
  • MILITARY
  • FINANCIAL ASSISTANCE
  • LOGIN
      Forget your password?
  • Open Search Dialog
Brookhaven College
Home > Training Programs > Accounting > Certified Bookkeeper with Microsoft Excel 2019 (Voucher Included)
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 Certified Bookkeeper with Microsoft Excel 2019 (Voucher Included) includes: Certified Bookkeeper
Microsoft Excel 2019 Certification Training (Voucher Included)

Certified Bookkeeper with Microsoft Excel 2019 (Voucher Included)

cert-bookkeeper-w-excel-ges2092
$2,595.00 (USD)
List Price: $2,645.00
Save: $50.00 (2% off)

OVERVIEW

DETAILS

OUTLINE

Certified Bookkeeper
I. Becoming a Certified Bookkeeper
A. Eligibility Requirements
B. Testing Program
C. Code of Ethics
D. Maintenance of Certification
II. Accruals, Deferrals, and the Adjusted Trial Balance
A. Why Accruals, Deferrals, and Other Adjustments are Made
B. Accruing Revenues and Expenses
C. Recognizing Revenues Collected in Advance
D. Recognizing Expenses After a Prepayment
E. Other Adjusted Entries
F. Unadjusting Trial Balance Through the Adjusted Trial Balance
III. Correction of Accounting Errors and the Bank Reconciliation
A. When and Where Accounting Errors Occur and How They Are Discovered
B. Performing the Bank Reconciliation
C. Finding and Correcting Errors on the Unadjusted Trial Balance
D. Correcting Current-Period Accrual and Deferral Errors
IV. Payroll
A. How to Pay Different Types of Employees
B. Federal and State Wage-Hour Law
C. Paying Employees Under Federal Law
D. Employment Records and Payroll Recordkeeping
E. Form W-4 and Comparable State Forms
F. Withholding and Depositing Federal Taxes
G. Federal Employment Reporting Forms and Due Dates
H. When Wages Become Taxable
I. Other Reporting Rules
J. Payroll Register and Journal Entries
V. Depreciation
A. The Difference Between Book and Tax Depreciation
B. Depreciation under GAAP
C. Computing and Allocation Depreciation
D. Depreciation Under Federal Tax Depreciation Rules
E. Tax Depreciation of Vehicles
VI. Inventory
A. General Concepts of Accounting for Inventory
B. The Perpetual Method
C. The Periodic Method
D. Weighted-Average and Moving-Average Methods
E. First-In, First-Out (FIFO) Method
F. Last-In, First-Out (LIFO) Method
G. Lower of Cost or Market LCM Rule
VII. Internal Controls and Fraud Depreciation
A. How to Prevent or Spot Theft of Inventory and Other Non-cash Assets by Employees
B. Preventing Employee Theft, Embezzlement, or Fraud by Hiring the Right Personnel
C. Insuring the Company Against Theft
D. How to Prevent or Spot Customer Check Fraud
E. Signs that May Indicate Payroll Fraud
F. How to Prevent or Spot Customer Credit Card Fraud
G. Recommended Rules for Company Credit Cards
H. Preventing Vendors From Cheating the Company
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

REQUIREMENTS

PREREQUISITES

INSTRUCTOR

FAQS

Brookhaven College

Workforce and Continuing Education
3939 Valley View Lane
Dallas, TX 75244 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.