AI Prompt EngineeringModuleLesson 01
Excel/Sheets Formula Generation
15m
Beginner
+50 XP
0% Done
You never have to memorize a complex VLOOKUP, INDEX MATCH, or nested IF statement again. AI is a master of spreadsheet formulas and VBA macros.
"I have a Google Sheet. Column A is Employee Name, Column B is Sales Target, Column C is Actual Sales. Write a formula I can paste into Column D that outputs 'BONUS' if Actual Sales is 20% higher than the Target, and 'STANDARD' otherwise."
"Explain what this formula does in plain English: =IFERROR(VLOOKUP(A2, 'Data'!A:E, 4, FALSE), \"Not Found\")"