Turn Messy Spreadsheets Into Insights in Seconds With This Copilot Excel Feature (Cool Tools 77)

Andrew Miles Davis covers three tools on this week's Cool Tools Tuesday, leading with a genuine change of opinion on Copilot's integration with Excel, which he had previously dismissed after a poor experience with a similar feature in Gemini a year earlier. He walks through five practical use cases including turning messy spreadsheets into instant insights, generating charts and pivot tables from plain language requests, writing formulas without needing to know the syntax, automatically cleaning data and standardising UK date formats, and summarising what has changed across workbook versions, concluding that the native Copilot integration outperforms both ChatGPT and Claude's Excel connectors. He also covers Umind.com's prompt library, a free daily-updated resource of trending prompts across images, video, and text, and IdeaVideo.ai, a free video generation aggregator giving access to Seedance, Veo, Kling, and other major models, positioned as a low-stakes starting point for marketers wanting to build video skills without committing to a paid platform. Subscribe to In AI Nutshell for three new tools every Tuesday with honest verdicts from someone testing them in real work.