219 prompts matching "excel-tables"
I need to set up audit trails and change tracking in Excel for a shared workbook...
Help me design an effective Power BI dashboard. My situation: Data source: [EXC...
Act as an Excel formula expert. Help me replace nested INDEX-MATCH and VLOOKUP f...
Act as an FP&A lead. Walk me through building a 13-week cash flow forecast for a...
You are an Excel auditing specialist. Walk me through a systematic audit of a wo...
Teach me how to create advanced data validation and dependent dropdown lists in ...
I have a folder containing monthly CSV files (January.csv, February.csv, etc.) w...
Help me build an Excel scenario model that compares best case, base case, and wo...
I need to retrieve data from a lookup table in Excel. My main table has [column ...
Help me build an Excel Power Query transformation pipeline. My raw data source i...
Create a complete Excel budget vs. actual variance analysis template for [depart...
Write a Python data analysis script using Pandas for exploratory data analysis (...
Help me design a Power BI executive sales dashboard. Data sources: [CRM data / S...
Act as an Excel dashboard designer. I want to build an interactive dashboard wit...
I have raw data in Excel that needs cleaning and transformation. Help me build a...
Help me calculate and model the break-even analysis for [product/business type]....
Help me master Excel dynamic array functions to replace my manual filtering and ...
I want to build a professional Gantt chart in Excel for project management witho...
Help me choose the right Excel chart type and tell a compelling data story. I ha...
You are an Excel formula expert. Help me write an INDEX/MATCH formula that retur...
Write a VBA macro that splits the Master sheet by [Manager Name], saves each man...
I need to generate {{number, e.g., 500}} rows of realistic test data in Excel fo...
Write a VBA macro that, when run, formats the active sheet as a monthly report: ...
I have monthly sales data in Excel for the last 3 years. Help me build a 12-mont...