219 prompts matching "excel-tables"
I have 36 months of revenue data (column A: month-end dates, column B: revenue)....
Create an Excel invoice generator with automatic invoice numbering using VBA. B...
Create a data quality monitoring report for my dataset: - Data source: [e.g., '...
Write a VBA macro for Excel that automates my monthly reporting process. The mac...
Design an Excel KPI scorecard dashboard for [department] with: 1) KPI table with...
You are an Excel expert. I need to use XLOOKUP for complex data retrieval tasks....
Act as an Excel VBA expert. I need to automate a repetitive report generation ta...
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...
I have the following data and need to visualize it effectively: Data type: [desc...
Design a library of reusable custom Excel functions using the LAMBDA function fo...
Act as a Microsoft 365 Excel trainer. Teach me the dynamic-array trio FILTER, SO...
Act as an Excel power user. I need an XLOOKUP-based formula that returns [RETURN...
Build a reporting dashboard using Excel 365 dynamic array formulas (FILTER, SORT...
Build a 36-month, monthly three-statement financial model (P&L, cash flow, balan...
Act as a financial analyst. I have 36 months of revenue history. Show me how to ...
I need an Excel formula to detect duplicate records based on a combination of mu...
Build me a complete Excel budget vs actual variance report. I have monthly budge...
I have customer signup and activity data in Excel. Help me build a monthly cohor...
Help me design a reusable Excel template for [USE CASE: e.g. expense report, pro...
Act as an expert Excel analyst for accounts receivable. Help me build a cash col...
Write an Excel VBA macro that automates the formatting of a weekly report I rece...
Act as a personal finance planner. Build me a structured net worth statement tem...
You are an Excel formula expert. I need to build a SUMIFS formula that totals va...