Find a course

At the end of this “Excel Expert” course, participants should be able to:

• Manage Workbook Options and Settings: Candidates should be able to manage workbook options and settings.
• Manage and Format Data: Candidates should be able to manage and format data.
• Create Advanced Formulas and Macros: Candidates should be able to create advanced formulas and macros.
• Manage Advanced Charts and Tables: Candidates should be able to manage advanced charts and tables.

At the end of this course, participants should be able to:

• Identify the core components integral to Copilot for Microsoft 365.
• Articulate Microsoft's dedication to responsible AI practices.
• Identify and apply the key features of Copilot for Microsoft 365 in each Microsoft 365 application to enhance your productivity and workflow.
• Analyze how Copilot for Microsoft 365 integrates with Business Chat in Teams to provide a centralised hub for all your work-related information.
• Utilise the AI capabilities of Copilot for Microsoft 365 to transform your approach to tasks in Microsoft 365, making them more intuitive and efficient.
• Describe the best practices for using Copilot for Microsoft 365.
• Demonstrate how to effectively prompt Copilot for Microsoft 365.
• Describe the capabilities of plugins within Copilot for Microsoft 365.
• Understand Microsoft Graph connectors and how they can be used to integrate data from external sources into Copilot for Microsoft 365.
• Perform a series of hands-on exercises focusing on using Copilot in various Microsoft 365 apps.

• Describe Windows 10 and Windows 11.
• Explain the new features available in Windows.
• Explain the benefits of using the Windows client for small and medium-sized organizations.
• Discuss managing the Windows client in an enterprise environment.
• Understand the deployment and configuration processes of Azure SQL Server.

At the end of this training, participants should be able to:

• Optimize workflows and automate administrative tasks using Copilot capabilities within Microsoft 365 environments.

• Deploy and manage a Microsoft 365 tenant (25–30%): This involves setting up and customizing Microsoft 365 tenants and services.
• Implement and manage identity and access in Microsoft Entra ID (25–30%): This includes managing user identities, roles, and access.
• Manage security and threats by using Microsoft 365 Defender (25–30%): This involves deploying apps and data security tools and understanding the threat protection.
• Manage compliance by using Microsoft Purview (15–20%): This includes data governance solutions and configuring collaboration and mobility features.

At the end of this course, participants should be able to:

• Describe the Basics of Prompt Engineering
• Identify Key Components of an Effective Prompt
• Develop Skills in Refining Prompts
• Apply Best Practices for Different Use Cases
• Evaluate and Improve Prompt Effectiveness

At the end of this course, participants should be able to:

• Define key aspects of user enablement for transitioning to an AI-driven organization with Copilot for Microsoft 365.
• Strategize and prepare for the adoption of Copilot for Microsoft 365 within your organization.
• Implement strategies to effectively integrate and empower employees to use Copilot for Microsoft 365.
• Evaluate and enhance the value and impact of Copilot for Microsoft 365 through feedback analysis and success measurement.
• Apply advanced methods to extend and optimize the functionality of Copilot for Microsoft 365 in your business processes.

At the end of this course, participants should be able to:

• Leverage Microsoft 365 Copilot to align with organizational goals and objectives. 
• Optimize IT strategies and resources, driving digital transformation initiatives through Copilot features. 
• Lead discussions on implementing Copilot for enhancing organizational productivity and efficiency.
• Drive strategic initiatives that leverage Microsoft 365 capabilities effectively.

At the end of this course, participants should be able to:

• Describe ways to extend Microsoft 365 Copilot to fit unique business needs, enriching user workflows.
• Describe how Graph connectors can be used to enhance Copilot's data access and discoverability for real-time engagement.
• Describe how plugins can expand Copilot's skills, allowing interaction with real-time data across Microsoft 365 apps.
• Describe ways to build custom copilots using foundational models for specialized user interactions within Microsoft 365.
• Describe the capabilities of Copilot Studio for extending Microsoft 365 Copilot.
• Describe the requirements for creating Copilot Studio actions.

At the end of this course, participants should be able to:

• Analyze Microsoft Copilot’s capabilities.
• Develop effective prompts.
• Incorporate Copilot into daily workflows.