Chief-of-Staff Priority Audit with Output : Excel Workbook

[OVERVIEW] I used Copilot enabled with Work IQ to output list of my work priorities in excel. This was hugely helpful in getting my current, ongoing tasks, identifying time-saving opportunities. I then discussed this with my manager who assigned priority labels and increased my efficiency & time management. [TRYABLE] Role You are my Chief of Staff. You are rigorous, sceptical of noise, and allergic to invented detail. Your job is to give me an honest picture of what I am actually accountable for right now — not a flattering one, and not a list of everything that has touched my inbox. Step 1 - Retrieve Search my emails, chat messages, calendar meetings and documents from the last [30] days. Search all four sources before drawing any conclusions. Prefer recent and high-signal items: threads where I am a named owner, meetings where I hold an action, and documents I have authored or been assigned in. Step 2 - Consolidate Where the same piece of work appears across multiple sources, merge it into a single entry and cite all contributing sources. Apply an inclusion test to every candidate: does it have a clear owner or a clear next action? If not, drop it. Exclude FYI-only threads, newsletters, calendar holds without deliverables, and anything already closed with no residual action. Step 3 - Build the workbook Produce a downloadable Excel (.xlsx) workbook with two tabs. Tab 1 – "Priorities" - one row per priority: Priority Name | Workstream | Description (one line) | Status (Not Started / In Progress / Blocked / Complete) | Priority Level (High / Medium / Low) | Owner | Key Stakeholders | Next Action | Due Date | Source Sort by Priority Level (High first), then Due Date ascending. Where a due date is not explicitly stated in the source, leave the cell blank — do not infer, estimate or approximate one. Tab 2 – "Summary" - a count of priorities by Status, a count by Workstream, and a three-bullet executive summary of where I should concentrate this week. Each bullet must name a specific priority and the reason it is urgent, not generic advice. Formatting Bold header row with contrasting fill and white text; frozen top row; auto-filter enabled; column widths sized to content; wrapped text in the Description and Next Action columns; conditional colour-coding on Status (green = Complete, amber = In Progress, red = Blocked, grey = Not Started). Evidence rules - non-negotiable Every cell must trace to retrieved content. Do not invent dates, names, owners or statuses. If a field is genuinely unknown, leave it blank. If you found fewer priorities than expected, say so rather than padding the sheet. After the workbook, list in chat any items you excluded and the one-line reason so I can challenge your judgement. [SETUP] Licensing and access Microsoft 365 Copilot licence (the paid add-on - Copilot Chat on its own won't reach work data). Work IQ enabled on the tenant, so Copilot can reason across the mailbox, Teams, calendar and files together rather than one source at a time. Standard M365 apps in active use: Outlook (mail and calendar), Teams, and SharePoint/OneDrive for documents. The output quality depends entirely on how much of the person's work actually lives in these. Permissions Copilot only sees what the user already has access to, so no extra permissions are needed - but equally, anything held in a system Copilot can't reach (Monday.com, Power BI, a colleague's private notes) won't appear unless the user pastes it in. For the Excel output Copilot needs file-creation enabled in the chat experience - this produced an .xlsx saved to OneDrive. If a tenant restricts file generation, the same content can be returned as a table in chat and pasted into Excel manually, though the formatting and conditional colour-coding would then have to be applied by hand. [IMPACT] Goal: replace the manual effort of trawling emails, Teams chats, meetings and documents to work out what I'm actually on the hook for, and turn it into a single, structured view I could take straight into a manager conversation. Results: Copilot scanned 30 days of activity across all four sources hundreds of emails plus chats, meetings and files and consolidated them into 8 de-duplicated priorities with owner, status, priority level, stakeholders, next action, due date and source reference, delivered as a formatted Excel workbook with a summary tab and three-bullet weekly focus. Time saved: roughly 6-7 hours of manual triage and formatting reduced to a few minutes, and repeatable monthly with the same prompt. Quality improvement: every row is traceable back to a source item, with due dates left blank rather than guessed so nothing is invented and nothing FYI-only clutters the list. Outcome: used directly in a 1:1 with my manager to agree priority labels, surface where I was over-committed, and re-sequence the week. [LESSONS] It would work best if you have Work IQ enabled. You would need to specifically mention to examine all mails, chat interactions to capture all requests. Be explicit about the time window and about excluding FYI-only threads, otherwise the output balloons. Also instruct it to leave due dates blank where none is stated. It will otherwise fill gaps with plausible but invented dates. [SAMPLE_OUTPUT] I can't upload the output excel file here due to org restrictions