Stop writing nested IFs. Open Copilot in Excel, turn on Edit, and paste:
1. Clean the Rep Name column: trim extra spaces, fix capitalization, flag duplicates in a new column.
2. Add a Region column to Orders by matching Customer ID from the Customers sheet. Show Not found if missing.
3. Highlight orders where Ship Date is more than 5 days after Order Date in red, then sort newest first.
4. Add a Category column tagging each Customer Note as Pricing, Delivery, Product, or Other.
5. Build a PivotTable of Revenue by Region and Month, with a month over month % change column.
6. Use Python to forecast the next 3 months of Revenue and chart actual vs forecast.
7. Build a Sales dashboard sheet: KPIs for Revenue, Orders, Avg Deal, plus charts by Region and Month.
Works in Edit mode on Windows, Mac and web. Always check the result before you share it.
📄 All 7 prompts (PDF): https://www.fromzerotoheroes.com/guides/office-productivity/7-excel-copilot-prompts.pdf
🚀 Go deeper in the Inner Circle (7-day free trial): https://www.fromzerotoheroes.com/inner-circle.html#join
#Excel #MicrosoftCopilot #Microsoft365 #ExcelTips #Productivity #AI