Getting Started with ChatGPT Inside Excel: A Walkthrough for Finance Professionals

For years, the dream for FP&A teams was simple: stop switching between the browser tab where ChatGPT lives and the workbook where the actual work happens.

Copying a table out, pasting it into a chat window, asking your question, copying the answer back, and praying the formatting survived the round trip. It worked, but it was clunky, and it broke your flow every single time.

That gap has now closed. ChatGPT now lives inside Excel as an official add-in from Open AI, sitting in a sidebar right next to your cells. It can read your workbook, write formulas, build tabs, audit structure, and explain what a model is actually doing without you ever leaving the spreadsheet.

For anyone who spends their day in budgets, forecasts, and variance reports, this is one of the most practical AI upgrades to land in a long time. This article walks you through getting it set up, then takes you on a tour of the interface so you know exactly what every button does before you start.

Why This Matters for FP&A

The official ChatGPT for Excel add-in is a spreadsheet-native assistant. It understands the context of your file multiple tabs, formulas, references, and assumptions and can act on that context directly.

For finance work, that changes everything.

Think about the tasks that eat your time: rebuilding a sensitivity table, tracing where a number is feeding in from, cleaning a messy export from your ERP, drafting the first cut of a three-statement structure, or sanity-checking that every entity tab exists before you consolidate. These are exactly the jobs the add-in is built for. You describe what you want in plain English, and it does the work in the sheet while you review.

The mental model to hold onto is this: it’s not a calculator and it’s not a replacement for your judgment. It’s a fast, tireless analyst sitting next to you, doing the mechanical 80% so you can spend your time on the 20% that actually needs a finance brain.

Step 1: Check You’re Eligible

Before installing, a quick eligibility note. The official add-in is available to ChatGPT Free, Go, Plus, Pro, Business, Enterprise, and Edu/K-12 accounts, though access can vary by region, your plan, and your organisation’s Microsoft 365 admin settings. ChatGPT for Excel is generally available; the PowerPoint version is still in beta.

If you’re on a corporate machine and the add-in doesn’t appear, that’s almost always an admin control rather than a problem on your end your Microsoft 365 administrator can deploy it internally using the manifest file. Worth knowing before you waste twenty minutes troubleshooting.

Step 2: Install the Add-In

Installation takes about two minutes:

1. Open Microsoft Excel desktop or web both work.

2. Go to the Insert tab (or Home → Add-ins, depending on your version) and click Get Add-ins to open the Microsoft Marketplace.

3. Search for ChatGPT.

4. Click Add and accept the permissions prompt.

5. Once installed, you’ll find a ChatGPT button on the ribbon. Click it.

6. The sidebar opens. Sign in with the Open AI account tied to your plan.

That’s it. There’s no API key to paste, no billing setup to wrestle with, no separate credits to track a welcome change from the older third-party plugins. You authenticate with the same account you use for ChatGPT everywhere else.

Step 3: The Ribbon and Sidebar Walkthrough

Here’s where it pays to slow down. The interface is clean, but a few features quietly determine whether you’ll trust this tool with real work. Let’s go through them.

The launch point: The ribbon

The ribbon button is simply your on/off switch. Click it and the ChatGPT panel slides open on the right side of your workbook. All the real interaction happens in that sidebar, so don’t go hunting for a sprawling ribbon tab full of icons, there isn’t one, and that’s by design. The intelligence lives in the conversation, not in a menu of buttons.

The chat panel

At the top you’ll see New chat, a pencil icon to start fresh, and a small menu. Below that is the main workspace where your conversation appears. When you open a blank chat, the add-in offers Suggested prompts to get you moving. In a finance context these are genuinely useful starting points —things like “Create a basis points conversion table,” “Set up a simple rate sensitivity sheet,” and “Audit workbook structure for missing tabs.” They’re not just decoration; they hint at the kind of structured, model-aware work the tool is good at. Use them as inspiration, then write your own.

The prompt box

At the bottom sits the input field: “Ask anything, @ for context.” That @ symbol is the feature most people miss, and it’s the most important one for FP&A. Typing @ lets you point the assistant at specific context. A particular range, tab, or element of your workbook. So it works on exactly what you mean instead of guessing. When you’re dealing with a fifteen-tab consolidation file, telling it precisely which numbers to look at is the difference between a useful answer and a confused one.

The plus (+) menu

Next to the prompt box is a + button. Open it and you get three options: –

Upload files: Bring an external file into the conversation. Drop in a CSV export from your ERP, a bank statement, or last year’s actuals, and ask the assistant to build from it.
Skills are reusable instructions or capabilities you can invoke for repeatable workflows.
Apps are connections to other tools and data sources. For finance teams, Upload files alone is a workflow-changer. Half of FP&A is wrangling data that arrives in the wrong shape; being able to hand the raw file straight to the assistant and say “clean this and structure it as a monthly P&L” removes a genuinely tedious chore.

The mode selector:

Fast, Standard, Heavy This is the control that separates casual users from power users, so pay attention here. Near the prompt box you’ll see a small mode toggle currently set to Fast. Click it and you get three choices: –

Fast: Quick responses for simple tasks and edits. Use this for renaming, quick formatting, a single formula, or a small tweak. It’s snappy and cheap on your patience.
Standard: A balance of speed and reasoning. Your everyday default for most building and analysis tasks.
Heavy: More reasoning for complex analysis. Reach for this when you’re asking it to think hard: building a multi-driver model, reconciling discrepancies across tabs, or reasoning through a layered scenario. The instinct is to leave it on Fast because it feels efficient. Resist that. Matching the mode to the task is how you get good output. Asking Fast to architect a driver-based forecast is like asking an intern to do it in five minutes you’ll get something, but not what you wanted. Switch to Heavy for the genuinely analytical jobs and let it work.

The settings menu

Open the menu at the top of the panel and you’ll find account details,

Previous chats (so you can return to earlier work),
Apps and Skills,
An Appearance setting,
Help link, and Log out.

One toggle here deserves a callout: Apply edits automatically. When it’s on, the assistant writes its changes straight into your sheet. When it’s off, you review proposed changes before they land.

Want to See It in Action, Live?

Reading about it only gets you so fa. The real “aha” moment comes from watching ChatGPT build a forecast, audit a model, and write commentary inside a live Excel file in real time.

That’s exactly what we do in my free sessions at the Maven . I walk through the setup, demo the interface on real finance workbooks, and share the prompts and workflows that actually move the needle for FP&A teams not generic AI tips, but the specific use cases that save you time on month-end, forecasting, and variance work.

Join my next free session and learn to put AI to work inside your spreadsheets [register here]. Bring your questions, bring a messy workbook, and let’s make your Excel smarter together.