Hello folks, Kamil here. In this video I put together a quick, hands-on demo showing how you can use Microsoft Copilot inside Excel to analyze raw vulnerability scan data without doing the whole manual grind or living in pivot tables. If you’re an ISSO, vulnerability management analyst, or you’re supporting RMF/FISMA/ATO work, you already know how often scans land in spreadsheets—and how fast leadership wants “what matters” out of it. I walk through the exact prompts I use to get Copilot to extract unique plugin IDs, map affected hosts, and build a clean consolidated output with the fields you actually need: plugin ID, host, risk, synopsis, solution, and plugin output—on a new downloadable sheet. Then I have Copilot generate a dashboard in the same workbook with a histogram, bar chart, and pie chart so you can immediately see the critical/high/medium/low distribution. The key takeaway is prompt engineering. My first pass still had duplicate plugins, so I re-prompted Copilot to consolidate them properly and group hosts into a single row. Then I prompted it again to sort risk in the order I want (critical, high, medium, low) and remove “none”/empty rows so the final analysis is clean and usable for real decision-making.