Best AI for Excel: A Practical Guide

Where AI helps most in Excel

AI excels at three Excel jobs: translating plain English into formulas, explaining and fixing broken formulas, and generating VBA or Power Query steps for automation. It turns hours of trial and error into seconds.

Writing formulas with AI

Describe the result you want plus your column layout and Excel version. The model returns a formula and an explanation. Always mention whether you have Excel 365, since functions like XLOOKUP and LET are version-specific.

Automating with VBA and Power Query

For repetitive tasks, ask for a commented VBA macro. For messy imports, ask for Power Query M steps. Both are ideal for AI because they are rule-based and well-documented.

Cautions

Always keep a backup before running generated macros, and sanity-check formulas on a small sample. AI is a powerful accelerator, not a replacement for verification.

A simple workflow that works

A reliable pattern is to describe the outcome you want, paste your column headers and a few sample rows, and name your Excel version so the model does not suggest a function you cannot use. Ask it to return the formula, explain each argument in plain language, and offer one alternative approach. The explanation is what builds your skill over time, not just the answer, so always request it even when the formula looks obvious.

For anything repetitive, ask for a commented VBA macro or a set of Power Query M steps, then run them on a copy of your workbook first. Keep the generated code in a notes file with a short description of what it does, so the next time a similar task comes up you can adapt it in minutes instead of starting from scratch. This turns one-off help into a growing personal toolkit that compounds every month.