232 prompts matching "excel-tables"
Act as an Excel formula expert. Help me replace nested INDEX-MATCH and VLOOKUP f...
You are an Excel auditing specialist. Walk me through a systematic audit of a wo...
I have customer signup and activity data in Excel. Help me build a monthly cohor...
I need to set up conditional formatting in Excel for a KPI dashboard. My spreads...
Help me write an Excel XLOOKUP formula that searches across multiple criteria. M...
I have the following data and need to visualize it effectively: Data type: [desc...
I have existing Excel spreadsheets that use VLOOKUP formulas and I want to moder...
I have raw data in Excel and want to create a professional dashboard. My data in...
I need to set up audit trails and change tracking in Excel for a shared workbook...
You are an Excel formula expert. Help me write an INDEX/MATCH formula that retur...
Design a one-page executive KPI dashboard in Excel for a [INDUSTRY] company. The...
I need an Excel formula to detect duplicate records based on a combination of mu...
Write a VBA macro for Excel that takes a master spreadsheet and splits it into s...
Act as a finance analyst who specializes in subscription businesses. Help me bui...
Design an Excel-based Gantt chart template for project tracking. Include: task l...
Help me build an Excel Power Query transformation pipeline. My raw data source i...
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...
Act as a Microsoft 365 Excel trainer. Teach me the dynamic-array trio FILTER, SO...
Write Power Query M code to scrape and transform data from [URL OR DESCRIBE WEBP...
Act as an FP&A lead. Walk me through building a 13-week cash flow forecast for a...
Build an Excel reorder-alert sheet for a small warehouse. Inputs (one row per SK...