How to Use ChatGPT for Excel

Excel is powerful, but formulas can be a nightmare. ChatGPT is the ultimate Excel assistant.

1. Generating Formulas

Describe what you want in plain English.

• Prompt: "I have a list of full names in Column A. Write an Excel formula to extract the First Name into Column B and Last Name into Column C."
• Result: =LEFT(A1, FIND(" ", A1) - 1)

2. Explaining Complex Formulas

Found a spreadsheet with a crazy formula?

• Prompt: "Explain this Excel formula to me like I'm 5: =INDEX(C3:E10, MATCH(B13,C3:C10,0), MATCH(B14,C3:E3,0))"

3. Writing Macros (VBA)

Automate repetitive tasks without knowing how to code.

• Prompt: "Write a VBA macro for Excel that highlights all duplicate rows in red and moves them to a new sheet called 'Duplicates'."

4. Data Analysis

If you have ChatGPT Plus, you can upload the Excel file directly.

• Prompt: "Analyze this sales data. What are the top 3 trends? Create a chart showing revenue growth by month."