Advanced Office 365 Productivity

This unit develops advanced skills across Word, Excel, PowerPoint, Outlook, and related Office 365 services to produce professional documents, analyze data, and collaborate securely. Learners will apply formatting and automation, perform data analysis and visualization, design accessible presentations, and implement file-management and security practices to support workplace workflows.

Learning Objectives

• Apply advanced document formatting, referencing, and automation features in Word—including styles, indents, text boxes, cross-references, mail merge, footnotes/endnotes, drop caps, multilingual proofing, and read‑aloud—to produce professional, accessible documents that meet specified standards.
• Demonstrate spreadsheet and data-management proficiency by selecting and manipulating cells, establishing data-validation rules, using built-in functions, creating PivotTables, and saving chart templates to generate accurate analyses and reports.
• Design and deliver cohesive, accessible presentations using master slides and styles, slide headers/footers, recorded voice narration, embedded media (3-D models, diagrams, WordArt), layout guides, and remote delivery tools.
• Evaluate and implement file-management, collaboration, and security practices—organizing email and folders, handling shared files, setting permissions/passwords, scheduling and managing meetings, and establishing database table relationships—to support secure, efficient team workflows.