Course
Microsoft Office 365/Office 2019 for Office Administration
Name
OST-3100R2
Overall Quality of This Course
★★★★★
Based on 20 student surveys.
Available Classes
Not currently offered.
Description Course Outline Requirements Intended Audience More Details
Intended Audience
Individuals who want to expand their knowledge and skills for employment-readiness or those who want to successfully prepare for the relevant industry certification exam(s).
Description
Learn the technology skills for administrative office work – jobs that are in high demand by local employers! This bundled course will show you how to use Microsoft Office applications, including Word, Excel, PowerPoint, and Outlook to perform essential administrative tasks. You’ll learn to create, manage, and edit electronic files as well as how to enhance business collaboration and communication. Upon completion, you will be able to demonstrate work readiness, and you’ll be prepared to take core Microsoft Office Specialist certifications.
Course Objectives
  1. Microsoft Office:
    • Covers Word, Excel, PowerPoint and Outlook
    • Format Word documents for maximum visual impact
    • Build powerful, reliable Excel workbooks for analysis and reporting
    • Prepare highly effective PowerPoint presentations
    • Use Outlook to organize your email, calendar, and contacts
    • Includes downloadable practice files
  2. Exam MO-100 Microsoft Word:
    • Manage documents
    • Insert and format text, paragraphs, and sections
    • Manage tables and lists
    • Create and manage references
    • Insert and format graphic elements
    • Manage document collaboration
  3. Exam MO-200 Microsoft Excel:
    • Manage Worksheets and Workbooks
    • Manage Data Cells and Ranges
    • Manage Tables and Table Data
    • Perform Operations by Using Formulas and Functions
    • Manage Charts
  4. Exam MO-300 Microsoft PowerPoint:
    • Manage Presentations
    • Manage Slides
    • Insert and Format Text, Shapes, and Images
    • Insert Tables, Charts, SmartArt, 3D Models, and Media
    • Apply Transitions and Animations
  5. Exam MO-400 Microsoft Outlook:
    • Manage Outlook Settings and Processes
    • Manage Messages
    • Manage Schedules
    • Manage Contacts and Tasks
Outline of Instruction
  1. Microsoft Office:
    1. Explore Office 2019
    2. Create and manage files
    3. Modify the structure and appearance of text
    4. Collaborate on documents
    5. Merge data with documents and labels
    6. Perform calculations on data
    7. Manage worksheet data
    8. Reorder and summarize data
    9. Analyze alternative data sets
    10. Create and manage slides
    11. Insert and manage simple graphics
    12. Add sound and movement to slides
    13. Send and receive email messages
    14. Organize your Inbox
    15. Manage scheduling
  2. Exam MO-100 Microsoft Word:
    1. Manage documents
    2. Insert and format text, paragraphs, and sections
    3. Manage tables and lists
    4. Create and manage references
    5. Insert and format graphic elements
    6. Manage document collaboration
  3. Exam MO-200 Microsoft Excel:
    1. Manage worksheets and workbooks
    2. Manage data cells and ranges
    3. Manage tables and table data
    4. Perform operations by using formulas and functions
    5. Manage charts
  4. Exam MO-300 Microsoft PowerPoint:
    1. Manage presentations
    2. Manage slides
    3. Insert and format text, shapes, and images
    4. Insert tables, charts, SmartArt, 3D models, and media
    5. Apply transitions and animations
  5. Exam MO-400 Microsoft Outlook:
    1. Manage Outlook settings and processes
    2. Manage messages
    3. Manage schedules
    4. Manage contacts and tasks
Contact Hours
108
CEU's
10.8
Industry Standard, State, or National Certification
Yes
Certification
Microsoft
Website URL
1.MO-100: Microsoft Word (Word and Word 2019) https://docs.microsoft.com/en-us/learn/certifications/exams/mo-100 2.MO-200: Microsoft Excel (Excel and Excel 2019) https://docs.microsoft.com/en-us/learn/certifications/exams/mo-200 3.MO-300: Microsoft PowerPoint (PowerPoint and PowerPoint 2019) https://docs.microsoft.com/en-us/learn/certifications/exams/mo-300 4.MO-400: Microsoft Outlook (Outlook and Outlook 2019) https://docs.microsoft.com/en-us/learn/certifications/exams/mo-400
Certification Learning Outcomes/Requirements
  1. MO-100: Microsoft Word (Word and Word 2019)
    • Manage documents
    • Insert and format text, paragraphs, and sections
    • Manage tables and lists
    • Create and manage references
    • Insert and format graphic elements
    • Manage document collaboration
  2. MO-200: Microsoft Excel (Excel and Excel 2019)
    • Manage worksheets and workbooks
    • Manage data cells and ranges
    • Manage tables and table data
    • Perform operations by using formulas and functions
    • Manage charts
  3. MO-300: Microsoft PowerPoint (PowerPoint and PowerPoint 2019)
    • Manage presentations
    • Manage slides
    • Insert and format text, shapes, and images
    • Insert tables, charts, smartArt, 3D models, and media
    • Apply transitions and animations
  4. MO-400: Microsoft Outlook (Outlook and Outlook 2019)
    • Manage Outlook settings and processes
    • Manage messages
    • Manage schedules
    • Manage contacts and tasks
CE to CU Articulation
No
Prerequisites
Prior to course enrollment, students should have the ability to demonstrate technological literacy in alignment with the Technology Basics for Digital Literacy course or have equivalent knowledge and skills.
Text and Supplies Needed
Clinical Site/Special Facilities
Requirements for Successful Completion of this Course
  1. Attendance 90% or above
  2. Participation
  3. Demonstrate an understanding of at least 80% of course material taught.
Accreditation/Special Approval Requirements
Intended Audience
Individuals who want to expand their knowledge and skills for employment-readiness or those who want to successfully prepare for the relevant industry certification exam(s).
Specific Industry or Business Support Needs
Administrative Assistant, Office Assistant, Office Administrator, Administrative Coordinator, Office Coordinator
Wake County Need for Industry Positions
According to Burning Glass Technologies, Wake County has a very high demand
Industry or Job Titles Related to training Outcomes for Employment
  • Administrative Assistant
  • Office Assistant
  • Office Administrator
  • Administrative Coordinator
  • Office Coordinator
Related Courses
  • Computer Technology Basics for Digital Literacy - CIS-3100L2
Course Contact Information
Jennifer Simmons-Bage
jsimmons6@waketech.edu
919-532-5915