Office skills

6 months

‌Complete the Bookkeeping for Small Business Certificate part-time in just six months with our bundled programs.

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

Please note: The accounting software studied in this program (Sage 50 or QuickBooks) is not Mac-compatible. Students working on Mac can still complete the program, but will need to remote into one of Continuing Education's computer labs to work with this software. Please note that other programs such as Excel may also display differently on Mac.

In order to remotely access a computer lab, please ensure that your computer is running MacOS 12 or newer, or Windows 10 or 11 with the latest OS update.

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.

Please note: The accounting software studied in this program (Sage 50 or QuickBooks) is not Mac-compatible. Students working on Mac can still complete the program, but will need to remote into one of Continuing Education's computer labs to work with this software. Please note that other programs such as Excel may also display differently on Mac.

In order to remotely access a computer lab, please ensure that your computer is running MacOS 12 or newer, or Windows 10 or 11 with the latest OS update.

6 hours

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.

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

6 hours

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.

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

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

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 I with B or better.

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.

Bookkeeping Level II with B or better.

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 I with B or better.

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.

6 hours

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. 

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.

15 hours

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.

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

20 hours

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.

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

Bookkeeping Level I with B or better.

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.

Bookkeeping Level II with B or better.

30 hours

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

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 I with B or better.

30 hours

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 online version of QuickBooks.

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

6 hours

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.

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