You want to use voice input with Copilot on the Microsoft 365 mobile app instead of typing queries. Copilot Voice lets you speak prompts naturally, and the feature replies with spoken answers while also showing text in the chat. This article explains the requirements and shows you exactly how to turn on voice mode in … Read more
Microsoft Copilot for Service is a dedicated AI assistant that helps customer service agents resolve issues faster. It integrates directly with Dynamics 365 Customer Service to bring knowledge articles, case history, and real-time data into the Copilot chat. Many organizations struggle to set up this connection correctly, resulting in Copilot showing generic answers instead of … Read more
You want Copilot in Excel to analyze data that was transformed or loaded using Power Query, but Copilot may not respond to queries after a refresh. This happens because Copilot reads the current state of the worksheet, not the Power Query engine directly. This article explains how to structure your Excel workbook so Copilot can … Read more
Many Excel users work with Power Pivot to build large data models, run DAX calculations, and create advanced pivot tables. When Microsoft added Copilot to Excel, it promised natural-language querying and automated analysis. But Power Pivot data models do not always behave like standard Excel tables. This article explains which Power Pivot features Copilot can … Read more
When you ask Copilot in Excel to analyze or manipulate data by referencing a named range, it may ignore the name or return an error. This happens because Copilot requires named ranges to follow specific naming conventions and be visible in the Excel table structure. This article explains the exact naming rules Copilot enforces, shows … Read more
When you use Copilot in Excel to generate formulas, the output may use commas as argument separators. But if your regional settings use semicolons for list separators, those formulas will fail with a #NAME? or #VALUE! error. This mismatch happens because Copilot reads your locale information incorrectly or defaults to US English formatting. This article … Read more
You want to look up values from several worksheets in a single Excel workbook, but building the formula manually takes too long. XLOOKUP is a powerful function, but combining it across multiple sheets usually requires nested IFERROR or complex array formulas. Copilot in Excel can write these formulas for you using natural language prompts. This … Read more
When you ask Copilot in Excel to sort, filter, or calculate dates, the results might show the wrong month and day if your workbook uses a different date format than the one Copilot expects. This happens because Copilot reads the underlying date serial number in the US month-day-year format by default, even when your Windows … Read more
Official documentation checked October 14, 2026. Copilot can help you build a cohort retention analysis in Excel, but the result is only useful if the cohort, activity, and denominator are defined correctly. Counting every event as another retained user can inflate retention beyond 100%. The workflow below measures calendar-month user retention: unique acquired users who … Read more
When you ask Copilot in Excel to summarize or analyze a pivot table that contains calculated items, it often returns an error message or a blank response. This happens because Copilot reads the underlying data cache of the pivot table, but calculated items are stored as metadata rules rather than row-level data. Copilot cannot interpret … Read more