173 prompts matching "excel formulas"
Create Excel LAMBDA functions for: 1) CAGR given start value, end value, and yea...
Help me master Excel dynamic array functions to replace my manual filtering and ...
I have raw data in Excel and want to create a professional dashboard. My data in...
Act as an FP&A lead. Walk me through building a 13-week cash flow forecast for a...
Write an Excel VBA macro that: 1) Takes data from the active sheet, 2) Creates a...
Create an Excel invoice generator with automatic invoice numbering using VBA. B...
Teach me how to create advanced data validation and dependent dropdown lists in ...
I need to set up conditional formatting in Excel for a KPI dashboard. My spreads...
Create a data quality monitoring report for my dataset: - Data source: [e.g., '...
You are an Excel operations consultant. Build a practical team capacity planner ...
I need a monthly cash flow forecast in Excel for a business with uneven customer...
I have raw transaction data in Excel with columns for customer_id, first_purchas...
Act as an expert tutor and exam preparation specialist. Create a comprehensive ...
Act as an Excel VBA developer who writes clean, maintainable macros. Create VBA...
I have a sales dataset with columns: [Date, Region, Sales Rep, Product, Units So...
I need to retrieve data from a lookup table in Excel. My main table has [column ...
Build a 3-year financial model for a [business type — SaaS / e-commerce / market...
Guide me through creating a comprehensive sales analysis using Excel Pivot Table...
Help me build an Excel Power Query transformation pipeline. My raw data source i...
Teach me how to use Excel dynamic array functions (FILTER, SORT, UNIQUE, SEQUENC...
Build a three-statement financial model in Excel for [company type, e.g., a SaaS...
You are a financial modeling expert using Excel. I need to build a what-if analy...
You are a BI analyst and data visualization expert. I need to build a profession...
Act as an Excel dashboard designer. I want to build an interactive dashboard wit...