232 prompts matching "excel-tables"
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., '...
Design an Excel KPI scorecard dashboard for [department] with: 1) KPI table with...
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...
You are an Excel formula expert. I need to build a SUMIFS formula that totals va...
Build a reporting dashboard using Excel 365 dynamic array formulas (FILTER, SORT...
I need to generate {{number, e.g., 500}} rows of realistic test data in Excel fo...
Act as a financial analyst. Create a step-by-step Excel guide to build a loan am...
I have a worksheet with nested IF formulas like: =IF(A1="Bronze",0.05,IF(A1="Sil...
Create an Excel invoice generator with automatic invoice numbering using VBA. B...
Help me design a Power BI executive sales dashboard. Data sources: [CRM data / S...
Act as an Excel formula expert. I want to master SUMIF, SUMIFS, COUNTIF, and COU...
I need to look up values in Excel using multiple conditions. My dataset has colu...
Help me calculate and model the break-even analysis for [product/business type]....
I need an Excel commission calculator that supports tiered rates (e.g. 5% on the...