Prompt Library

The fastest way to work in Excelmatic is to start with a template. Below are high-impact commands for various roles.

Tip: Before using these, make sure you've read the Writing Guide to understand how to format your column names (always use 'Single Quotes').

💰 Finance & Accounting

• Expense Audit: "Find rows where 'Amount' > 500 AND 'Category' = 'Uncategorized'; highlight these rows and add a column 'Audit Flag' = 1."
• YoY Comparison: "Calculate the Year-over-Year growth for 'Net Revenue' by 'Month'; output a summary table and a line chart."

📈 Sales & Operations

• Lead Scoring: "Add column 'Lead Score' = ('Interaction Count' * 0.4) + ('Budget' * 0.6); sort by 'Lead Score' descending."
• Inventory Check: "Identify items where 'Stock Level' < 'Reorder Point'; create a list of 'Supplier' and 'Item Name' to order."

🧹 Professional Data Cleaning

• The "Standard Clean": "Remove duplicates on 'ID'; trim whitespace in all text columns; standardize 'Date' to YYYY-MM-DD."
• Null Management: "In column 'Region', replace all empty cells with 'Unknown'; fill missing 'Unit Price' with the median."

⚡ Multi-Step Chains (Power Moves)

Combine operations to build full workflows in one go:

The Executive KPI Pack:

Merge all uploaded monthly files; add column 'Margin %' = (Revenue-Cost)/Revenue; calculate average 'Margin %' by 'Department'; create a bar chart and place it in a new sheet 'Dashboard'.
Copy

Next Step: Master command writing from scratch with theWriting Guide.