MS Office Certificate

Gain the organizational, computer and clerical skills to succeed in the office. Microsoft Word, Excel, PowerPoint and Outlook are all valued in the workplace and knowing the features and functionality of the software is becoming increasingly important.

This certificate is eligible for the StrongerBC future skills grant. 

Course Number: CECOMP 928

Campus Offered: Terrace

Cost: $750

Times: Nov 23 - Dec 8 (2024) Sa/Su 8:30am-3:30pm

Hours:  36

Register at: the Register for Continuing Studies page

Students must complete all courses to obtain the MS Office Certificate. 

The courses included in the MS Office Certificate are:

Excel Expert

Participants will gain an advanced level of understanding for the Microsoft Excel environment, and the ability to guide others to the proper use of the program's full features - critical skills for those in roles such as accountants, financial analysts, and commercial bankers. Participants will create, manage, and distribute professional spreadsheets for a variety of specialized purposes and situations. They will customize their Excel  environments to meet project needs and increase productivity.  Expert workbook examples include custom business templates, multi-axis financial charts, amortization tables, and inventory schedules.

Course Objectives:

  • Understand permissions, versions, and Excel Options
  • Track changes and share workbooks
  • Perform advanced formula auditing and calculation
  • Create arrays
  • Create additional ways to run a macro
  • Create a form using a variety of controls
  • Use trend lines, secondary axes and chart templates
  • Work with slicers in PivotTables
  • Create and manipulate a PowerView sheet
  • Analyze data using multiple tables

 

This course is part of the MS Office Certificate. Complete all required courses to gain the certificate. 

Course number:
CECOMP 915
Campuses offered:
  • Terrace
Times:

TERRACE Sep 29 (2024) 8:30am-3:30pm

 

Hours:
6
Prerequisites:
  • Excel Essentials (CECOMP 916)
Register at: