Topic

AI for Excel

Formulas, pivot tables, data cleaning, VBA and dashboards with Copilot, ChatGPT and other AI tools.

Free courses

AI for Excel: Beginner to Confident

A free, hands-on course that teaches you to use AI assistants for Excel formulas, lookups, data cleaning, pivot tables, charts, reports and simple macros, and how to check every result before you trust it.

8 lessons 98 min Start →

Guides and posts

AI for Excel

10 AI Prompts for Cleaning Messy Excel Data

Extra spaces, text dates, mixed capitals, duplicates and merged cells: ten copy-ready prompts that get AI to give you the exact Excel formula or steps to clean messy data fast.

2 Nov 2026

AI for Excel

XLOOKUP vs VLOOKUP: Which to Use, and How AI Can Write Both

A simple comparison of XLOOKUP and VLOOKUP in Excel, which versions support each, the mistakes that cause wrong results, and prompts to get AI to write and explain lookups for you.

21 Oct 2026

AI tools for AI for Excel

Microsoft Copilot

Freemium

Microsoft's AI assistant in Windows, Edge and Microsoft 365 apps like Excel, Word, Outlook and Teams.