Accounting Basics

  • This class will provide students with step-by-step guidance on completing each stage in the accounting cycle, while providing students with a simplified understanding of the accounting concepts. Students will concentrate on journal entries & T-accounts, financial statements & closing entries, computerized systems, cash & payroll, and finally analyzing financial statements.

     Course

     Days & Times

     Location

     Instructor

     Price

     9000.69 Accounting Basics  Mon & Wed 12:00-2:00 PM  Covina-Valley Tech-Academy, Room 7  Hibner  $100

Excel For Accounting

  • Students will learn how to navigate through Microsoft Excel, while at the same time be introduced to the world of accounting. Having prior accounting knowledge is not required. This class will provide students with a blend of accounting principles and a detailed step-by-step instruction on how to format worksheets, use formulas and functions and create charts in Excel. Students will concentrate on the accounting equation, recording journal entries, creating financial statements and work with formulas to create a statement of cash flows. Students will also learn to use features and commands in Excel, such as data bars, PivotTables & data functions, to examine an inventory listing, calculate inventory costs and create a bank reconciliation, calculate a depreciation schedule, and a complete payroll register.

     Course

     Days & Times

     Location

     Instructor

     Price

     9000.71 Excel for Accounting  Mon & Wed 8:30-11:30 AM  Covina-Valley Tech-Academy, Room 7  Hibner  $125
     9000.72 Excel for Accounting  Mon & Wed 6:00-9:00 PM  Covina-Valley Tech-Academy, Room 7  Hibner  $125

Excel For Accounting Plus

  • Completion of Excel for Accounting is recommended, but not required. Students will learn how to navigate through Microsoft Excel, while at the same time be introduced to the world of accounting. Having prior accounting knowledge is not required. Students will explore a variety of Excel features, functions and commands related to accounting. This class will provide students with a blend of accounting principles and a detailed step-by-step instruction on Bond Amortization, protecting workbooks & using Macros, Financial Statement Analysis, creating various charts in Excel, and Budgeting & Cost Analysis, using flexible worksheet views & Data Analysis Tools.

     Course

     Days & Times

     Location

     Instructor

     Price

     9000.62 Excel for Accounting Part 2  Tues & Thurs 8:30-11:30 AM  Covina-Valley Tech-Academy, Room 7  Hibner  $125
     9000.74 Excel for Accounting Plus  Mon & Wed 6:00-9:00 PM  Covina-Valley Tech-Academy, Room 7  Hibner  $125

Bookkeeper Part 1

  • Limited enrollment. This class concentrates on Accounting Principles taught manually, as well as computer-assisted bookkeeping methods using software to record and process transactions for Payroll, Accounts Payable, Accounts Receivable and Financial Statements. A Certificate of Completion for Accounting Principles, Sage 50 (Peachtree), and QuickBooks can be earned by completing Bookkeeping Part 1 and Bookkeeping Part 2. Completion of coursework takes two terms. (108 hours)

     Course

     Days & Times

     Location

     Instructor

     Price

     2200.02 Bookkeeper Part 1  Monday & Wednesday 6-9 PM  Covina-Valley Tech-Academy, Room 3/4  Pereida  $150

Bookkeeper Part 2

  • Limited enrollment. Must have completed Bookkeeper Part 1. This class concentrates on application of technology, such as Sage 50 (Peachtree) and Intuit QuickBooks 2018. A Certificate of Completion for Accounting Principles, Sage 50 (Peachtree), and QuickBooks can be earned by completing Bookkeeper Part 1 and Bookkeeper Part 2. Also, upon completion of the program you will be eligible to obtain five (5) college credits through our Articulation Agreement with Mt. San Antonio College.

     Course

     Days & Times

     Location

     Instructor

     Price

     2200.015 Bookkeeper Part 2  Thursday 6-9 PM  Covina-Valley Tech-Academy, Room 3/4  Pereida  $100

     

Microsoft Office 2016

  • Students will learn to browse files on the computer, open files from a folder window, create new folders, move and copy files to new locations, delete and undelete (restore) files, and back up files on a USB flash drive. Learn to create, edit, mail merge, and format documents for work and/or personal fulfillment in Word; learn to create, edit, and share presentations in PowerPoint. As an added bonus, students will be provided access to the online “Typesy” keyboarding program, which will allow them to brush-up on their keyboarding skills, while in class or at home.

     Course

     Days & Times

     Location

     Instructor

     Price

     9000.64 Microsoft Office 2016  Thursdays 6:00-9:00 PM  Covina-Valley Tech-Academy, Room 7  Gonzalez  $125

     

Microsoft Excel

  • This course is designed for students to quickly set up workbooks, enter data, and format it for easier viewing, perform calculations and find and correct errors, and visualize data with charts and graphs. Students will develop better computation skills along with improving their critical thinking, decision-making and problem-solving skills. As an added bonus, students will be provided access to the online “Typesy” keyboarding program, which will allow them to brush-up on their keyboarding skills, while in class or at home.

     Course

     Days & Times

     Location

     Instructor

     Price

     9000.51 Microsoft Excel  Tuesdays 6:00-9:00 PM  Covina-Valley Tech-Academy, Room 7  Gonzalez  $125