Prompt Guide: Effective Excel Prompts

Data Cleaning:

“Clean up my dataset by removing duplicates and highlight any inconsistent formatting.”

Formula Creation:

“Create a VLOOKUP formula in column D that looks up the product ID in column A and returns the corresponding price from the ‘Prices’ table.”

Data Visualization:

“Generate a bar chart showing quarterly sales trends for last year.”

Analysis and Insights:

“Analyze my sales data and provide insights into the top-selling products and potential areas for improvement.”

Conditional Formatting:

“Set up conditional formatting to bold the top 10 values in the ‘Annual Sales’ column.”

Tips for Best Results

Break Down Complex Tasks:

For complex operations, break the task into smaller, more manageable steps.

Be Explicit:

Don’t be afraid to be overly explicit, especially when it comes to formulas, as AI models might not automatically understand relative and absolute cell referencing.

Use Few-Shot Prompting:

Provide an example of how you’d like the output to be formatted.

Iterate and Refine:

If the first response isn’t quite right, ask clarifying questions and provide more specific instructions to refine the output.

If you would like to receive the AI integration checklist or require additional information, contact andrew@insightaiafrica.co or visit www.insightaiafrica.co.