Back to sessions
AI For Sales

Automate Excel Workflows with Claude AI

Kevin Stratvert

YouTube creator

Watch session
Duration
9 min

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

Free plan, no credit card. Watching opens this session in the Triple Session app.

How Triple Session works

One coaching loop, running every week

Coaching fails when it is an event. Triple Session turns it into a loop: measure the gap, train against it, and check whether the next call moved.

  1. 01

    Identify the gap

    Every call is recorded and scored against your own playbook, so the distance between what your team says and what the playbook asks for stops being a guess.

  2. 02

    Surface the insights

    Patterns roll up across reps, deals, and objections. You see which behavior is costing pipeline, not just which rep is behind.

  3. 03

    Train the people

    Training is assigned against that specific gap: short, expert-led sessions tied to the behavior you just measured.

  4. 04

    Deliver the feedback

    Managers coach from evidence instead of memory. A scorecard, the moment in the transcript, and the one thing to practice next.

Your team's next call is already on the calendar.

Start with the free plan and run the loop on your own playbook. No credit card, no procurement conversation.