# Excel Automation Guides

Task-focused walkthroughs for the things people most often want an AI assistant to
do in Excel. Each guide shows what to ask for, the equivalent CLI commands, how to
verify the result, and the gotchas that bite people.

For the exhaustive operation reference, see the
[feature documentation](/features/).

## Automating data

- **[Refresh Power Query from an AI assistant](/guides/refresh-power-query/)** —
  refresh one query or all of them, test M code before committing it, and choose
  where the data lands.
- **[Query the Excel Data Model with DAX](/guides/query-data-model-with-dax/)** —
  create measures, run DAX queries, inspect the model with DMVs, and manage
  relationships.

## Building reports

- **[Build and update PivotTables with an AI assistant](/guides/automate-pivottables/)** —
  choose the right source, configure fields, chart the result, and keep everything
  refreshed.

## Working with existing workbooks

- **[Run VBA macros from an AI agent](/guides/run-vba-macros/)** — enable VBA trust,
  inspect modules, execute macros, and import new code.

## Choosing an approach

- **[Real Excel automation vs. file-parser libraries](/guides/excel-automation-vs-file-parsers/)** —
  what COM automation can do that `openpyxl`, `ExcelJS`, and `EPPlus` cannot, and
  when a file parser is the better choice.