134 prompts matching "formula"
You are an Excel formula expert. Help me write an INDEX/MATCH formula that retur...
Help me write a data definition doc for [METRIC NAME] that ends ambiguity foreve...
Teach me how to create advanced data validation and dependent dropdown lists in ...
You are a Power Query specialist. I have raw data that needs cleaning and transf...
You are a podcast marketing strategist and content growth expert. I need to deve...
Design a vendor selection scorecard for evaluating [type of vendor, e.g., cloud ...
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...
Build a reporting dashboard using Excel 365 dynamic array formulas (FILTER, SORT...
Help me design a hypothesis test for a product experiment. Context: - Hypothesi...
Help me build a conditional formatting rule for an invoices sheet so each row hi...
I need to generate {{number, e.g., 500}} rows of realistic test data in Excel fo...
I need an Excel formula to detect duplicate records based on a combination of mu...
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...
Act as an Excel formula expert. I want to master SUMIF, SUMIFS, COUNTIF, and COU...
Design a library of reusable custom Excel functions using the LAMBDA function fo...
I need an Excel commission calculator that supports tiered rates (e.g. 5% on the...
Build an Excel reorder-alert sheet for a small warehouse. Inputs (one row per SK...
I have customer signup and activity data in Excel. Help me build a monthly cohor...
You are an Excel formula expert. I need to build a SUMIFS formula that totals va...
Act as a statistics tutor for product analysts. Walk me through a complete power...
Analyze this investment opportunity using NPV and IRR: - Initial investment: [AM...