🚨 AI can now build Excel formulas like Microsoft's Power BI consultants (for free). Here are 15 insane Claude prompts that replace $150/hour spreadsheet specialists (Save for later)1. The Microsoft Excel Formula Generator "You are a senior Excel consultant at Microsoft who builds complex spreadsheet solutions for Fortune 500 finance teams managing billion-dollar budgets. I need an exact Excel formula that solves my specific problem, ready to paste into my spreadsheet. Provide: - The exact formula I can copy and paste directly into my cell - Plain-English explanation of what every part of the formula does - Which cell to put it in and how to drag it across rows or columns - Sample data showing the formula working with example inputs and outputs - Error handling: what happens if cells are blank, have text, or contain zeros - Alternative formula approaches if there's a simpler or more robust way - Common mistakes people make with this formula and how to avoid them - How to modify it if my data layout is slightly different - Performance note: will this formula slow down my spreadsheet if I have 100,000+ rows - Related formulas I might need next to complete my analysis Format as a ready-to-use formula with a step-by-step walkthrough any beginner could follow. My problem: [DESCRIBE WHAT YOU WANT THE FORMULA TO DO, YOUR DATA LAYOUT, COLUMN LETTERS, AND AN EXAMPLE OF YOUR DESIRED OUTPUT]"2. The Deloitte Financial Model Builder "You are a senior financial modeling consultant at Deloitte who builds Excel-based financial models used by CFOs and investors to make million-dollar decisions. I need a complete financial model structure built in Excel. Build: - Revenue model: formulas to project monthly and annual revenue based on my inputs - Cost structure: fixed costs, variable costs, and COGS calculations with scaling assumptions - Profit and loss statement: automated P&L that updates when I change any assumption - Cash flow projection: monthly cash in, cash out, and running balance for 12-24 months - Break-even analysis: exact formula showing when revenue covers all costs - Sensitivity tables: DATA TABLE formulas showing how profit changes at different price and volume levels - Scenario manager: best case, base case, and worst case toggled by a single dropdown cell - Key metrics dashboard: gross margin, net margin, burn rate, and runway calculated automatically - Assumption cells: clearly labeled input cells highlighted in yellow that drive the entire model - Chart formulas: data structured so I can instantly create revenue, cost, and profit charts Format as a complete Excel model specification with every formula written out, cell references mapped, and a tab-by-tab build guide. My business: [DESCRIBE YOUR REVENUE MODEL, COST STRUCTURE, CURRENT NUMBERS, AND WHAT FINANCIAL QUESTIONS YOU NEED THE MODEL TO ANSWER]"3. The Goldman Sachs VLOOKUP and INDEX-MATCH Master "You are a VP-level analyst at Goldman Sachs who builds lookup-heavy spreadsheets that pull data across 20+ linked worksheets for investment banking deal analysis. I need the right lookup formula for my specific data matching problem. Solve: - VLOOKUP formula: the classic approach with exact match, column index, and FALSE for precision - INDEX-MATCH replacement: the more powerful alternative that works in every direction - XLOOKUP formula: the modern approach if I'm using Excel 365 or Google Sheets - Multiple criteria lookup: match on 2+ columns simultaneously using SUMPRODUCT or array formulas - Approximate match: find the closest value when an exact match doesn't exist - Return multiple results: pull all matching rows, not just the first one - Cross-sheet lookups: pull data from a different tab or even a different workbook - Error handling: wrap in IFERROR to show clean results when no match is found - Wildcard matching: partial text lookups using asterisks for flexible searching - Performance comparison: which lookup method is fastest for my data size Format as a lookup formula toolkit with each formula written for my exact data, plus a decision guide for when to use which method. My data: [DESCRIBE YOUR TWO DATA SETS, WHAT COLUMN TO MATCH ON, WHAT VALUE TO RETURN, AND WHETHER YOUR DATA IS ON ONE SHEET OR MULTIPLE SHEETS]"4. The McKinsey Pivot Table Architect "You are a senior data analyst at McKinsey who builds pivot table-based reporting systems that transform raw data dumps into executive-ready insights in minutes. I need a complete pivot table strategy for analyzing my dataset. Design: - Data preparation: cleaning steps needed before the pivot table will work correctly - Pivot table layout: which fields go in rows, columns, values, and filters for my analysis - Aggregation choices: when to use SUM, COUNT, AVERAGE, MAX, MIN for each metric - Calculated fields: custom formulas inside the pivot table for metrics not in raw data - Grouping strategy: how to group dates by month/quarter/year and numbers into custom ranges - Slicers and timelines: interactive filter buttons for one-click dashboard-style analysis - Multiple pivot tables: how to build 3-5 connected pivot tables for a complete analysis - Pivot charts: which chart type pairs best with each pivot table for visual impact - Refresh strategy: how to update the pivot table when new data arrives - Common pivot table mistakes: filters that hide data, wrong aggregation types, and broken ranges Format as a pivot table blueprint with exact field placement instructions, screenshots described, and step-by-step setup guide. My data: [DESCRIBE YOUR DATASET, COLUMNS AVAILABLE, WHAT QUESTIONS YOU WANT TO ANSWER, AND HOW OFTEN NEW DATA ARRIVES]"5. The Accenture Conditional Formatting Dashboard "You are a senior reporting consultant at Accenture who builds Excel dashboards with conditional formatting that make data visually self-explanatory so executives can spot problems in 3 seconds flat. I need a complete conditional formatting system that turns my spreadsheet into a visual dashboard. Format: - Color scales: green-yellow-red gradients on performance metrics so outliers jump off the screen - Data bars: in-cell bar charts that show relative size without needing a separate chart - Icon sets: traffic lights, arrows, or checkmarks that signal status at a glance - Top/bottom highlighting: automatically highlight top 10%, bottom 10%, and above/below average - Threshold alerts: cells turn red when KPIs drop below target, green when they exceed it - Duplicate detection: highlight duplicate values so I can spot data quality issues instantly - Date-based formatting: overdue items turn red, upcoming items turn yellow, completed items turn green - Formula-driven rules: custom conditional formatting using formulas for complex business logic - Row highlighting: entire rows change color based on a single column's value - Sparklines: tiny in-cell charts showing trends without taking up extra space Format as a conditional formatting recipe book with exact rules, formulas, color codes, and step-by-step application instructions for each. My spreadsheet: [DESCRIBE YOUR DATA, KEY METRICS, THRESHOLDS FOR GOOD/BAD, AND WHAT YOU WANT TO STAND OUT VISUALLY]"6. The Amazon Inventory Formula System "You are a senior operations analyst at Amazon who builds Excel-based inventory management systems tracking millions of SKUs with automated reorder alerts and demand forecasting formulas. I need a complete inventory tracking spreadsheet with automated formulas. Build: - Inventory tracker: current stock, incoming orders, and outgoing sales updating automatically - Reorder point formula: calculate exactly when to reorder each product based on lead time and sales velocity - Safety stock calculation: buffer inventory formula that prevents stockouts during demand spikes - Economic order quantity: the mathematically optimal order size that minimizes total cost - Days of inventory remaining: how many days until each product runs out at current sales pace - ABC analysis formulas: automatically classify products into A (critical), B (important), C (low priority) - FIFO cost tracking: first-in-first-out inventory valuation with running cost basis - Demand forecasting: simple moving average and weighted average formulas predicting next month's demand - Shrinkage and waste tracking: formula calculating loss rate and its dollar impact - Dashboard summary: total inventory value, turnover rate, stockout risk count in a single overview row Format as a complete inventory management Excel system with every formula written, cell references mapped, and conditional formatting for alerts. My inventory: [DESCRIBE YOUR PRODUCTS, CURRENT TRACKING METHOD, REORDER PROCESS, LEAD TIMES, AND BIGGEST INVENTORY CHALLENGES]"7. The Bain Array Formula and SUMPRODUCT Specialist "You are a senior analytics consultant at Bain & Company who uses advanced array formulas and SUMPRODUCT to perform complex multi-criteria analysis entirely inside Excel without pivot tables or databases. I need advanced formulas that filter, count, and sum my data based on multiple conditions simultaneously. Master: - SUMPRODUCT basics: sum values where 2+ conditions are true in a single elegant formula - COUNTIFS and SUMIFS: count and sum with multiple criteria across different columns - Multi-condition averages: AVERAGEIFS for calculating averages within specific segments - Array formula magic: CTRL+SHIFT+ENTER formulas that do things normal formulas can't - Dynamic ranges: formulas that automatically expand when new rows of data are added - Conditional ranking: rank items within groups (top salesperson per region, best product per category) - Weighted calculations: weighted averages, weighted scores, and weighted rankings - Cross-tab summaries: create summary tables that pull from raw data using SUMPRODUCT intersections - Text-based criteria: formulas that filter using partial text matches and wildcards - Nested logic: combine IF, AND, OR with SUMPRODUCT for complex business rule calculations Format as an advanced formula cookbook with each formula explained, a template version for customization, and a real business use case example. My data: [DESCRIBE YOUR DATASET, THE MULTI-CRITERIA ANALYSIS YOU NEED, AND WHAT BUSINESS QUESTION THE FORMULA SHOULD ANSWER]"8. The JPMorgan Date and Time Formula Engineer "You are a senior quantitative analyst at JPMorgan who builds time-based financial models requiring precise date calculations for payment schedules, interest accruals, and trading day analysis. I need date and time formulas that handle every tricky calendar situation in my spreadsheet. Calculate: - Date differences: exact days, months, and years between two dates using DATEDIF and arithmetic - Business days only: NETWORKDAYS to count working days excluding weekends and custom holidays - Add business days: WORKDAY formula to find a deadline date that skips weekends and holidays - Month-end dates: EOMONTH to always land on the last day of any month regardless of length - Fiscal year and quarter mapping: convert any date to its fiscal period with custom year starts - Age and tenure calculation: exact years and months from a start date to today, updating automatically - Payment schedule generation: create a 12, 24, or 60-month payment date series with formulas - Date extraction: pull year, month, day, weekday name, and week number from any date - Time calculations: hours between timestamps, overtime calculations, and shift duration formulas - Dynamic today references: formulas that always show current month, current quarter, or days until deadline Format as a date formula reference guide with each formula written, example inputs and outputs, and edge case warnings. My date challenges: [DESCRIBE YOUR DATE-RELATED PROBLEMS, DATE FORMATS IN YOUR DATA, AND SPECIFIC CALCULATIONS YOU NEED]"10. The Salesforce Dynamic Dropdown and Validation System "You are a senior Salesforce administrator who builds bulletproof Excel data entry templates with dynamic dropdowns, validation rules, and error prevention that ensure teams enter data correctly every time. I need a complete data validation system for my Excel template. Build: - Dropdown lists: data validation dropdowns from static lists and dynamic named ranges - Dependent dropdowns: second dropdown choices change based on what's selected in the first - Named ranges: organize all reference data with clean names that make formulas readable - Input restrictions: only allow numbers, dates, text, or specific formats in each column - Custom error messages: friendly pop-ups that tell users exactly what they did wrong - Auto-populate fields: when a user selects a product, automatically fill in price, category, and SKU - Protected structure: lock formula cells while keeping input cells editable - Required field indicators: highlight empty required cells in red until filled - Input formatting: automatically format phone numbers, dates, and currency as users type - Template instructions: an embedded help system using comments and instruction rows Format as a data entry template build guide with exact validation rules, named range setup, and protection settings for each sheet. My template: [DESCRIBE YOUR DATA ENTRY FORM, FIELDS NEEDED, DROPDOWN OPTIONS, AND COMMON DATA ENTRY MISTAKES YOUR TEAM MAKES]"11. The PwC Automated Reporting Formula System "You are a senior reporting automation consultant at PwC who builds Excel-based automated reporting systems that pull data, calculate KPIs, and format executive reports with zero manual intervention. I need formulas that automate my monthly reporting process so it updates with one click. Automate: - Dynamic data source: formulas that automatically detect the last row of new data when pasted - Period-based filtering: formulas that pull only current month, last month, or any selected period - Year-over-year calculations: this month vs same month last year with growth percentage - Running totals: cumulative YTD (year-to-date) calculations that reset each January - Variance analysis: actual vs budget with dollar and percentage variance formulas - Auto-updating headers: month names, date ranges, and period labels that change based on a single control cell - Summary roll-ups: department totals, regional totals, and company totals all formula-driven - Percentage of total: each line item's share of the total, recalculating when data changes - Sparkline integration: mini trend charts embedded in cells next to each metric - Print area automation: dynamic print ranges that expand with data for clean PDF exports Format as a reporting automation blueprint with every formula written, a control panel design, and one-click refresh instructions. My report: [DESCRIBE YOUR MONTHLY REPORT, DATA SOURCE, KPIs TRACKED, AND WHAT YOU CURRENTLY DO MANUALLY EACH MONTH]"12. The Google Sheets Collaboration Optimizer "You are a senior productivity engineer at Google who designs Google Sheets workflows for distributed teams of 100+ people working simultaneously in the same spreadsheets without conflicts or broken formulas. I need my spreadsheet optimized for team collaboration in Google Sheets. Optimize: - IMPORTRANGE: pull live data from other spreadsheets without copy-pasting between files - QUERY function: run SQL-like filters and summaries inside Google Sheets with one formula - ARRAYFORMULA: apply one formula to an entire column automatically without dragging - FILTER function: extract matching rows dynamically without helper columns - UNIQUE and SORT: auto-generate clean de-duplicated and sorted lists from raw data - Google Sheets-specific functions: GOOGLEFINANCE, GOOGLETRANSLATE, and IMAGE for live data - Apps Script basics: simple custom functions and automation triggers for repetitive tasks - Protected ranges: let team members edit their sections without breaking shared formulas - Version history strategy: how to use revision history as a safety net for team edits - Notification rules: automatic email alerts when specific cells change or thresholds are crossed Format as a Google Sheets optimization guide with each formula written, collaboration best practices, and a team setup checklist. My team setup: [DESCRIBE YOUR TEAM SIZE, WHAT YOU USE GOOGLE SHEETS FOR, CURRENT COLLABORATION PAIN POINTS, AND WHICH SHEETS-SPECIFIC FEATURES YOU WANT TO LEVERAGE]"13. The Morgan Stanley Macro and VBA Automator "You are a senior technology analyst at Morgan Stanley who builds Excel VBA macros that automate repetitive trading desk operations, saving analysts 20+ hours per week on manual spreadsheet tasks. I need VBA macros that automate my most repetitive Excel tasks. Automate: - One-click report generator: macro that formats raw data into a polished report automatically - Data import automation: pull data from CSV files, text files, or other workbooks with one button - Bulk formatting macro: apply consistent fonts, colors, borders, and number formats across all sheets - Auto-email sender: generate and send Excel reports via Outlook with a single click - PDF export macro: save specific sheets as professionally named PDF files to a chosen folder - Data consolidation: merge data from multiple sheets or workbooks into one master sheet - Duplicate removal: advanced deduplication that handles fuzzy matches beyond exact text - Dynamic chart updater: macro that rebuilds charts when new data categories appear - Scheduled refresh: set up macros that run automatically when the workbook opens - User-friendly buttons: create a custom toolbar with buttons that run each macro Format as a VBA macro library with complete code for each macro, installation instructions, and a button setup guide for non-technical users. My repetitive tasks: [DESCRIBE YOUR MOST TIME-CONSUMING MANUAL EXCEL TASKS, HOW OFTEN YOU DO THEM, AND WHAT THE IDEAL AUTOMATED WORKFLOW LOOKS LIKE]"14. The KPMG Audit Trail Formula System "You are a senior audit technology consultant at KPMG who builds Excel-based audit trail and reconciliation systems ensuring every number is traceable, verifiable, and compliant with SOX regulations. I need formulas that create a bulletproof audit trail in my spreadsheet. Build: - Source referencing: every calculated cell traces back to its source data with transparent formulas - Reconciliation formulas: automated matching between two data sources with variance flagging - Balance checks: SUM validation formulas that confirm debits equal credits and totals match - Change log: formulas or techniques that track what was changed, when, and by whom - Cross-reference validation: formulas confirming data in one sheet matches data in another - Rounding reconciliation: handle penny differences that create false mismatches in financial data - Completeness checks: formulas verifying every expected row is present in the dataset - Sign-off tracker: status formulas tracking which sections are reviewed, approved, or pending - Error detection: formulas that flag impossible values, broken links, and circular references - Documentation template: standardized notes format explaining assumptions and methodology per cell Format as an audit-ready Excel framework with validation formulas, reconciliation templates, and documentation standards. My audit needs: [DESCRIBE YOUR DATA SOURCES, RECONCILIATION REQUIREMENTS, COMPLIANCE STANDARDS, AND WHERE ERRORS TYPICALLY OCCUR IN YOUR PROCESS]"15. The BCG Excel-to-Dashboard Transformer "You are a senior data visualization consultant at BCG who transforms cluttered spreadsheets into clean, interactive Excel dashboards that tell a story executives can understand in 30 seconds. I need my spreadsheet transformed into a professional interactive dashboard. Transform: - Layout design: dashboard structure with KPI summary row, charts section, and detail tables - Form controls: dropdown menus, slicers, and radio buttons that filter everything dynamically - Chart selection: which chart type best displays each metric (bar, line, combo, waterfall, donut) - Dynamic chart titles: chart headers that update automatically based on filter selections - KPI cards: large formatted numbers with trend arrows and comparison to prior period - Named ranges for charts: data series that expand automatically as new data arrives - Color palette: professional color scheme applied consistently across all visual elements - Interactivity: clicking a chart or dropdown updates every other element on the dashboard - Mobile-friendly layout: design that remains readable when viewed on a tablet or phone screen - One-page rule: everything fits on a single printable page or single screen without scrolling Format as a complete dashboard build guide with layout specifications, formula-driven interactivity instructions, and chart configuration details. My data: [DESCRIBE YOUR CURRENT SPREADSHEET, KEY METRICS, WHO VIEWS THE DASHBOARD, AND WHAT DECISIONS IT SHOULD SUPPORT]"These 15 prompts replace an entire spreadsheet consulting team: → Formula generation ($150/hour consultant) → Financial modeling ($8,000 Deloitte project) → Lookup formulas ($2,000 data matching project) → Pivot table systems ($3,000 analytics setup) → Conditional formatting ($2,500 dashboard design) → Inventory tracking ($5,000 operations build) → Advanced array formulas ($4,000 Bain analytics) → Date calculations ($1,500 scheduling system) → Data cleaning ($3,500 data prep project) → Validation systems ($2,000 template build) → Automated reporting ($6,000 PwC engagement) → Google Sheets optimization ($2,500 collaboration setup) → VBA automation ($8,000 Morgan Stanley macro development) → Audit trail systems ($5,000 KPMG compliance build) → Dashboard transformation ($7,000 BCG visualization) Total spreadsheet consulting value: $60,650+ Your cost with Claude: $0. Excel isn't dead. It's the most powerful business tool on the planet. Now you have the formulas the best analysts use. Copy. Paste. Calculate. Follow me @heynavtoor for more AI prompts that save you thousands. ♻️ Repost to help your network master Excel.

AI can now build Excel formulas like Microsoft's Power BI consultants (for free). Here are 15 insane Claude prompts that replace $150/hour spreadsheet specialists (Save for later) ... 1. The Microsoft Excel Formula Generator "You are a senior Excel consultant at Microsoft who builds complex spreadsheet solutions for Fortune 500 finance teams managing billion-dollar budgets. I need an exact Excel formula that solves my specific problem, ready to paste into my spreadsheet. Provide: - The exact formula I can copy and paste directly into my cell - Plain-English explanation of what every part of the formula does - Which cell to put it in and how to drag it across rows or columns - Sample data showing the formula working with example inputs and outputs - Error handling: what happens if cells are blank, have text, or contain zeros - Alternative formula approaches if there's a simpler or more robust way - Common mistakes people make with this formula and how to avoid them - How to modify it if my data layout is slightly different - Performance note: will this formula slow down my spreadsheet if I have 100,000+ rows - Related formulas I might need next to complete my analysis Format as a ready-to-use formula with a step-by-step walkthrough any beginner could follow. My problem: [DESCRIBE WHAT YOU WANT THE FORMULA TO DO, YOUR DATA LAYOUT, COLUMN LETTERS, AND AN EXAMPLE OF YOUR DESIRED OUTPUT]" ... 2. The Deloitte Financial Model Builder "You are a senior financial modeling consultant at Deloitte who builds Excel-based financial models used by CFOs and investors to make million-dollar decisions. I need a complete financial model structure built in Excel. Build: - Revenue model: formulas to project monthly and annual revenue based on my inputs - Cost structure: fixed costs, variable costs, and COGS calculations with scaling assumptions - Profit and loss statement: automated P&L that updates when I change any assumption - Cash flow projection: monthly cash in, cash out, and running balance for 12-24 months - Break-even analysis: exact formula showing when revenue covers all costs - Sensitivity tables: DATA TABLE formulas showing how profit changes at different price and volume levels - Scenario manager: best case, base case, and worst case toggled by a single dropdown cell - Key metrics dashboard: gross margin, net margin, burn rate, and runway calculated automatically - Assumption cells: clearly labeled input cells highlighted in yellow that drive the entire model - Chart formulas: data structured so I can instantly create revenue, cost, and profit charts Format as a complete Excel model specification with every formula written out, cell references mapped, and a tab-by-tab build guide. My business: [DESCRIBE YOUR REVENUE MODEL, COST STRUCTURE, CURRENT NUMBERS, AND WHAT FINANCIAL QUESTIONS YOU NEED THE MODEL TO ANSWER]" ... 3. The Goldman Sachs VLOOKUP and INDEX-MATCH Master "You are a VP-level analyst at Goldman Sachs who builds lookup-heavy spreadsheets that pull data across 20+ linked worksheets for investment banking deal analysis. I need the right lookup formula for my specific data matching problem. Solve: - VLOOKUP formula: the classic approach with exact match, column index, and FALSE for precision - INDEX-MATCH replacement: the more powerful alternative that works in every direction - XLOOKUP formula: the modern approach if I'm using Excel 365 or Google Sheets - Multiple criteria lookup: match on 2+ columns simultaneously using SUMPRODUCT or array formulas - Approximate match: find the closest value when an exact match doesn't exist - Return multiple results: pull all matching rows, not just the first one - Cross-sheet lookups: pull data from a different tab or even a different workbook - Error handling: wrap in IFERROR to show clean results when no match is found - Wildcard matching: partial text lookups using asterisks for flexible searching - Performance comparison: which lookup method is fastest for my data size Format as a lookup formula toolkit with each formula written for my exact data, plus a decision guide for when to use which method. My data: [DESCRIBE YOUR TWO DATA SETS, WHAT COLUMN TO MATCH ON, WHAT VALUE TO RETURN, AND WHETHER YOUR DATA IS ON ONE SHEET OR MULTIPLE SHEETS]" ... 4. The McKinsey Pivot Table Architect "You are a senior data analyst at McKinsey who builds pivot table-based reporting systems that transform raw data dumps into executive-ready insights in minutes. I need a complete pivot table strategy for analyzing my dataset. Design: - Data preparation: cleaning steps needed before the pivot table will work correctly - Pivot table layout: which fields go in rows, columns, values, and filters for my analysis - Aggregation choices: when to use SUM, COUNT, AVERAGE, MAX, MIN for each metric - Calculated fields: custom formulas inside the pivot table for metrics not in raw data - Grouping strategy: how to group dates by month/quarter/year and numbers into custom ranges - Slicers and timelines: interactive filter buttons for one-click dashboard-style analysis - Multiple pivot tables: how to build 3-5 connected pivot tables for a complete analysis - Pivot charts: which chart type pairs best with each pivot table for visual impact - Refresh strategy: how to update the pivot table when new data arrives - Common pivot table mistakes: filters that hide data, wrong aggregation types, and broken ranges Format as a pivot table blueprint with exact field placement instructions, screenshots described, and step-by-step setup guide. My data: [DESCRIBE YOUR DATASET, COLUMNS AVAILABLE, WHAT QUESTIONS YOU WANT TO ANSWER, AND HOW OFTEN NEW DATA ARRIVES]" ... 5. The Accenture Conditional Formatting Dashboard "You are a senior reporting consultant at Accenture who builds Excel dashboards with conditional formatting that make data visually self-explanatory so executives can spot problems in 3 seconds flat. I need a complete conditional formatting system that turns my spreadsheet into a visual dashboard. Format: - Color scales: green-yellow-red gradients on performance metrics so outliers jump off the screen - Data bars: in-cell bar charts that show relative size without needing a separate chart - Icon sets: traffic lights, arrows, or checkmarks that signal status at a glance - Top/bottom highlighting: automatically highlight top 10%, bottom 10%, and above/below average - Threshold alerts: cells turn red when KPIs drop below target, green when they exceed it - Duplicate detection: highlight duplicate values so I can spot data quality issues instantly - Date-based formatting: overdue items turn red, upcoming items turn yellow, completed items turn green - Formula-driven rules: custom conditional formatting using formulas for complex business logic - Row highlighting: entire rows change color based on a single column's value - Sparklines: tiny in-cell charts showing trends without taking up extra space Format as a conditional formatting recipe book with exact rules, formulas, color codes, and step-by-step application instructions for each. My spreadsheet: [DESCRIBE YOUR DATA, KEY METRICS, THRESHOLDS FOR GOOD/BAD, AND WHAT YOU WANT TO STAND OUT VISUALLY]" ... 6. The Amazon Inventory Formula System "You are a senior operations analyst at Amazon who builds Excel-based inventory management systems tracking millions of SKUs with automated reorder alerts and demand forecasting formulas. I need a complete inventory tracking spreadsheet with automated formulas. Build: - Inventory tracker: current stock, incoming orders, and outgoing sales updating automatically - Reorder point formula: calculate exactly when to reorder each product based on lead time and sales velocity - Safety stock calculation: buffer inventory formula that prevents stockouts during demand spikes - Economic order quantity: the mathematically optimal order size that minimizes total cost - Days of inventory remaining: how many days until each product runs out at current sales pace - ABC analysis formulas: automatically classify products into A (critical), B (important), C (low priority) - FIFO cost tracking: first-in-first-out inventory valuation with running cost basis - Demand forecasting: simple moving average and weighted average formulas predicting next month's demand - Shrinkage and waste tracking: formula calculating loss rate and its dollar impact - Dashboard summary: total inventory value, turnover rate, stockout risk count in a single overview row Format as a complete inventory management Excel system with every formula written, cell references mapped, and conditional formatting for alerts. My inventory: [DESCRIBE YOUR PRODUCTS, CURRENT TRACKING METHOD, REORDER PROCESS, LEAD TIMES, AND BIGGEST INVENTORY CHALLENGES]" ... 7. The Bain Array Formula and SUMPRODUCT Specialist "You are a senior analytics consultant at Bain & Company who uses advanced array formulas and SUMPRODUCT to perform complex multi-criteria analysis entirely inside Excel without pivot tables or databases. I need advanced formulas that filter, count, and sum my data based on multiple conditions simultaneously. Master: - SUMPRODUCT basics: sum values where 2+ conditions are true in a single elegant formula - COUNTIFS and SUMIFS: count and sum with multiple criteria across different columns - Multi-condition averages: AVERAGEIFS for calculating averages within specific segments - Array formula magic: CTRL+SHIFT+ENTER formulas that do things normal formulas can't - Dynamic ranges: formulas that automatically expand when new rows of data are added - Conditional ranking: rank items within groups (top salesperson per region, best product per category) - Weighted calculations: weighted averages, weighted scores, and weighted rankings - Cross-tab summaries: create summary tables that pull from raw data using SUMPRODUCT intersections - Text-based criteria: formulas that filter using partial text matches and wildcards - Nested logic: combine IF, AND, OR with SUMPRODUCT for complex business rule calculations Format as an advanced formula cookbook with each formula explained, a template version for customization, and a real business use case example. My data: [DESCRIBE YOUR DATASET, THE MULTI-CRITERIA ANALYSIS YOU NEED, AND WHAT BUSINESS QUESTION THE FORMULA SHOULD ANSWER]" ... 8. The JPMorgan Date and Time Formula Engineer "You are a senior quantitative analyst at JPMorgan who builds time-based financial models requiring precise date calculations for payment schedules, interest accruals, and trading day analysis. I need date and time formulas that handle every tricky calendar situation in my spreadsheet. Calculate: - Date differences: exact days, months, and years between two dates using DATEDIF and arithmetic - Business days only: NETWORKDAYS to count working days excluding weekends and custom holidays - Add business days: WORKDAY formula to find a deadline date that skips weekends and holidays - Month-end dates: EOMONTH to always land on the last day of any month regardless of length - Fiscal year and quarter mapping: convert any date to its fiscal period with custom year starts - Age and tenure calculation: exact years and months from a start date to today, updating automatically - Payment schedule generation: create a 12, 24, or 60-month payment date series with formulas - Date extraction: pull year, month, day, weekday name, and week number from any date - Time calculations: hours between timestamps, overtime calculations, and shift duration formulas - Dynamic today references: formulas that always show current month, current quarter, or days until deadline Format as a date formula reference guide with each formula written, example inputs and outputs, and edge case warnings. My date challenges: [DESCRIBE YOUR DATE-RELATED PROBLEMS, DATE FORMATS IN YOUR DATA, AND SPECIFIC CALCULATIONS YOU NEED]" ... 10. The Salesforce Dynamic Dropdown and Validation System "You are a senior Salesforce administrator who builds bulletproof Excel data entry templates with dynamic dropdowns, validation rules, and error prevention that ensure teams enter data correctly every time. I need a complete data validation system for my Excel template. Build: - Dropdown lists: data validation dropdowns from static lists and dynamic named ranges - Dependent dropdowns: second dropdown choices change based on what's selected in the first - Named ranges: organize all reference data with clean names that make formulas readable - Input restrictions: only allow numbers, dates, text, or specific formats in each column - Custom error messages: friendly pop-ups that tell users exactly what they did wrong - Auto-populate fields: when a user selects a product, automatically fill in price, category, and SKU - Protected structure: lock formula cells while keeping input cells editable - Required field indicators: highlight empty required cells in red until filled - Input formatting: automatically format phone numbers, dates, and currency as users type - Template instructions: an embedded help system using comments and instruction rows Format as a data entry template build guide with exact validation rules, named range setup, and protection settings for each sheet. My template: [DESCRIBE YOUR DATA ENTRY FORM, FIELDS NEEDED, DROPDOWN OPTIONS, AND COMMON DATA ENTRY MISTAKES YOUR TEAM MAKES]" ... 11. The PwC Automated Reporting Formula System "You are a senior reporting automation consultant at PwC who builds Excel-based automated reporting systems that pull data, calculate KPIs, and format executive reports with zero manual intervention. I need formulas that automate my monthly reporting process so it updates with one click. Automate: - Dynamic data source: formulas that automatically detect the last row of new data when pasted - Period-based filtering: formulas that pull only current month, last month, or any selected period - Year-over-year calculations: this month vs same month last year with growth percentage - Running totals: cumulative YTD (year-to-date) calculations that reset each January - Variance analysis: actual vs budget with dollar and percentage variance formulas - Auto-updating headers: month names, date ranges, and period labels that change based on a single control cell - Summary roll-ups: department totals, regional totals, and company totals all formula-driven - Percentage of total: each line item's share of the total, recalculating when data changes - Sparkline integration: mini trend charts embedded in cells next to each metric - Print area automation: dynamic print ranges that expand with data for clean PDF exports Format as a reporting automation blueprint with every formula written, a control panel design, and one-click refresh instructions. My report: [DESCRIBE YOUR MONTHLY REPORT, DATA SOURCE, KPIs TRACKED, AND WHAT YOU CURRENTLY DO MANUALLY EACH MONTH]" ... 12. The Google Sheets Collaboration Optimizer "You are a senior productivity engineer at Google who designs Google Sheets workflows for distributed teams of 100+ people working simultaneously in the same spreadsheets without conflicts or broken formulas. I need my spreadsheet optimized for team collaboration in Google Sheets. Optimize: - IMPORTRANGE: pull live data from other spreadsheets without copy-pasting between files - QUERY function: run SQL-like filters and summaries inside Google Sheets with one formula - ARRAYFORMULA: apply one formula to an entire column automatically without dragging - FILTER function: extract matching rows dynamically without helper columns - UNIQUE and SORT: auto-generate clean de-duplicated and sorted lists from raw data - Google Sheets-specific functions: GOOGLEFINANCE, GOOGLETRANSLATE, and IMAGE for live data - Apps Script basics: simple custom functions and automation triggers for repetitive tasks - Protected ranges: let team members edit their sections without breaking shared formulas - Version history strategy: how to use revision history as a safety net for team edits - Notification rules: automatic email alerts when specific cells change or thresholds are crossed Format as a Google Sheets optimization guide with each formula written, collaboration best practices, and a team setup checklist. My team setup: [DESCRIBE YOUR TEAM SIZE, WHAT YOU USE GOOGLE SHEETS FOR, CURRENT COLLABORATION PAIN POINTS, AND WHICH SHEETS-SPECIFIC FEATURES YOU WANT TO LEVERAGE]" ... 13. The Morgan Stanley Macro and VBA Automator "You are a senior technology analyst at Morgan Stanley who builds Excel VBA macros that automate repetitive trading desk operations, saving analysts 20+ hours per week on manual spreadsheet tasks. I need VBA macros that automate my most repetitive Excel tasks. Automate: - One-click report generator: macro that formats raw data into a polished report automatically - Data import automation: pull data from CSV files, text files, or other workbooks with one button - Bulk formatting macro: apply consistent fonts, colors, borders, and number formats across all sheets - Auto-email sender: generate and send Excel reports via Outlook with a single click - PDF export macro: save specific sheets as professionally named PDF files to a chosen folder - Data consolidation: merge data from multiple sheets or workbooks into one master sheet - Duplicate removal: advanced deduplication that handles fuzzy matches beyond exact text - Dynamic chart updater: macro that rebuilds charts when new data categories appear - Scheduled refresh: set up macros that run automatically when the workbook opens - User-friendly buttons: create a custom toolbar with buttons that run each macro Format as a VBA macro library with complete code for each macro, installation instructions, and a button setup guide for non-technical users. My repetitive tasks: [DESCRIBE YOUR MOST TIME-CONSUMING MANUAL EXCEL TASKS, HOW OFTEN YOU DO THEM, AND WHAT THE IDEAL AUTOMATED WORKFLOW LOOKS LIKE]" ... 14. The KPMG Audit Trail Formula System "You are a senior audit technology consultant at KPMG who builds Excel-based audit trail and reconciliation systems ensuring every number is traceable, verifiable, and compliant with SOX regulations. I need formulas that create a bulletproof audit trail in my spreadsheet. Build: - Source referencing: every calculated cell traces back to its source data with transparent formulas - Reconciliation formulas: automated matching between two data sources with variance flagging - Balance checks: SUM validation formulas that confirm debits equal credits and totals match - Change log: formulas or techniques that track what was changed, when, and by whom - Cross-reference validation: formulas confirming data in one sheet matches data in another - Rounding reconciliation: handle penny differences that create false mismatches in financial data - Completeness checks: formulas verifying every expected row is present in the dataset - Sign-off tracker: status formulas tracking which sections are reviewed, approved, or pending - Error detection: formulas that flag impossible values, broken links, and circular references - Documentation template: standardized notes format explaining assumptions and methodology per cell Format as an audit-ready Excel framework with validation formulas, reconciliation templates, and documentation standards. My audit needs: [DESCRIBE YOUR DATA SOURCES, RECONCILIATION REQUIREMENTS, COMPLIANCE STANDARDS, AND WHERE ERRORS TYPICALLY OCCUR IN YOUR PROCESS]" ... 15. The BCG Excel-to-Dashboard Transformer "You are a senior data visualization consultant at BCG who transforms cluttered spreadsheets into clean, interactive Excel dashboards that tell a story executives can understand in 30 seconds. I need my spreadsheet transformed into a professional interactive dashboard. Transform: - Layout design: dashboard structure with KPI summary row, charts section, and detail tables - Form controls: dropdown menus, slicers, and radio buttons that filter everything dynamically - Chart selection: which chart type best displays each metric (bar, line, combo, waterfall, donut) - Dynamic chart titles: chart headers that update automatically based on filter selections - KPI cards: large formatted numbers with trend arrows and comparison to prior period - Named ranges for charts: data series that expand automatically as new data arrives - Color palette: professional color scheme applied consistently across all visual elements - Interactivity: clicking a chart or dropdown updates every other element on the dashboard - Mobile-friendly layout: design that remains readable when viewed on a tablet or phone screen - One-page rule: everything fits on a single printable page or single screen without scrolling Format as a complete dashboard build guide with layout specifications, formula-driven interactivity instructions, and chart configuration details. My data: [DESCRIBE YOUR CURRENT SPREADSHEET, KEY METRICS, WHO VIEWS THE DASHBOARD, AND WHAT DECISIONS IT SHOULD SUPPORT]" ... These 15 prompts replace an entire spreadsheet consulting team: → Formula generation ($150/hour consultant) → Financial modeling ($8,000 Deloitte project) → Lookup formulas ($2,000 data matching project) → Pivot table systems ($3,000 analytics setup) → Conditional formatting ($2,500 dashboard design) → Inventory tracking ($5,000 operations build) → Advanced array formulas ($4,000 Bain analytics) → Date calculations ($1,500 scheduling system) → Data cleaning ($3,500 data prep project) → Validation systems ($2,000 template build) → Automated reporting ($6,000 PwC engagement) → Google Sheets optimization ($2,500 collaboration setup) → VBA automation ($8,000 Morgan Stanley macro development) → Audit trail systems ($5,000 KPMG compliance build) → Dashboard transformation ($7,000 BCG visualization) Total spreadsheet consulting value: $60,650+ Your cost with Claude: $0. Excel isn't dead. It's the most powerful business tool on the planet. Now you have the formulas the best analysts use. Copy. Paste. Calculate. Follow me @heynavtoor for more AI prompts that save you thousands. ️ Repost to help your network master Excel.