257 prompts matching "excel-fix"
You are an Excel formula expert. Help me write an INDEX/MATCH formula that retur...
Create Excel formulas for: [DESCRIBE TASK]. Include: the formula, explanation of...
I need to retrieve data from a lookup table in Excel. My main table has [column ...
Act as a data quality engineer and analytics architect. Help me build a systemat...
Create a comprehensive guide for implementing Excel data validation with dropdow...
Build a complete budget variance analysis system for business financial manageme...
Help me clean and prepare a messy dataset for analysis. Dataset details: Data s...
Act as an Excel power user. I need an XLOOKUP-based formula that returns [RETURN...
Act as a financial analyst. Help me build a pivot table from [DATA RANGE] (colum...
Write a VBA macro that splits the Master sheet by [Manager Name], saves each man...
Build a 36-month, monthly three-statement financial model (P&L, cash flow, balan...
Build me a complete Excel budget vs actual variance report. I have monthly budge...
Write a VBA macro that, when run, formats the active sheet as a monthly report: ...
I have 36 months of revenue data (column A: month-end dates, column B: revenue)....
Help me design a reusable Excel template for [USE CASE: e.g. expense report, pro...
I just inherited this workbook from someone who left: [DESCRIBE TABS, KEY OUTPUT...
Teach me how to create advanced data validation and dependent dropdown lists in ...
Create a comprehensive Excel expense report template with these features: 1. In...
Create a data quality monitoring report for my dataset: - Data source: [e.g., '...
I have a sales dataset with columns: [Date, Region, Sales Rep, Product, Units So...
Design an Excel KPI scorecard dashboard for [department] with: 1) KPI table with...
You are an Excel reporting expert. I need to build a professional pivot table re...
Act as an Excel VBA expert. I need to automate a repetitive report generation ta...
Design a library of reusable custom Excel functions using the LAMBDA function fo...