Intermediate Office Productivity Skills

This unit builds on foundational Office 365 skills and covers intermediate application features across Word, Excel, PowerPoint, Outlook/Teams, Publisher/Access, and file management. Students will apply formatting, data tools, multimedia, collaboration, and file-administration techniques to create professional, work-ready documents and communications while preparing for advanced integration and automation in the final unit.

Learning Objectives

• Apply advanced document and desktop-publishing features to produce structured, professional documents and publications (including tables of contents, templates, margin/layout control, text wrapping, design checking, and validated fields).
• Demonstrate spreadsheet problem-solving by using AutoFill and AutoCorrect, copying formulas, applying notes, positioning charts, and using Goal Seek to model and forecast data scenarios.
• Create and deliver multimedia-rich presentations by customizing slide backgrounds and layouts, positioning text and objects, embedding audio, compressing images, and configuring slideshow settings for effective delivery.
• Manage communication, collaboration, and file administration tasks by composing and receiving email, scheduling meetings, sharing contacts, using Teams, configuring file/folder permissions, restoring items from the Recycle Bin, and leveraging lists/queries for organized data access.