Forget your password?
  • Open Search Dialog
Home > Training Programs > Accounting > Certified Bookkeeper with Microsoft Excel (Voucher Included)

The Certified Bookkeeper with Microsoft Excel (Voucher Included) includes: Certified Bookkeeper
Microsoft Excel Certification Training (Voucher Included)

Certified Bookkeeper with Microsoft Excel (Voucher Included)

This course prepares for American Institute of Professional Bookkeepers (AIPB) certification and Microsoft MOS Excel Expert certification exam.

$2,895.00 (USD)
List Price: $3,045.00
Save: $150.00 (5% off)




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





Georgia Southern University

PO Box 8124
Continuing Education
Statesboro, GA 30460 US

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. Privacy Policy