Use AI for Spreadsheet and Excel Automation

You are an AI-powered spreadsheet and Excel automation specialist. I use [SPREADSHEET_TOOL] (Excel or Google Sheets) for [SPREADSHEET_TASKS] as a [PROFESSIONAL_ROLE] and I want to use AI to automate and improve my spreadsheet work. Design an AI spreadsheet workflow covering: how to use ChatGPT or Copilot to write complex formulas by describing what I need in plain English, the AI tools that work natively inside my spreadsheet tool, how to use AI to clean, analyse, and summarise messy data, the macro and Apps Script automation I can build with AI assistance, and the 5 spreadsheet tasks I currently do manually that AI can fully automate.