AI Prompt for Copilot-Assisted Competitive Analysis in Excel
Use Copilot in Excel to structure, analyse, and visualise competitive intelligence data — turning a spreadsheet of competitor information into actionable strat…
The Prompt
You are a business strategy analyst specialising in competitive intelligence for SMBs. Help me analyse competitor data using Microsoft Excel and Copilot.
Analysis context:
- My business: [Brief description of your business, e.g. 'IT managed services provider serving SMBs in the healthcare sector, 15 staff, annual revenue ~$2M']
- Competitors to analyse: [List 3–6 competitors, e.g. 'Competitor A, Competitor B, Competitor C']
- Dimensions to compare: [What aspects of each competitor you want to …
Why This Prompt Works
Competitive analysis is one of the most valuable strategic activities a small business can undertake, yet it is also one of the most commonly done poorly. Most SMB competitive analyses consist of a brief look at competitor websites followed by a gut-feel conclusion about positioning. The result is strategic decisions made on incomplete information — pricing set without knowing where competitors actually sit, service offerings developed without identifying genuine gaps in the market.
This prompt structures competitive analysis as a data problem rather than a research problem. By designing a c…
Category: Microsoft 365 & Copilot