Intermediate Office Productivity

This unit develops intermediate skills across Office 365 applications to create, format, troubleshoot, and share professional business documents, spreadsheets, presentations, and databases. Students will integrate collaboration and file-management practices while applying data validation and forecasting tools to support accurate, secure workplace communication and decision-making.

Learning Objectives

• Analyze and correct data integrity and calculation issues in workbooks and databases using notes, field properties, queries, search tools, and Goal Seek to produce accurate results and forecasts.
• Apply advanced document and presentation formatting techniques—such as templates, tables of contents, text frames, chart placement, audio embedding, and image compression—to produce polished business documents and slides.
• Demonstrate effective collaboration and communication using Outlook and Teams by managing contacts and calendars, scheduling meetings, sharing files, configuring permissions, restoring items from the Recycle Bin, and participating in meetings.
• Evaluate and implement appropriate file-management and publishing options, including saving files as web pages, using AutoFill/AutoCorrect efficiencies, setting folder permissions, and optimizing templates to improve productivity and secure shared resources.