Build Excel spreadsheet models with plain-language prompts using ChatGPT for Excel

Build Excel spreadsheet models with plain-language prompts using ChatGPT for Excel

Published By the AI Academy editorial team · editorial policy8 min readBeginner

Build and update Excel spreadsheet models faster with ChatGPT for Excel by using simple plain-language prompts instead of manual formulas and repetitive edits.

TL;DR

You'll learn to install ChatGPT for Excel and use plain-language prompts to update formulas, edit assumptions, and add columns, saving hours of manual work. The tutorial shows how to review existing models, make changes, and verify accuracy, making Excel tasks faster and more efficient.

Who this is for

  • Financial analysts who need to update forecasts and budgets quickly
  • Operations managers who rely on Excel for planning and reporting
  • Data analysts who want to automate repetitive spreadsheet tasks

What you'll build

You'll be able to update and enhance Excel spreadsheet models by using plain-language prompts to edit formulas, assumptions, and add new calculated columns.

Steps in this tutorial

  1. Step 1 - Install the ChatGPT for Excel plugin
  2. Step 2 - Review the existing spreadsheet model
  3. Step 3 - Edit assumptions and input values
  4. Step 4 - Add new calculated columns
  5. Step 5 - Reorganize and clean the model

The step-by-step instructions, prompts and screenshots are for AI Academy subscribers.

AI Academy

Unlock the full AI Academy

This tutorial and every other one, on ChatGPT, Claude, Midjourney & the other AI tools we cover

Regular price $40$19/mobilled annually ($228 a year)
Try free for 7 days

Start risk-free · Cancel anytime