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

  1. MS Word 3| CMPW NC51C|Covers creating, managing and formatting tables in Microsoft Word and using Microsoft Word mail merge to create letters, labels and envelopes.

  2. MS Excel 3 | CMPW NC63C | Advanced Microsoft Excel topics including defining advanced formulas, data validation, lookups, ways to transform data, custom views and macros.

  3. MS PowerPoint 3| CMPW NC55C | 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.

  4. MS Outlook 3| CMPW NC58C | 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)

  5. MS Access 3 |CMPW NC83C|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)