• CATALOG
  • MILITARY
  • FINANCIAL ASSISTANCE
  • LOGIN
    Forget your password?
  • Open Search Dialog
Home > Training Programs > Accounting > Certified Bookkeeper with Microsoft Excel (Exam Cost Included)

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

Certified Bookkeeper with Microsoft Excel (Exam Cost Included)

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

cert-bookkeeper-w-excel
$2,595.00 (USD)
List Price: $2,990.00
Save: $395.00 (13% off)

Have a question?We're here to help

Overview

Objective

Outline

  1. Certified Bookkeeper
    1. Getting Started
    2. Pretest
    3. Adjusting Entries
    4. Correction of Accounting Errors
    5. Payroll
    6. Depreciation
    7. Inventory
    8. Internal Controls and Fraud Prevention
    9. AIPB Exam Preparation
    10. Final Exam
    11. Resources
  2. Microsoft Excel Certification Training
    1. Introduction to Excel
      1. Microsoft Office Basics
      2. Creating a Microsoft Excel Workbook
      3. The Ribbon
      4. The Backstage View (The File Menu)
      5. The Quick Access Toolbar
      6. Entering Data in Microsoft Excel Worksheets
      7. Formatting Microsoft Excel Worksheets
      8. Editing Worksheets
      9. Working with Rows and Columns
      10. Using Formulas in Microsoft Excel
      11. Finalizing Microsoft Excel Worksheets
      12. Introduction to Excel Exam
    2. Intermediate Excel
      1. Common Functions
      2. Working with Lists
      3. Visualizing Your Data
      4. Working with Tables
      5. Advanced Formatting
      6. Intermediate Excel Exam
    3. Advanced Excel
      1. Using PivotTables
      2. Advanced Functions
      3. Auditing Workbooks
      4. Data Tools
      5. Working with Others
      6. Recording and Using Macros
      7. Advanced Excel Exam
    4. Final Exam

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

FAQs

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
Cal State San Bernardino’s College of Extended and Global Education
College of Extended and Global Education
5500 University Parkway
College of Extended and Global Education
San Bernardino, CA 92407 US
MAIN CONTENT

Copyright © 1997 - 2024 All rights reserved. The material on this site cannot be reproduced or redistributed unless you have obtained prior written permission from Cengage Learning. Privacy Policy