Microsoft Office Skills, Level 3

Issued By:

Santa Barbara City College

Created:

Thursday, 01 July 2021

Badges Issued:

Microsoft Office Skills, Level 3

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.

Skills

What Courses or Activities it takes to earn this badge

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 (elective)| 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.
CMPW NC73C MS Publisher 3 (elective)| Covers the design set feature of Microsoft Publisher that enables a cohesive group of publications to be created for marketing purposes, as well as the mail merge feature that allows for sharing publication more efficiently.
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.

Admin Login