Excel + ChatGPT = Productivity
Use these prompts to generate complex Excel formulas and automate your work.
Formula Generation
Create an Excel formula that [describe what you need]. My data is in columns [A, B, C] from rows [2 to 100].
VLOOKUP/XLOOKUP
Write an XLOOKUP formula to find [value] in [range] and return the corresponding value from [column].
Conditional Formatting
Create a conditional formatting rule that highlights cells in column [X] that are [condition].
Pivot Table
Explain how to create a pivot table that shows [metric] by [dimension] from my data in [range].
VBA Macros
Write a VBA macro that [describe the automation]. Include comments explaining each step.
Data Cleaning
Create formulas to clean my data: remove duplicates, trim spaces, and standardize [format].