Microsoft Office Skills, Level 2
Issued by
Santa Barbara City College
This Certificate prepares students for entry-level office clerk jobs & provides a basis for more advanced college training & career laddering. The program consists of three required courses: Word 2, Excel 2 & PowerPoint 2 and one elective: Outlook 2, Publisher 2 or Access 2. Post-program participants will be able to format & navigate long documents, work with large and multiple worksheets and workbooks in Excel and modify an existing PowerPoint presentation to improve its overall appearance.
- Level Intermediate
- Cost Free
Skills
- Animations
- Basic Access
- Basic And Intermediate Excel
- Basic And Intermediate PowerPoint
- Basic And Intermediate Word
- Basic Computer Skills
- Basic Excel
- Basic Microsoft Word
- Basic Outlook
- Basic Publisher
- Conditional Formatting
- Data Entry
- Data Validation
- Microsoft Access
- Microsoft Excel
- microsoft office Skills
- Microsoft Outlook
- Microsoft PowerPoint
- Microsoft Publisher
- Microsoft Word
- MS Access
- MS Excel
- MS Outlook
- MS PowerPoint
- MS Word
- Office Basic Skills
- Operations
- Presentations
- Referential Integrity
- Relational Databases
- Sorting
- Templates
- Workbooks CRM
Earning Criteria
-
CMPW NC51B MS Word 2| Using Microsoft Word to create a novel, family history, dissertation, thesis, operations manual, or business and/or academic reports. Covers layout/structure features including applying styles; table of contents; outline view; page setup; choosing fonts; controlling line, paragraph and page breaks; and many more.
-
CMPW NC63B MS Excel 2 | Microsoft Excel topics include working with large and multiple worksheets and workbooks, managing lists, creating and managing tables and conditional formatting.
-
CMPW NC55B MS PowerPoint 2| Covers how to enhance an existing Microsoft PowerPoint presentation by modifying objects, animation and transitions. Other topics include inserting slides and templates from other presentations, creating and modifying templates, rehearsing timings and running a presentation, and sharing a presentation.
-
CMPW NC58B MS Outlook 2 (elective)| Covers many of the built-in tools of Microsoft Outlook to better manage email, contact, calendars, tasks and notes. Some of the topics include organizing email using folders; sorting and filters for better efficiency; importing and exporting contact lists; prioritizing, tracking and delegating tasks; and using notes.
-
CMPW NC73B MS Publisher 2 (elective)| Covers many of the built-in tools of Microsoft Publisher to customize layouts, utilize master pages, create and modify templates, prepare publications for printing and save publication in shareable formats.
-
CMPW NC083A MS Access 2: (elective)| Covers how to better improve the integrity of data by managing relational databases and using tables for referential integrity, creating data entry and data validation rules, and using complex queries.