Course Outline

Module 1 – Advanced Excel for Decision-Making (6 hours)

  • Exploration of advanced formulas and functions, including INDEX/MATCH, XLOOKUP, IF statements, and nested formulas
  • Utilization of data analysis tools such as PivotTables, PivotCharts, and the basics of Power Query
  • Automation techniques using macros and Copilot-generated suggestions
  • Development of dashboards and reports to provide leadership insights for government operations
  • Practical exercises focusing on healthcare and management scenarios relevant to public sector decision-making

Module 2 – PowerPoint for Impactful Presentations (6 hours)

  • Techniques for professional slide design and effective storytelling
  • Strategies for data visualization and the appropriate use of charts in presentations
  • Integration with Excel and Copilot-generated content to enhance presentation quality
  • Tips for engaging executive audiences within a government context
  • Final project: constructing a presentation using Copilot's assistance for government purposes

Module 3 – Word for Professional Documentation (6 hours)

  • Methods for creating and formatting professional reports and proposals for government use
  • Utilization of templates and styles to ensure consistency and efficiency in documentation
  • Integration of Copilot for writing, summarizing, and editing content for clarity and precision
  • Collaboration tools and version control strategies for team-based document creation
  • Practical exercise: building a leadership report for government review

Module 4 – Outlook for Productivity and Team Organization (6 hours)

  • Advanced techniques for email and calendar management to enhance productivity for government staff
  • Use of rules, categories, and automation features to streamline workflows
  • Leveraging Copilot for drafting, summarizing, and scheduling tasks efficiently
  • Integration with Microsoft Teams and other Microsoft 365 tools for seamless collaboration
  • Leadership-focused time management strategies to optimize government operations

Module 5 – Microsoft Copilot in Leadership Workflows (6 hours)

  • Overview of Copilot's capabilities across the Microsoft 365 suite for government applications
  • AI-assisted task automation in Excel, Word, and Outlook to support government workflows
  • Best practices for designing prompts to maximize the effectiveness of Copilot
  • Ethical considerations and data privacy best practices when using AI tools in a government setting
  • Hands-on practice: creating and refining workflows using Copilot for government tasks

Summary and Next Steps

Requirements

  • An understanding of fundamental data management and reporting concepts for government.
  • Experience with Microsoft Office applications, including Excel, Word, PowerPoint, and Outlook.
  • Familiarity with online collaboration tools such as Teams or OneDrive.

Audience

  • Managers and decision-makers in the public sector looking to enhance productivity using Microsoft 365 and Copilot for government.
  • Professionals responsible for preparing reports, presentations, and documentation for leadership within government agencies.
  • Teams aiming to leverage AI tools for automation and strategic insight generation to support governmental operations.
 30 Hours

Number of participants


Price per participant

Upcoming Courses

Related Categories