/ Skip to main content

Customized Training for Organizations

Office skills

Six-Month Bundle (Part-Time)

Course length

6 months

Description

‌Complete the Bookkeeping for Small Business Certificate part-time on weekday evenings in just six months with this bundled program.

To register, phone the Office of the Registrar at 1-888-823-8734 and reference the block code listed beside the bundle.


Three-Month Accelerated Bundle (Full-Time)

Description

Complete the Bookkeeping for Small Business Certificate in just 12 weeks with this full-time intensive program. Choose between studying SAGE 50 or QuickBooks (desktop version).

To register, phone the Office of the Registrar at 1-888-823-8734 and reference the block code listed beside the bundle below.


Advanced Excel for the Office

Course length

6 hours

Description

Learn to use financial functions, pivot tables and charts, and custom format codes. Add data to multiple worksheets and consolidate data. Completing Excel Basics for the Office or Excel Level I before registering for this course is recommended.

Learning outcomes

Upon the completion of this course, the student will have demonstrated the ability to:

  • Use the financial functions
  • Create an amortization schedule
  • Create and manipulate a table
  • Use PivotTables and PivotCharts to summarize data
  • Use custom format codes
  • Add data to multiple worksheets at the same time
  • Consolidate data by linking worksheets


Advanced Word for the Office

Course length

6 hours

Description

Enhance your skills by working with advanced elements in Microsoft Word, including forms, table of contents, indexing, and tab stops. Find out how to create mail merges, track changes, navigate comments, and compare and combine documents.

Learning outcomes

Upon the completion of this course, the student will have demonstrated the ability to:

  • Create forms
  • Create indexes
  • Create a table of contents
  • Create tab stops
  • Review and revise documents
  • Protect the documents created


Bookkeeping Level I

Prerequisite

It is advised that students are comfortable with basic Windows operations and are familiar with Excel prior to this course.

Description

This course provides an essential introduction to bookkeeping, including theoretical foundations and hands-on knowledge. Learn how to complete all the functions of the accounting cycle from transaction analysis to closing the books. Topics include the accounting model, basic financial statements, general ledger, and government taxation.


Bookkeeping Level II

Prerequisite

Bookkeeping Level I with B or better.

Description

Building on the principles covered in Bookkeeping Level I, learn about financial statements preparation, accounts receivable, accounts payable, subsidiary ledgers, bank reconciliations, payroll, GST, PST, HST, trial balances, and year end.


Computerized Accounting Level I (Sage 50)

Prerequisite

Bookkeeping Level II with B or better.

Description

Integrated bookkeeping/accounting software is a standard for small businesses. This course covers journal entries, purchases/sales orders and quotes, as well as invoicing, receipts and payments for payables, receivables, and inventory. Familiarize yourself with the reporting and tax features provided by accounting software. Payroll is not covered.


Computerized Accounting Level II (Sage 50)

Prerequisite

Computerized Accounting Level I with B or better.

Description

Build on what you have learned in Computerized Accounting Level I and learn about banking, payroll, projects, inventory, adjustments and closing. This course does not teach accounting fundamentals.


Excel Basics for the Office

Course length

6 hours

Description

Master Excel basics: learn to create, edit, and format worksheets. Work with auto fill, flash fill, formulas, graphics, spark lines, and charts. This course does not require any prior experience with MS Excel. 

Learning outcomes

Upon the completion of this course, the student will have demonstrated the ability to:

  • Identify the components of the Excel window.
  • Create (new, save, save-as), edit (fonts, page layout), print and view a worksheet.
  • Format a worksheet.
  • Work with auto fill, flash fill, formulas, graphics, spark lines, and charts.


Excel Level I

Course length

15 hours

Description

Learn how to use MS Excel to create spreadsheets that include AutoSum, conditional formatting, formulas, and absolute addresses. Develop or edit spreadsheets using a variety of MS Excel attributes and fine-tune your new skills by creating charts. This course is designed for people with prior Excel experience. We encourage students with no such experience to take Excel Basics for the Office.

Learning outcomes

Upon successful completion of this course, students will be able to:

  • Create and use a workbook
  • Enter data in a worksheet
  • Use references
  • Use formulas and functions
  • Format a worksheet
  • Print a workbook


MS Office Fast Track

Course length

20 hours

Description

Tour the whole Microsoft Office suite and get introduced to applications such as Excel (spreadsheet), Word (word processing), PowerPoint (presentation), Outlook (email), and Access (database). Learn how to effectively use video conferencing tools to work efficiently with your team remotely. Additionally, learn minute-taking skills in a digital environment to create agenda, pre-meeting, and minute templates to help organize your business and keep focused on important tasks.

Learning outcomes

Upon the completion of this course, the student will have demonstrated the ability to perform basic tasks of creating, editing, formatting and printing documents using the following Microsoft 2016 applications:

  • Access
  • Excel
  • Word
  • PowerPoint
  • Outlook


Payroll Accounting

Prerequisite

Bookkeeping Level I with B or better.

Description

Learn to manage a payroll accounting system, with an emphasis on the calculation of earnings and deductions to conform to federal and provincial laws and accounting best practices. Find out how to complete forms required by law and the necessary accounting entries performed as part of basic payroll recordkeeping. This is a general course that is not specific to any one business.


QuickBooks Level I

Prerequisite

Bookkeeping Level II with B or better.

Course length

30 hours

Description

Learn how to manage billing, estimates, collections, inventory management, and payroll using QuickBooks accounting software. This course studies the desktop version of QuickBooks.

Learning outcomes

Upon completion of this course, the student will have demonstrated the ability to:

  • Open data files and understand the Home Page and QuickBooks centres
  • Add icons to the icon bar and use QuickBooks Calculator
  • Enter cash transactions for customers and vendors
  • Add new customers and vendors – Quick Add and Complete
  • Enter sales invoices and customer payments 
  • Deposit customer payments to bank account 
  • Apply customer prepayments (deposits)
  • Enter customer NSF cheques
  • Enter bills and vendor cheque payments
  • Enter prepayments and purchase discounts
  • Enter journal transactions in general journal
  • Create new general ledger accounts
  • Enter Sales discounts and estimates
  • Memorize and edit recurring transactions
  • Find, review and correct transactions 
  • Display and print reports


QuickBooks Level II

Prerequisite

QuickBooks Level I with B or better.

Course length

30 hours

Description

Build on the skills you developed in QuickBooks Level I. Learn how to create and manage a new company, including company setup and payroll and inventory transactions. This course studies the desktop version of QuickBooks.

Learning outcomes

Upon completion of this course, the student will have demonstrated the ability to:

  • Set up new company files and create Chart of Accounts
  • Create, understand and use different account types
  • Create customer and vendor records, and their opening balances
  • Enter opening balances for income and expense accounts
  • Edit and delete accounts
  • Define a new sales tax
  • Create, understand and add types of items
  • Prepare paycheques and pay payroll liabilities
  • Release accrued vacation pay and correct payroll entries
  • Correct payroll entries after saving
  • Display and print payroll reports
  • Enter sales returns and credits  
  • Enter purchase returns and credits
  • Purchase and order inventory items
  • Adjust for inventory losses
  • Display and print inventory reports


Word Basics for the Office

Course length

6 hours

Description

This course is a quick way to learn basic Microsoft Word skills. Learn to create, edit, and format themes, as well as style documents. You will also work with headers and footers, bullets, drop caps, graphics, and columns.

Learning outcomes

Upon the completion of this course, the student will have demonstrated the ability to:

  • Identify the components of the Word window
  • Create, edit, view and print a Word document
  • Format a document’s themes, styles, headers and footers
  • Work with bullets, drop caps, graphics and columns


Back to course index

Contact Us