For Financial Analyst (Corporate)s ·
What you'll accomplish
By the end of this guide, you'll be using ChatGPT Plus as your personal Excel expert — describing what you need in plain English and getting working formulas, VBA macros, and model logic in seconds. You'll stop spending 20–45 minutes on Stack Overflow for formula help and eliminate the frustrating "why is my VLOOKUP returning N/A?" debugging spirals.
What you'll need
No special setup needed for formula help — you can start immediately.
The key to getting a working formula on the first try is describing your data layout specifically.
Use this formula for your request:
I need an Excel formula that [what you want to calculate].
Data layout:
- Column A: [name and content]
- Column B: [name and content]
- Column C: [name and content]
[Add as many columns as relevant]
Conditions: [Any filters — e.g., "only where column A = '1000'" or "for dates in Q1 2025"]
Return value: [What the formula should produce]
Handle errors: [e.g., "return 0 if no match found" or "return blank if the denominator is zero"]
What you should see: A working formula with a step-by-step explanation of each argument.
If it returns an error:
What you should see: The formula returns the expected value in your test cells.
When you inherit a complex model with formulas you don't fully understand, use ChatGPT to decode them.
This is invaluable for understanding models built by someone who no longer works at the company.
For repetitive Excel tasks that happen every month (copying data from one sheet to another, reformatting a table, running the same filters), a VBA macro can automate it. You don't need to know VBA — just describe what you want.
Write a VBA macro for Excel that [describes the task step by step].
My workbook has sheets named: [list sheet names].
Specific steps: [describe what the macro should do in plain English — e.g., "1. Copy the range A2:F500 from the sheet named 'GL Export'. 2. Paste it as values only to cell A2 on the sheet named 'Variance Analysis'. 3. Sort by column D (Variance) descending."]
What you should see: The macro runs and performs the task exactly as described.
SUMIFS with multiple conditions:
Write a SUMIFS formula that sums column [X] where column [A] equals "[value]" and column [B] starts with "[prefix]". My data is in Sheet1, rows 2 through 5000. Headers in row 1.
XLOOKUP with fallback:
Write an XLOOKUP formula that looks up the value in A2 against column A in a table called "BudgetTable" on Sheet "Budget" and returns the value from column C. If no match is found, return 0.
Convert VLOOKUP to XLOOKUP:
Convert this VLOOKUP formula to XLOOKUP and explain what changed: [paste formula]
Debug a broken formula:
This formula is returning [error message]. Explain what's wrong and fix it: [paste formula]. My data in A2 is [value], B2 is [value].
VBA for repetitive task:
Write a VBA macro that [describe the repeating task step by step]. My sheets are named: [list names].