Microsoft Office Skills, Level 3

Issued by Santa Barbara City College

This Certificate prepares students for entry-level office clerk jobs & provides a basis for more advanced college training and career laddering. The program consists of three required courses: Word 3, Excel 3 & PowerPoint 3 and one elective : Outlook 3, Publisher 3 or Access 3. Post-program participants will be able use mail merge to create, print or share documents and/or publications, use advanced formulas and transform data in Excel prepare a PowerPoint presentation for printing and sharing.

Level Intermediate
Time Hours
Cost Free

Additional Details

Earning Criteria

CMPW NC51C MS Word 3| Covers creating, managing and formatting tables in Microsoft Word and using Microsoft Word mail merge to create letters, labels and envelopes.
CMPW NC63C MS Excel 3 | Advanced Microsoft Excel topics including defining advanced formulas, data validation, lookups, ways to transform data, custom views and macros.
CMPW NC55C MS PowerPoint 3| Covers integrating Microsoft PowerPoint with other programs and the World Wide Web, collaborating with a workgroup, and producing and delivering an on-screen slide show in class.
CMPW NC58C MS Outlook 3| Covers many of the built-in tools of Microsoft Outlook to become more efficient with email, contacts, calendars, tasks and journal. Some of the topics include organizing with flags and categories, tips to quickly locate items, customize people (contact) using photos, linking and folders, using shared and multiple calendars, delegating tasks and tracking time with journal. (elective)
CMPW NC83C MS Access 3 | Forms/Reports: Covers how to analyze and share data using find, sort, and filter records in forms, create, modify and print reports. Other topics include advanced form features, advanced report features and how to utilize charts in forms and reports. (elective)