First name *

Attention Enter your first name.

Last name *

Attention Enter your last name.

Email *

Attention Enter your email.

Phone number *

Attention Enter your phone number.

How soon do you want to start? (Optional)

Attention

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Certified Bookkeeper with Microsoft Excel (Exam Cost and Voucher Included)

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

$3,398.00 (USD)

List Price: $3,434.00

Save: $36.00 (1% off)

Payment & Funding: view your options

ENROLL NOW phone Call Us: 855.520.6806

infoCareer series
schedule
                                210 Course Hrs
                            

                                Code
                                    GES2092
                            
Voucher included
calendar_today
                                12 Months
                            
grid_onOpen enrollment
speedSelf paced

Have a question?We're here to help

REQUEST INFO

Back

Explore your payments options

When it comes to paying for your course-you've got options! Schedule a call with us and we can help you find the payment method that works best for you.

Credit Card: Visa, Mastercard, Discover or American Express card Most Popular

Affirm:

TuitionFlex: Low-interest monthly payments

Workforce Funding: Learn about eligibility

Military Benefits: Find out if your benefits apply

Schedule a call Request Info

ENROLL NOW

phone Call Us:

855.520.6806

Overview

Objective

Outline

Part 1 - Certified Bookkeeper

Lesson 1 - Adjusting Entries

Accruals, Deferrals, and Other Adjustments
Accrued Revenue
Accrued Expenses (Accrued Liabilities)
Revenue Collected in Advance (Unearned Revenue)
Prepaid (Deferred) Expenses
Other End-of-Period Entries
From Unadjusted Trial Balance to Financial Statements

Lesson 2 - Correction of Accounting Errors

Types of Accounting Errors
The Bank Reconciliation
Finding and Correcting Errors Using the Unadjusted Trial Balance
Correcting Current Period Accrual Errors
Correcting Current Period Deferral Errors

Lesson 3 - Payroll

Employees vs. Nonemployees
Federal and State Wage-Hour Law
Paying Employees Under Federal Law
Employment Records and Payroll Recordkeeping
Form W-4 and State Withholding Allowance Certificates
How Employers Withhold and Deposit Federal Taxes
Federal Employment Reporting Forms and Due Dates
When Wages Become Taxable
Other Reporting Rules
Payroll Entries

Lesson 4 - Depreciation

Depreciation on the Financial Statements vs. Tax Return
Depreciation Under GAAP (For Books Purposes)
The Straight-Line Method of Depreciation
The Units of Production Method of Depreciation
The Declining Balance Method of Depreciation
The Sum-of-the-Years'-Digits Method of Depreciation
Depreciation Under Federal Income Tax Rules
Tax Depreciation of Passenger Cars and Other Vehicles

Lesson 5 - Inventory

Introduction to Accounting for Inventory
Inventory Recordkeeping Using the Perpetual Method
Inventory Recordkeeping Using the Periodic Method
Inventory Costing: The Weighted-Average and Moving-Average Methods
Inventory Costing Using the FIFO Method
Inventory Costing Using the LIFO Method
Inventory Costing Using the Lower of Cost or Net Realizable Value Rule

Lesson 6 - Internal Controls and Fraud Prevention

Internal Controls and Fraud Prevention
How to Prevent or Spot Employee Theft
Check Fraud
Credit Card Fraud
How Vendors Cheat You
Computer and Internet Fraud

Lesson 7 - AIPB Exam Preparation

General Information
Taking the Exam
Studying for the Exam

Part 2 - Microsoft Excel Certification Training

Lesson 1 - Introduction to Microsoft Excel Training

Microsoft Office Basics
Creating a Microsoft Excel Workbook
The Ribbon
The Backstage View (The File Menu)
The Quick Access Toolbar
Entering Data in Microsoft Excel Worksheets
Formatting Microsoft Excel Worksheets
Editing Worksheets
Working with Rows and Columns
Using Formulas in Microsoft Excel
Finalizing Microsoft Excel Worksheets

Lesson 2 - Intermediate Microsoft Excel Training

Common Functions
Working with Lists
Visualizing Your Data
Working with Tables
Advanced Formatting

Lesson 3 - Advanced Microsoft Excel Training

Using PivotTables
Advanced Functions
Auditing Workbooks
Data Tools
Recording and Using Macros
Working with Others

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

Wade Lindenberger

Wade Lindenberger is a CPA with over 20 years of financial accounting and management experience in public accounting and private industry. He is currently Director of Finance and Administration for New Children's Museum. Before his current position, he worked as the National Finance and Accounting Service Line Leader for Premier Alliance Group, a national professional services firm. Wade was also Director of the Finance and Accounting service line for the San Diego office of a global, publicly held professional services firm. Before becoming a consultant, Wade was Divisional Controller for one of the leading health and fitness club chains in the world. He has also been Internal Audit Manager and Divisional Controller for a division of a Fortune 500 global energy project management company. He began his career with Coopers & Lybrand, predecessor to PricewaterhouseCoopers, one of the "Big Four" CPA firms. He has previously served as an instructor for courses at Coopers & Lybrand and at the University of California at San Diego for the Extension Course and is currently an adjunct professor at the University of San Diego School of Business. He is a member of the American Institute of Certified Bookkeepers' Advisory Board.

Helene K. Liatsos

Helene K. Liatsos is a business advisor and QuickBooks Certified Advisor with more than 25 years of experience. She consults for a range of companies, from travel agencies to startups. Her company Home Office Management Experts was awarded the 2004 Home-Based Business of the Year by the U.S. Small Business Administration. Helene holds a Bachelor of Arts from Fairleigh Dickinson University.

Sherida Habersham

Sherida Habersham is an accomplished professional from Georgia at the intersection of technology, education, and service. She started her career as a software developer specializing in human resource management (HRM), payroll, and quality systems. Over her extensive career in education, Sherida has held several roles, including program lead, college professor, and division dean for business and information systems.

Sherida holds a Doctor of Philosophy (Ph.D.) in educational psychology, a Master of Science in computer science, and a Master of Business Administration in business. With expertise in curriculum development, business systems, and instructional leadership, she is dedicated to promoting learning and development. Additionally, she has over a decade of experience as a bookkeeping and tax expert, assisting small and medium-sized businesses (SMBs) in streamlining their operations with comprehensive bookkeeping and tax support.

Tracy Berry

Tracy Berry has been a senior graphic designer/programmer, instructor, and consultant since 1993 and has developed hundreds of logos, marketing materials, websites, and multimedia solutions for customers worldwide. She was also involved in several large corporate software rollouts. She has helped many organizations optimize and streamline data solutions. She teaches both onsite and online courses and has her CTT (Certified Technical Trainer) certification. Tracy specializes in teaching graphics, desktop publishing, web design, and reporting/productivity applications.

FAQs

Does this course prepare you for a certification?

Yes. This online course will prepare you for the four-part Certified Bookkeeper Exam to earn your American Institute of Professional Bookkeepers (AIPB) certification. You will have one year (365 days) from enrollment in the Certified Bookkeeper course to submit the Application for Certified Bookkeeper Designation form to The American Institute of Professional Bookkeepers. Please note that you will receive two exam vouchers, as two of the four exams are no-cost exams. Detailed instructions regarding the certification application, exams, and the use of the vouchers at any Prometric Test Center are available within the course. Please refer to The Certified Bookkeeper™ (CB) Designation handbook for more information.

Additionally, you'll be equipped to pursue the Microsoft Office Specialist (MOS) Excel Expert Certification exam. The course package with a voucher includes enrollment and a voucher for the MOS Excel Expert certifying exam, covering the examination fee upon meeting eligibility criteria. Please note that proctor fees, if applicable, are not covered by the voucher.

What is the average salary of a bookkeeper?

According to the U.S. Bureau of Labor Statistics, the median bookkeeper salary is $45,560 annually. However, bookkeepers can increase their earning potential through years of experience, certification, or starting your own bookkeeping business.

What is a Certified Bookkeeper?

Certified Bookkeepers meet the high standards of the American Institute of Professional Bookkeepers (AIPB). The official designation of Certified Bookkeeper (CB) from the AIPB allows you to put the initials CB after your name, which adds to your market value and professional status. This is an elite credential in the world of bookkeeping much like the CPA designation in accounting.

How do I become a bookkeeper?

To become a bookkeeper, you need a background in accounting and specialized knowledge in payroll and taxation. You can gain this knowledge through a course or on-the-job training in an accounting department or working underneath an experienced bookkeeper. You will also need to gain experience with bookkeeping software.

How do I become a Certified Bookkeeper?

To become a Certified Bookkeeper, you must sit for and pass the AIPB Certified Bookkeeper exam.

How do I become a virtual bookkeeper?

There are two paths to becoming a virtual bookkeeper. The first is looking for job opportunities listed as "Remote," which offer the possibility to work virtually. Second, you can work for yourself as a freelance bookkeeper and market yourself as a virtual or "remote" bookkeeper.

What will I do as a bookkeeper?

As a bookkeeper, you will be in charge of keeping accurate financial records for one or more financial organizations. You will be responsible for using bookkeeping software like QuickBooks to record transactions, produce reports, and check financial information for accuracy. You will handle expenses, receipts, payables, and accounts receivable. In addition, you may also help with payroll, purchasing, and outstanding accounts. The role of a professional bookkeeper can vary widely depending on the size of the organization you work for, but you can be sure that you will play an important role in the financial stability and success of your company.

How do I earn the Certified Bookkeeper (CB) designation?

In order to earn the Certified Bookkeeper (CB) from the American Institute of Professional Bookkeepers, you are required to pass a four-part, multiple-choice examination and obtain at least 2 years of full-time bookkeeping experience. It is possible to take and pass the exam before you have obtained your 2 years of experience. You will also be required to sign a Code of Ethics.

Do I need a degree to become a bookkeeper?

You do not need an advanced degree to become a bookkeeper. According to the Bureau of Labor Statistics, you will need to have your high school diploma or equivalent to pursue a career as a professional bookkeeper. Many bookkeepers get started with an online course like this Professional Bookkeeping course. However, in order to stay competitive and open up even more job opportunities down the road, you may want to think about earning an associate degree in bookkeeping or accounting at some point in your career.

Is a bookkeeper the same as an accountant?

Not exactly. There are five major parts to the accounting process and they include: recording, interpreting, classifying, analyzing, and reporting financial information. Bookkeeping is the first, foundational part of the accounting process — recording financial transactions. However, bookkeeping is a great first step into an accounting career and with additional education, you use this as a way to gain experience and become an accountant in the future.

What is the average salary of a bookkeeper?

According to the U.S. Bureau of Labor Statistics, the most recent media pay for bookkeepers was $41,230 annually. However, bookkeepers can increase their earning potential through years of experience, certification, or starting your own bookkeeping business.

Are bookkeepers in demand?

According to the Bureau of Labor Statistics, there are a lot of jobs for bookkeepers, and the job outlook is expected to remain relatively constant through 2026. Understanding how to efficiently use bookkeeping software like QuickBooks will make you a more desirable candidate as more and more businesses turn to technology to perform basic accounting tasks.

What kind of hours do bookkeepers work?

Most bookkeepers work 40 hours per week, though some do work part time. As a professional bookkeeper you may need to work overtime during certain periods of the year such as closing out the fiscal quarter and/or year as well as during tax season.

Where do bookkeepers work?

Most bookkeepers work in an office environment during typical 9 to 5 hours and spend a large amount of their time in front of a computer. As a professional bookkeeper, you will usually be working alone but may have a few people from other areas of accounting that work alongside you. It is even possible that you could work remotely from home for one or more organizations at a time.

Do bookkeepers do the taxes for a company?

No, bookkeepers do not do company taxes. Taxes are done by an accountant. However, bookkeepers play an important role in making sure that financial transactions are recorded in a timely and accurate manner. This ensures that the financial information for a company is easy to read and use once it is time for an accountant to take over and do the taxes.

Is a bookkeeping certificate worth it?

Yes. A certificate of completion signifies to a potential employer that you have completed the course work in the area of bookkeeping. Still, it can vary widely depending on where you get that education and training. Upon completion of this course, you will receive a certificate of completion. Certification, such as Certified Bookkeeper, demonstrates competency based on a national and industry-recognized standard. It also allows you to include the "C.B." designation after your name, signifying you have met the demanding requirements to earn this credential.

What if I don't have the two years of full-time experience required to sit for the exam?

If you do not meet the experience requirement for the exam, we recommend waiting to take the exam or enrolling in our entry-level Professional Bookkeeping with QuickBooks course.

Is the certification exam given online, or do I have to take it in person?

You must go to the Prometric Test Center to take the exam on a computer. The tests are taken on a computer at the testing facility.

Will the books and materials be shipped?

Yes, the books will be shipped. You should expect to receive them within 7-10 business days.

How soon after I pay can I start the course?

Once payment is made, you will gain access to the course in 24-48 hours.

Is there a way to try out the course before you pay the full amount?

We currently have a 10-day refund policy. Upon enrollment in the course, if you do not like the course, you can receive a full refund minus the costs of materials.

Is the cost of the exam included in the enrollment cost?

Yes included in the program are two exam vouchers for Part one and Part two of the exam. There are no fees associated with Part three and Part four of the exam.

I am a veteran, what are my options for paying for and enrolling in the course?

To learn about funding options for veterans, please contact us via chat or phone to discuss options that may be available to you.

Is there an internship or externship offered with this course?

At this time, there is not an internship or externship included in this course, but nothing is stopping you from securing these options on your own.

Do you offer job placement assistance?

At this time, we do not offer any job placement assistance. However, the AIPB website does provide a job board where you can search for employment opportunities, both remote and near you.

I am Canadian, can I take this course?

This course is based on U.S. accounting rules and regulations, as is the Certified Bookkeeper exam, so it may not be the best option if you are Canadian.

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?

Our courses are designed to accommodate various learning preferences. Depending on the course structure, you may get different forms of support. Self-paced courses are designed to be user-friendly and independent, minimizing the need for external support. In courses with instructors, our direct platform support feature includes opportunities for questions, discussions, and remediation, with email and phone support available for select courses. Our student advising team is available to guide you on program requirements and administrative requests, but they do not provide assistance with course content. Our goal is to provide you with the necessary support for success, whether it's through self-paced exploration, direct communication, or guidance from our advising team.

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."

Related Courses