Courses Courses Arts and Design Arts and Design Animation Graphic Arts Photography Web Design Business Business Accounting Administrative Communication Finance Marketing and Sales Operations Project Management Small Business Soft Skills Career Online High School Career Online High School Online High School Diploma Computer Applications Computer Applications Autodesk Microsoft QuickBooks Windows Computer Science Computer Science Programming Construction and Trades Construction and Trades Construction Environmental and Energy Trades Health and Fitness Health and Fitness Alternative Medicine Dental Fitness Medical Veterinary Wellness Hospitality Hospitality Hospitality Service Information Technology Information Technology Cloud Computing Networking Other Security Language Language Languages Legal Legal Legal Studies Math and Science Math and Science Mathematics and Science Teacher Professional Development Teacher Professional Development Child Development Classroom Technology Math and Science Reading and Writing Test Prep Test Prep Exam Prep Writing Writing Writing and Editing Skill Map Resources Resources About ed2go Externship Programs Financial Assistance Find a School Blog MyCAA

CONTACT US

(855) 520-6806

See all results for ""

See All Courses

ed2go Business Accounting Certified Bookkeeper with Microsoft Excel 2019
Return to Accounting
?rel=0&playlist=" frameborder="0" allowfullscreen>

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 the American Institute of Professional Bookkeepers (AIPB) certification as well as the Microsoft Office Specialist (MOS) Expert certification exam 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.

This course offers enrollment with or without a voucher. The voucher is prepaid access to sit for the Microsoft Office Specialist (MOS) Excel 2019 Expert certifying exam upon eligibility. Proctor fees may apply, which are not included.

12 Months / 210 Course Hrs
Open enrollment

Offered in Partnership with your Preferred School

Purchase College, SUNY

Why this school? It's been chosen based on your location or if you've visited this school's website. Change School

Bundle and Save

Include Voucher: Access to certification exam

Self-paced. Study at your own schedule

No Voucher

Self-paced. Study at your own schedule

Contact Us for additional information

Certified Bookkeeper with Microsoft Excel 2019

Contact Us

Details + Objectives

Course Code: GES2092

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.
  • Adjustment of entries.
  • 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 the course is taught
  • Self-paced, online course
  • 12 months to complete
  • Open enrollment, begin anytime
  • 210 course hours
How you will benefit
  • Be prepared to sit for the American Institute of Professional Bookkeepers exam. You may take the exam at any Prometric Test Center.
  • 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

Outline

Expand All
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

Instructors & Support

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

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.

Show all Instructors & Support
Requirements

Requirements

Prerequisites:

The Certified Bookkeeper course is designed for experienced bookkeepers who want to prepare for national certification. 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. Click here to view the requirements for the AIPB Certification exam. You should also be comfortable using a personal computer and be familiar with operating Windows Office software. 

Requirements:

Hardware Requirements:

  • This course can be taken on either a PC or Mac.

Software Requirements:

  • PC: Windows 8 or later.
  • 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.
  • Microsoft Word (not included in enrollment).
  • Microsoft Excel (not included in enrollment).
  • Adobe Acrobat Reader. Click here to download the Acrobat Reader.
  • Software must be installed and fully operational before the course begins.

Other:

  • Email capabilities and access to a personal email account.
Instructional Materials

The instructional materials required for the Microsoft Excel course are included in enrollment. Once you begin the Certified Bookkeeper course, AIPB will provide the six workbooks that are required. *Note: AIPB Books/Materials/Exam Fees are non-refundable upon registration.

FAQs

Expand All
Can I register for a course 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 me for a certification?

Yes, this online course will prepare you for the American Institute of Professional Bookkeepers (AIPB) certification exam (Exam fee included). 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 Expert Certification exam.

When can I start the course?

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

How long does it take to complete this course?

This course is self-paced and open enrollment, so you can start when you want and finish at your own pace. When you register, you'll receive twelve (12) months to complete the course.

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

The time allotted for course completion has been calculated based on the number of course hours. However, 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 may be charged.

What kind of support will I receive?

You may be assigned with an instructor or team of industry experts for one-on-one course interaction. Your support will be available (via e-mail) to answer any questions you may have and to provide feedback on your performance. All of our instructors are successful working professionals in the fields in which they teach. You will be assigned to an Advisor for academic support.

What happens when I complete the course?

Upon successful completion of the course, you will be awarded a Certificate of Completion.

Am I guaranteed a job?

This course will provide you with the skills you need to obtain an entry-level position in most cases. Potential students should always do research on the job market in their area before registering.

Can I get financial assistance?

This course is non-credit, so it does not qualify for federal aid, FAFSA and Pell Grant. In some states, vocational rehab or workforce development boards will pay for qualified students to take our courses. Additionally, some students may qualify for financial assistance when they enroll, if they meet certain requirements. Financing is available from select schools. Learn more: https://www.ed2go.com/career/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" form.

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 you become a Certified Bookkeeper?

A Certified Bookkeeper has passed the AIPB Certification exam, has at least 2 years of experience in the field, and has signed a Code of Ethics. Whether you are looking to become a bookkeeper or want to expand your skill set, AIPB Certification is a stepping stone to success.

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 Bureau of Labor Statistics, the average salary of a bookkeeper is currently just under $40,000 per year. This salary can vary widely depending on your experience level, education and certifications. Your salary will also depend on the size of the organization or organizations for which you work.

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.

How do I become a bookkeeper?

You will need to have a high school diploma as well as some type of bookkeeping or accounting training to become a professional bookkeeper. An online course like this one is a great place to start. You can try out this great career to ensure that bookkeeping is something you enjoy doing. If you want to stay competitive and qualify for more job opportunities at higher levels down the road, you may want to think about earning an associate degree in bookkeeping or accounting along with your training and experience on the job.

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.

Browse All

About Certification

American Institute of Professional Bookkeepers (AIPB)

The American Institute of Professional Bookkeepers (AIPB) is the leading institution for bookkeeping professionals in the United States and beyond. The institute contributes to the recognition of bookkeeping as a serious profession by providing comprehensive continuing education and resources that ensure practitioners are up-to-date and informed on the latest developments in the field. AIPB created the Certified Bookkeeper Program (CBP), the most prestigious certification in the industry. Earning your CBP designation can add to your market value and is recognized by employers all over the country. Increase your professional status with a course certified by AIPB.