232 prompts matching "excel-tables"
Act as a Power Query (M language) developer. I will describe a messy raw export ...
Act as an FP&A lead. Walk me through building a 13-week cash flow forecast for a...
I need an Excel formula to detect duplicate records based on a combination of mu...
I have customer signup and activity data in Excel. Help me build a monthly cohor...
Write a VBA macro that automatically formats any new data pasted into an Excel s...
I have a folder containing monthly CSV files (January.csv, February.csv, etc.) w...
Act as a senior Excel troubleshooting expert. I have a workbook where lookup fo...
Create a budget tracker Excel structure with: income categories, expense categor...
Write a Python data analysis script using Pandas for exploratory data analysis (...
Write a VBA macro for Excel that automates the following repetitive reporting ta...
You are a financial modeling expert using Excel. I need to build a what-if analy...
I have raw data in Excel that needs cleaning and transformation. Help me build a...
I want to build a professional Gantt chart in Excel for project management witho...
Create a complete system of Excel conditional formatting rules to build a profes...
Help me design an effective Power BI dashboard. My situation: Data source: [EXC...
Act as a Microsoft 365 Excel trainer. Teach me the dynamic-array trio FILTER, SO...
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 ...
You are an Excel expert. I need to use XLOOKUP for complex data retrieval tasks....
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...
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...