Search: "text functions"

#xlookup #excel formulas #index match

excel Intermediate

Excel XLOOKUP Multi-Criteria Lookup Replacing INDEX-MATCH

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

#creative #game design #level design

creative Advanced

Game Level Design Document with Progression and Difficulty Curve

You are a senior level designer. Draft a level design document for level [N] of ...

#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 #power-query #data-cleaning

excel Intermediate

Convert a Messy Paste from PDF into a Clean Table

I pasted a table from a PDF into Excel and the data is jumbled — some rows are s...

#email marketing #win-back #customer retention

marketing Intermediate

Customer Win-Back Email Sequence

Design a 4-email win-back sequence for churned customers. Context: - Product: [P...

#education #Socratic method #discussion

education Intermediate

Socratic Discussion Questions for Any Reading or Topic

Act as a master teacher skilled in Socratic method. Generate a complete Socratic...

#data #machine learning #classification

data Advanced

Machine Learning Model Selection Guide for Classification

Help me select the right machine learning model for a classification problem. My...

#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...

#social media calendar #content planning #content marketing

marketing beginner

Social Media Content Calendar: 30-Day Planning Template

Create a 30-day social media content calendar for [brand name], a [type of busin...

#dynamic arrays #FILTER #SORT

excel Intermediate

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

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

#creative #writing #children-books

creative intermediate

Children Book Writing Character and Story Structure Complete Guide

Write a comprehensive guide to creating and publishing a children's picture book...

excel beginner

Excel Formula Troubleshooter and Optimizer

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

#excel #formula #debug

customer-service Intermediate

NPS Survey Follow-Up Strategy for Customer Feedback Loop

Design a complete NPS (Net Promoter Score) survey and follow-up strategy for [co...

#NPS #customer feedback #survey strategy

#dark-mode #colors #design-system

design Advanced

Dark Mode Color System Conversion Guide

Act as a design system lead. I have an existing light-mode palette: [PASTE TOKEN...

#code review #pull request #software engineering

coding Intermediate

ChatGPT Prompt: Code Review Checklist Tailored to PR Diff Analysis

Review this pull request diff and provide structured feedback. [PASTE DIFF OR F...

#coding #refactoring #clean-code

coding Intermediate

Refactor a God Function with Multiple Responsibilities

Below is a function that's grown to ~200 lines and does too much. Refactor it. R...

data Advanced

SQL Window Function to Find Customer Churn Cohort by First-Purchase Month

Write a Postgres query to produce a monthly cohort retention table. Source table...

#data #sql #postgres

#data #sql #window-functions

data Advanced

Write Window Functions That Replace a Subquery Loop

Act as a senior SQL engineer. I need to compute {{describe: e.g., 7-day rolling ...

#marketing #instagram #content calendar

marketing Intermediate

30-Day Content Calendar for Instagram

Create a 30-day Instagram content calendar for [BRAND] in the [NICHE] niche, pos...

#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...

#faq writing prompt #help center content #customer questions to faq

writing Beginner

ChatGPT prompt for writing a help center FAQ from repeated customer questions

I want to turn repeated customer questions into a clear help center FAQ. Act lik...

#data #survey analysis #qualitative research

data Intermediate

ChatGPT Prompt for Survey Open-Text Response Coding Framework

Analyze these open-text survey responses and build a coding framework I can reus...

#creative #childrens-book #writing

creative beginner

Children Book Story Structure and Writing Guide

You are a children book author and editor with published picture books and early...