Create formulas, dashboards, VBA ideas, data cleanup steps, and workbook checks.
Related books, audiobooks, and useful resources. Some links may be affiliate links.
Best for: Formulas
Act as an Excel expert. Create a formula for this problem: [describe problem]. Explain each part and give alternatives for older Excel versions if relevant.Replace the bracketed placeholders with your real details before using it.
Best for: Formula fixing
Debug this Excel formula. Explain why it fails and provide a corrected version. Formula: [paste formula]. Expected result: [describe]Replace the bracketed placeholders with your real details before using it.
Best for: Dashboards
Design an Excel dashboard for [business/process]. Include KPI cards, charts, slicers, tables, colors, and layout notes.Replace the bracketed placeholders with your real details before using it.
Best for: Power Query
Create a Power Query transformation plan for this messy data. Include steps, column types, cleanup rules, and final table shape. Data: [describe]Replace the bracketed placeholders with your real details before using it.
Best for: Data quality
Suggest data validation rules for this spreadsheet. Include dropdowns, date rules, number limits, error messages, and protection ideas. Use case: [describe]Replace the bracketed placeholders with your real details before using it.
Best for: Pivot tables
Create a pivot table analysis plan for [dataset]. Include rows, columns, values, filters, calculated fields, and charts.Replace the bracketed placeholders with your real details before using it.
Best for: VBA planning
Write a VBA macro specification for [task]. Include inputs, steps, error handling, buttons, and comments. Do not write code until requirements are clear.Replace the bracketed placeholders with your real details before using it.
Best for: Spreadsheet review
Audit this spreadsheet design. Identify risks in formulas, inputs, formatting, controls, documentation, and version management. Context: [describe]Replace the bracketed placeholders with your real details before using it.
Best for: Lookups
Choose the best lookup approach for this case: [case]. Compare XLOOKUP, INDEX/MATCH, FILTER, and Power Query.Replace the bracketed placeholders with your real details before using it.
Best for: Reporting automation
Create a plan to automate a monthly Excel report. Include source files, transformations, formulas, checks, refresh steps, and export process.Replace the bracketed placeholders with your real details before using it.
Best for: Formatting
Suggest conditional formatting rules for [spreadsheet]. Include purpose, rule logic, colors conceptually, and warnings to avoid clutter.Replace the bracketed placeholders with your real details before using it.
Best for: Templates
Design a spreadsheet template for [budget type]. Include sheets, columns, formulas, summaries, charts, and instructions.Replace the bracketed placeholders with your real details before using it.
Best for: Power BI
Create a migration plan from an Excel report to Power BI. Include model, measures, visuals, refresh, permissions, and rollout.Replace the bracketed placeholders with your real details before using it.
Best for: Forms
Design a simple spreadsheet data entry form for [process]. Include fields, validation, instructions, protection, and review workflow.Replace the bracketed placeholders with your real details before using it.
Best for: Learning
Explain this Excel formula as if I am new to Excel. Then give a shorter version and a more robust version. Formula: [paste formula]Replace the bracketed placeholders with your real details before using it.