Analyze an asset or license inventory in Excel
Task · License management
Time saved · 1-2 hrs per month (estimate, not measured)
Steps
- Open the file, email or meeting in the Microsoft 365 app
- Open the Copilot pane
- Enter the prompt
- Check output against the source content
Prompt / template
Which licenses are assigned to users who haven't signed in for 90 days? Show totals by department.
Source · https://support.microsoft.com/en-us/copilot-excel
Last checked · 2026-10-16