Advanced Office Productivity and Collaboration

This unit builds on foundational Office skills to introduce advanced formatting, automation, data management, and collaboration features across Word, Excel, PowerPoint, Outlook, Teams, and Access. Students will learn to optimize files for sharing and performance, apply data integrity tools, and participate in professional communication and meeting workflows.

Learning Objectives

• Apply advanced formatting, automation, and multimedia features in Word, Excel, and PowerPoint (e.g., tables of contents, AutoFill, AutoCorrect, templates, slide backgrounds, audio, and image compression) to produce professional documents, worksheets, and presentations that meet specified layout and accessibility criteria.
• Demonstrate collaborative communication and scheduling workflows using Outlook and Teams by sending and receiving messages, sharing contacts, scheduling appointments and meetings, managing buddy lists, and engaging in virtual meetings according to workplace protocols.
• Analyze and manage file and folder organization, permissions, recovery, and export options (including saving as web pages, using the Recycle Bin, restoring deleted files, and setting file/folder permissions) to optimize storage, sharing, and retrieval of Office assets.
• Evaluate and apply data integrity and analysis techniques in Excel and Access (setting field properties, finding records, constructing queries, copying formulas, using Goal Seek, laying out tables, and positioning charts) to prepare accurate datasets and actionable reports.