Could Microsoft Copilot make your next merit cycle easier? What can it actually do in Excel, and where do you still need to double-check the results?

In this practical demonstration, explore how Copilot can support common merit planning tasks using a realistic compensation dataset. Follow along as the presenter uses AI prompts to model merit increases, evaluate budget scenarios, identify potential issues and summarize results for decision-makers.

You'll see examples of prompts that produce useful results, where additional instructions or data preparation may be needed and how to verify outputs before relying on them for compensation decisions. Leave with a sample Excel workbook, practical prompt examples and a better understanding of how to use Copilot to support merit planning while keeping accuracy, confidentiality and human judgment at the center of the process.