Corporate training

Office skills

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


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 is designed for people with no previous Excel experience.

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.


MS 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. Bring a USB stick to class. This course is designed for people with prior Excel experience. We encourage students with no such experience to take MS Excel Basics.

Note: Students with credit for ABT 137 or Spreadsheets: Excel (RM 06) will receive credit for this course provided software version is the same.

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 Excel Level II

Prerequisite

Excel Level I

Course length

15 hours

Description

Learn how to use intermediate MS Excel tools such as hyperlinks, PMT function, and additional formatting to create workbooks, including templates and multiple worksheets. This course will help you further develop your skills in chart creation.

This course is not a graduation requirement for the Bookkeeping for Small Business certificate.

Learning outcomes

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

  • Create data tables, amortization schedules and use financial functions
  • Work with multiple worksheets and workbooks using 3-D referencing and consolidation
  • Create PivotTables and PivotCharts and apply filters and slicers


MS Office Fast Track

Course length

20 hours

Description

Tour the whole Microsoft Office suite and get introduced to applications such as Access (database), Excel (spreadsheet), Word (word processing), PowerPoint (presentation), and Outlook (email). Get hands-on experience using these tools to create compelling documents and presentations.

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


QuickBooks Level I

Prerequisite

Bookkeeping Level II with a minimum grade of B

Course length

30 hours

Description

Note: Students may take QuickBooks Level I and II instead of Computerized Accounting (Sage 50) Level I and II to complete the Bookkeeping for Small Business certificate. Students should be competent in computer skills before taking this course.

Learn how to manage billing, estimates, collections, inventory management, and payroll using 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

Course length

30 hours

Description

Note: Students may take QuickBooks Level I and II instead of Computerized Accounting (Sage 50) Level I and II to complete the Bookkeeping for Small Business certificate.

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. 

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