How to use Copilot in Excel and power your spreadsheets with AI

In 2023, Microsoft introduced Copilot in Excel, an AI assistant built into the application as a sidebar, utilizing OpenAI's models similar to those in ChatGPT. This integration aims to simplify tasks like writing formulas, data analysis, formatting, and data cleanup by allowing users to input plain language commands, thus enhancing productivity and reducing reliance on manual formula writing. Microsoft 365 subscribers can access Copilot with specific plans, while those without corporate subscriptions receive limited monthly AI credits. Though Copilot is reactive and only works upon user prompts, tools like Zapier can enable automation by integrating external app triggers, offering a more proactive approach. In comparison, Google's Gemini in Google Sheets offers similar functionalities, though access varies based on Google Workspace plans. Despite its improvements since its launch, Copilot remains an AI assistant that requires direct user interaction, with automation potential through third-party integrations.