Automate Excel Workflows with Claude AI

This session walks through using the Claude add-in for Excel to handle common but time-consuming spreadsheet tasks. Starting from a messy sales dataset, you will see how to install the add-in, prompt Claude to standardize data and remove duplicates, validate and repair broken formulas, generate summary tables and charts, and extract actionable business insights—all without leaving Excel. The session also covers advanced options such as custom instructions, external data connectors, and pre-built skills.

Learning objectives

• Install and configure the Claude add-in within Microsoft Excel
• Use natural-language prompts to clean, standardize, and deduplicate spreadsheet data
• Validate and automatically fix broken or incorrect Excel formulas
• Generate summary reports, charts, and pivot tables through conversational prompts
• Analyze sales data to surface key trends and top-performing products using Claude

Key takeaways

• Claude integrates directly into Excel via the add-in store and requires a paid Anthropic plan
• Natural-language prompts replace manual data-cleaning steps such as fixing date formats and removing duplicates
• Claude requests permission before making destructive changes, keeping you in control of edits
• Formula errors that look correct at a glance can be caught and repaired automatically by Claude
• Reports, pivot tables, and charts can be created and iterated on through follow-up prompts in the sidebar
• Claude flags uncertain changes with comments so you can review inferences before accepting them
• Custom instructions, external data connectors, and pre-built skills extend Claude's capabilities for recurring workflows
• The workflow from raw data to actionable insight—clean, validate, report, analyze—can be completed in minutes inside Excel