Search: "formula"

#XLOOKUP #VLOOKUP #Excel formulas

Excel VLOOKUP to XLOOKUP Migration: Formula Modernization Guide

I have existing Excel spreadsheets that use VLOOKUP formulas and I want to moder...

👁 15 views

business Beginner

Freelancer Rate Card and Pricing Calculator

Act as a freelance business coach. Help me create a comprehensive rate card and ...

#business #freelance #pricing

#sales commission tracker #tiered commission excel #clawback formula

excel Advanced

ChatGPT prompt for Excel sales commission tracker with tiered rates and clawbacks

Act as a sales operations analyst who is great at Excel. I need a commission tra...

#dynamic array #FILTER #SORT

excel intermediate

Excel Dynamic Array FILTER SORT UNIQUE Formula Guide

Teach me how to use Excel dynamic array functions (FILTER, SORT, UNIQUE, SEQUENC...

#financial-model #three-statement #excel

excel advanced

Excel Financial Model Three-Statement Integration

Build a three-statement financial model in Excel for [company type, e.g., a SaaS...

#excel #conditional-formatting #kpi

excel intermediate

Excel Conditional Formatting Rules for KPI Dashboard Indicators

Create a complete system of Excel conditional formatting rules to build a profes...

excel beginner

Excel Formula Troubleshooter and Optimizer

I have an Excel formula that is not working correctly or returning unexpected re...

#excel #formula #debug

#xlookup #excel formulas #index match

Excel XLOOKUP Multi-Criteria Lookup Replacing INDEX-MATCH

Act as an Excel formula expert. Help me replace nested INDEX-MATCH and VLOOKUP f...

#excel #text-functions #parsing

Convert Messy Text Column Into Clean Structured Fields

I have a single column in Excel containing messy entries like "{{example raw ent...

#data #Google Sheets #dashboard

data Intermediate

Google Sheets Dashboard with Automated Data Import

Act as a Google Sheets expert. Create a complete marketing dashboard in Google S...

#excel #xlookup #index match

excel Beginner

ChatGPT prompt for fixing broken Excel lookup formulas across multiple sheets

Act as a senior Excel troubleshooting expert. I have a workbook where lookup fo...

#scenario model #financial modeling #excel planning

excel Advanced

ChatGPT Prompt for Excel Scenario Model Comparing Best Base and Worst Cases

Help me build an Excel scenario model that compares best case, base case, and wo...

#Excel #formulas #automation

Excel Intermediate

Excel Formula Generator

Create Excel formulas for: [DESCRIBE TASK]. Include: the formula, explanation of...

excel intermediate

Excel XLOOKUP Advanced Techniques Guide

You are an Excel expert. I need to use XLOOKUP for complex data retrieval tasks....

#excel #xlookup #lookup

#data #power-bi #dashboard

data intermediate

Power BI Dashboard Design: Sales Performance Metrics

Act as a Power BI specialist and data visualization expert. Help me design a sal...

#Gantt chart #project management #Excel timeline

Excel Gantt Chart: Project Timeline and Milestone Tracker

I want to build a professional Gantt chart in Excel for project management witho...

#excel #audit #performance

excel Advanced

Audit a Workbook for Broken or Slow Formulas

You are an Excel auditing specialist. Walk me through a systematic audit of a wo...

#excel #vlookup #index-match

excel beginner

VLOOKUP vs INDEX-MATCH: Smart Data Lookup Formulas

I need to retrieve data from a lookup table in Excel. My main table has [column ...

Excel XLOOKUP Formula for Multi-Criteria Search

Help me write an Excel XLOOKUP formula that searches across multiple criteria. M...

#excel #xlookup #formula

#break-even analysis #financial modeling #startup finance

finance intermediate

Break-Even Analysis: Startup Product Calculation Template

Help me calculate and model the break-even analysis for [product/business type]....

#dynamic arrays #FILTER #SORT

Excel Dynamic Arrays: FILTER, SORT, and UNIQUE Functions Mastery

Help me master Excel dynamic array functions to replace my manual filtering and ...

#positioning #competitive strategy #brand strategy

marketing Advanced

ChatGPT Prompt: Competitive Positioning Statement and Differentiation Map

Develop competitive positioning for [COMPANY/PRODUCT] that clearly differentiate...