CDEV049 - Microsoft Office Fundamentals: Level Two

Course Description

This course builds on existing Microsoft 365 knowledge to develop advanced productivity, data analysis, automation, and collaboration skills. Learners refine expertise in Excel (advanced formulas, PivotTables, Power Query), Word document automation such as customizing styles, developing Table of Contents, and mail merges, PowerPoint branding and multimedia presentations, and integrated workflows using Outlook, Teams, SharePoint, Forms, and OneNote. Emphasis is placed on efficiency, accuracy, and professional output, including the use of Copilot and macros to reduce repetitive tasks. Learners apply advanced tools to real-world scenarios, strengthening digital independence, problem-solving skills, and strategic use of Microsoft 365 in complex workplace environments, as well as analyzing future developments in CoPilot. 

Course Outline

• Unit 1 Word – Intermediate to Advanced
• Unit 2 Outlook - Work with newer features such as Todo for Tasks and shared collaboration/tracking in Teams and OneNote
• Unit 3 Teams – Collaboration and Communication with Outlook
• Unit 4 PowerPoint - Intermediate to Advanced
• Unit 5 Excel - Intermediate to Advanced
• Unit 6 OneNote - Collaboration/Brainstorming Tool and integration with Teams, Outlook 
• Unit 7 Microsoft Forms  Development of Online Forms (frontend) and integration with Excel (as backend of the database). Forms shared via OneDrive vs. SharePoint
• Unit 8  Automation/Integration - Advanced integration using scripts, macros, branding of products within the suite of applications and investing CoPilot agents and possible Copilot Coworker.

Learner Outcomes

• Design sophisticated, branded Word and PowerPoint outputs, including automated documents and multimedia presentations that meet professional and organizational standards.
• Automate and streamline document and workflow processes using macros, themes, and integrated Microsoft 365 applications to reduce repetitive tasks and improve efficiency.
• Analyze and manipulate complex datasets using advanced Excel tools, including formulas, PivotTables, Power Query, and data visualization techniques for decision-making.
• Integrate Microsoft 365 applications (Outlook, Teams, SharePoint, Forms, OneNote) to create coordinated, collaborative, and secure workplace workflows.
• Critically evaluate and apply Copilot-generated content by validating accuracy, maintaining ethical use, and leveraging AI tools strategically in complex workplace contexts.