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.

Campuses offered: Terrace, Online

Price:  $750

Times: TERRACE/ONLINE Jan 27-Feb 11 (Sa/Su) (2024) 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.

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

 

TERRACE/ONLINE Feb 4 (2024) 8:30am-3:30pm

Hours:
6
Register at:
the Register for Continuing Studies page.