📊 Excel & Spreadsheets Prompts
Formulas, reports, pivot tables, charts, VBA macros
← All Categories
17 prompts
Employee Performance Dashboard Pivot
Create a pivot table setup for employee performance analysis. Data columns: Employee Name, Department, Quarter, KPI Score, Projects Completed, Client Satisfaction Rating. Show how to: 1) Average KPI score by department, 2) Count projects completed per employee per quarter, 3) Show top 10 performers using value filters, 4) Add slicers for Department and Quarter for interactive filtering, 5) Create a dashboard layout with multiple pivot charts.
💡 Use slicers to make the dashboard interactive — much better than dropdown filters.
Professional Dashboard with Charts
Create instructions for building a professional Excel dashboard with these charts: 1) Revenue trend line chart (monthly, 12 months), 2) Sales by region donut chart, 3) Top 5 products horizontal bar chart, 4) KPI scorecard with conditional formatting (green/yellow/red), 5) Sparklines in cells for quick trend visualization. Include specific formatting tips: remove gridlines, use a consistent color palette, align charts to a grid layout.
💡 Use named ranges for chart data so they auto-update when new data is added.
Clean Messy Data Checklist
Give me a complete Excel data cleaning checklist with formulas for each step: 1) Remove duplicates (explain Remove Duplicates tool + COUNTIF method), 2) Fix inconsistent text (TRIM, PROPER, UPPER, LOWER), 3) Handle blank cells (IF+ISBLANK, Go To Special), 4) Fix date formats (DATEVALUE, TEXT), 5) Separate combined columns (Text to Columns, TEXTSPLIT), 6) Remove special characters (SUBSTITUTE + CLEAN), 7) Validate data ranges (Data Validation rules), 8) Standardize categories (VLOOKUP mapping table).
💡 Always work on a copy of your data, never the original.
Auto-Send Email Report VBA
Write an Excel VBA macro that: 1) Takes data from the active sheet, 2) Creates a formatted HTML email in Outlook, 3) Attaches the current workbook as a PDF, 4) Sends it to a specified email address. Include error handling, a progress message box, and comments explaining each section. The email should have a professional template with the report date in the subject line.
💡 Test with a DisplayEmail line first instead of Send to preview before auto-sending.
Auto-Format New Data VBA
Write a VBA macro that automatically formats any new data pasted into an Excel sheet: 1) Auto-fit column widths, 2) Add borders to all cells with data, 3) Bold the header row, 4) Apply alternating row colors (light gray/white), 5) Freeze the top row, 6) Auto-apply number format to columns containing numbers, 7) Add filters to the header row. The macro should detect the data range automatically.
💡 Assign this macro to a button on the sheet for one-click formatting.