Why Choose Microsoft Office Professional Certificate at CLC?
• Certified Instructors
• Cutting Edge Technology and Emerging/High Demand Skill Sets
• Convenient Scheduling: Mondays and Wednesdays or Tuesdays and Thursdays, as well as many online offerings.
• Microsoft IT Academy, Cisco Networking Academy, CompTIA Authorized Academy
• VUE, Prometric and Certiport Test Center Onsite
• Education and Career Advisors
• Outstanding Career Placement
• Extensive, hands-on training, working with industry hardware and software
• State-of-the-art Labs– over $500,000 invested in labs
• Internships are available in each program
MICROSOFT OFFICE PROFESSIONAL CERTIFICATE
Program Course Requirements
COMP 1109 Introduction to Operating Systems (3 cr)
COMP 1131 Microsoft Word Comprehensive (4 cr)
COMP 1132 Microsoft Access Comprehensive (4 cr)
COMP 1133 Microsoft PowerPoint Comprehensive (3 cr)
COMP 1134 Microsoft Outlook Comprehensive (1 cr)
COMP 1135 Microsoft Excel Comprehensive (4 cr)
GRADUATION REQUIREMENT – 19 CREDITS
Career Description: The skills learned in the Microsoft Office Professional Certificate are designed to help office managers, technicians, administrative support personnel, and organization users of the Microsoft Office Suite become application specialists.
Program Information: This program is designed to teach students to become proficient and expert users in the Microsoft Office Suite of application programs including Word, Access, Excel, PowerPoint and Outlook. Students will learn desktop application operating skills to meet globally recognized standards, along with advanced skills using Word, Access, Excel, PowerPoint and Outlook. A synopsis of skills learned in this program include the following: Word 2016 – Creating, Formatting, and Editing Word Documents; Research Papers with Citations and References; Business Letters with a Letterhead and Tables; Documents with a Title Page, Table, and Watermark; Using Templates to Create a Resume and Sharing the Finished Documents; Generating Form Letters, Mailing Labels, and a Directory for a Cover Letter; Creating a Newsletter with a Pull-Quote and Graphics; Using Document Collaboration and Integration Tools; Creating a Master Document with a Table of Contents and an Index; Creating a Template for an Online Form; Enhancing an Online Form and Working with Macros, Document Security, and XML; Using Project Planning Guidelines; Publishing Office 2016 Web Pages Online; Saving to the Web Using Windows Live One Drive; and Creating APA Research Papers. Access 2016 – Creating Databases and Database Objects – An Introduction to table structure; Querying a Database; Maintaining a Database; Creating Reports and Forms; Creating Multiple Table Forms; Advanced Report Techniques; Using SQL; Advanced Form Techniques; Macros, Navigation Forms, PivotTables, and PivotCharts; Administering a Database System; and Database Design. PowerPoint 2016 – Create and Edit a Basic Presentation; Enhance a Presentation with Pictures and Shapes; Reuse a Presentation and Add Multimedia; Work with Information Graphics; Deliver and Collaborate on Presentations; Add Emphasis with Text Boxes; Create a Self-Running Presentation Containing Animation; Enhance Presentations with Hyperlinks and Action Buttons; Develop a Presentation from an Outline; Create a Photo Album Presentation with Shapes; Customize a Template and Handouts Using Masters; Use Project Planning Guidelines; Publishing Office 2016 Web Pages Online; and Save to the Web Using Windows Live One Drive. Outlook 2016 – Student will format message content by using character and paragraph formatting, use graphic elements such as charts and tables, and create contact records, tasks, and appointments from incoming messages. Students will create contact groups, schedule meetings, and share schedules to facilitate communication with other Outlook users. Excel 2016 – Create charts, create analytical, financial, etc. reports, optimize data entry, create a family budget, format numerical (financial, statistical, etc.) reports, create forms, create graphing, process data using what-if analyses, design reports, provide technical support, and creating trending data. Students will learn expert-level Microsoft Office Excel 2016 skills to efficiently and confidently use Excel 2016 software at the feature and functionality levels. Students will learn to be proficient with advanced formulas, functions, and data analysis tools. Students will also learn to manipulate data for analysis, presentation, and collaboration. In addition, will learn to manipulate Excel options to customize their environment to meet varying needs and enhance their productivity.
Graduates will be able to:
- Use the Microsoft Word 2016 software application and Office 365 to effectively create documents, newsletters, research papers, and create mail merge functions;
- Use the Microsoft Access 2016 software application and Office 365 to effectively create databases, database objects, reports, queries, forms, and macros;
- Use the Microsoft PowerPoint 2016 software application and Office 365 to effectively create advanced graphic presentations and handouts;
- Use the Microsoft Office 2016 software application and Office 365 to effectively create and format message content by using character and paragraph formatting, use graphic elements such as charts and tables, and create contact records, tasks, create appointments from incoming messages, create contact groups, schedule meetings, and share schedules to facilitate communication with other Outlook users; and
- Use the Microsoft Excel 2016 software application and Office 365 to effectively create advanced spreadsheets, charts, graphs, and analyses using multiple advanced formulas and functions.
Special Program Requirements:
Students entering this program must also take the prerequisite course COMP 1109 Introduction to Operating Systems.
Certification: MOS – Microsoft Office Specialist
Computer Tech Instructor
Dar graduated from Brainerd Community College with an Associate of Arts degree. She earned her Bachelor of Arts degree in Organizational Management and Communications from Concordia University in St. Paul, Minnesota. Dar holds Microsoft Certified Trainer (MCT), Microsoft Certified Systems Engineer (MCSE), and Microsoft Certified Systems Administrator (MCSA), and Microsoft Certified Professional (MCP) certifications from Microsoft and holds Net+, Security+, and Certified Technical Trainer (CTT) certification from CompTIA. Dar worked in management as a director of purchasing for six years and was a senior analyst for a technology consulting firm before moving to Central Lakes College in the fall of 2000. She also spent five years as a customer service representative working with administrative support personnel and doing database programming in both PC and mainframe systems.
Computer Tech Instructor
Ron graduated from Brainerd Community College with an Associate of Arts. He earned his B.A. and M.A. degrees in Business Management from the College of St. Scholastica. Ron holds Microsoft Certified Trainer (MCT), Microsoft Certified Systems Engineer (MCSE), Microsoft Certified Systems Administrator (MCSA), Microsoft Certified Desktop Support Technician (MCDST), Microsoft Certified Professional (MCP) and Microsoft Office Specialist (MOS) certifications from Microsoft and is a Certified Novell Administrator. Ron holds CompTIA Net+ certification and is a CompTIA Certified Technical Trainer (CTT). Ron is a published author of an MCDST textbook/manual and a technical editor and frequent reviewer for books focused on Microsoft system engineering, networking, and administration. Ron has been teaching business management and computer technology for over 24 years, spent two years as an Information Systems Manager and 17 years in circulation management with the Star Tribune newspaper in Minneapolis.
For more information regarding employment statistics, career salary information and estimated job growth, follow the resource links below: