Certified Bookkeeper with Microsoft Excel 2019

Certified Bookkeepers are the elite of their profession, much like CPAs are the best in the accounting field. Gaining industry-recognized certification increases your earning potential and enhances your professional status. This course prepares for American Institute of Professional Bookkeepers (AIPB) certification as well as Microsoft Office Specialist and Expert certification exams for Microsoft Excel 2019.

Gaining AIPB certification is the highest standard in the profession, so this course is recommended to practicing bookkeepers with several years of experience and a working knowledge of payroll concepts, including accounting transactions and journal entries.

What you will learn

• Eligibility requirements, code of ethics, and maintenance requirements.
• How to apply the concepts of accrual accounting to transactions that span fiscal periods and trace the effect of accrual and deferral transactions.
• Identification and correction of accounting errors and reconciliation of bank accounts
• To create, modify, and manage Excel workbooks
• To use formulas, functions and work with tables
• To convert, sort, filter, and manage lists

How you will benefit

• Be prepared for the American Institute of Professional Bookkeepers exam
• Become a certified Microsoft Office Specialist (MOS) Expert in Excel 2019
• Use these skills in most workplace situations
• Manipulate data faster by learning helpful formulas and tricks

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:

Hardware Requirements:

• This course must be taken on a PC device. A Mac OS is not compatible.

Software Requirements:

• PC: Windows 10 or later operating systems.
• Mac: OS X Snow Leopard 10.6 or later.
• Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge and Safari are also compatible.
• Adobe Acrobat Reader.
• Microsoft Word (not included in enrollment).
• Microsoft Excel 2019 (not included in enrollment) While Microsoft Excel 2019 is ideal, you can download the desktop version of Excel included with Microsoft 365. Please note: There may be some differences between your version of Excel and what you see in the course.
• Software must be installed and fully operational before the course begins.
• Other: Email capabilities and access to a personal email account.

Instructional Material Requirements:

The instructional materials required for this course are included in enrollment. The AIPB provides the six workbooks that are required for this course:

• Mastering Adjusting Entries
• Mastering Correction of Accounting Errors
• Mastering Payroll
• Mastering Depreciation
• Mastering Inventory
• Mastering Internal Controls and Fraud Prevention

In addition to the six workbooks listed above, you will also receive:

• Two exam vouchers that cover the full cost of part one and part two of the Certified Bookkeeper exam

Books/Materials/Exam Fees are non-refundable upon registration.

Course Prerequisites:

The Certified Bookkeeper course is designed for experienced bookkeepers who want to prepare for national certification. To succeed in this course, you must have at least two years of experience as a bookkeeper before enrolling.

If you do not meet the experience requirement, we recommend our Professional Bookkeeping with QuickBooks course, which is designed for entry-level bookkeepers.

Certification Exam Prerequisites:

To earn your Certified Bookkeeper designation, you must pass the AIPB certification exam and be able to submit proof of at least two years of full-time - or 3,000 hours of part-time - experience. Learn more about the exam requirements.

Can I register for courses if I am an international student?

Yes, ed2go courses are completely online. However, keep in mind that not all certifying bodies or industry-specific certifications are recognized internationally. Please review your country's regulations prior to enrolling in courses that prepare for certification.

Does this course prepare for a certification?

Yes, this online course will prepare you for the American Institute of Professional Bookkeepers (AIPB) certification exam. You will have one year (365 days) from the date of enrollment in the Certified Bookkeeper course to submit the Application for Certified Bookkeeper Designation form to The American Institute of Professional Bookkeepers. You will also be prepared for the Microsoft Office Specialist Excel 2019 MOS and Expert Certification exams.

When can I start this course?

This course is open enrollment, so you can register and start the course whenever you are ready. Access to your course can take 24-48 business hours.

How long does it take to complete this course?

After you register, you will receive 12 months to complete the course. The time allotted for completion has been calculated based on the number of course hours.

What if I don't have enough time to complete the course within the time frame provided?

If you are unable to complete the course, contact your Student Advisor to help you work out a suitable completion date. Please note that an extension fee will be charged. If you are funded through a third-party organization, approval may also be required.

What kind of support will I receive?

The course instructor will be available by email to answer any questions you may have and to provide feedback on your performance. Occasionally, your course may be supported by a team of industry experts. You will also be assigned a Student Advisor for academic support.

What happens when I complete the course?

Upon successfully passing the final exam, you will be awarded a certificate of completion from the school or organization that you registered through.

Am I guaranteed a job?

ed2go courses will help you gain the skills you need to obtain an entry-level position in most cases. However, you should always research the job market in your area before enrolling.

Can I get financial assistance?

ed2go courses are non-credit, so they do not qualify for federal aid, FAFSA, and Pell Grant. In some states, vocational rehab or workforce development boards may provide funding to take our courses. Additionally, you may qualify for financial assistance if you meet certain requirements. Learn more about financial assistance.

How can I get more information about this course?

If you have questions that are not answered on our website, representatives are available via LIVE chat. You can also call us at 1-877-221-5151 during regular business hours to have your questions promptly answered. If you are visiting us during non-business hours, please send us a question using the "Contact Us."