Search: "text functions"

#XLOOKUP #INDEX MATCH #multi-criteria lookup

excel advanced

Excel XLOOKUP Multi-Condition: Advanced Lookup Formulas Guide

I need to look up values in Excel using multiple conditions. My dataset has colu...

#tiktok #short-form #hooks

marketing Beginner

TikTok Hook Generator for B2B Brand

Act as a B2B short-form video strategist. For [COMPANY], a [INDUSTRY] brand sell...

#coding #typescript #generics

coding Advanced

ChatGPT Prompt: TypeScript Type Inference Helper for Complex Generic Functions

You are a TypeScript type-system expert. Help me get correct types on a generic ...

#writing #editing #plain-language

writing Beginner

Rewrite Corporate Jargon into Plain Human Language

Take the corporate jargon I'm about to paste and rewrite it as if a real person ...

#data #SQL #funnel analysis

data Intermediate

Write a SQL Query to Find Users Stuck Mid-Funnel

Write a SQL query that finds users stuck mid-funnel for re-engagement. Schema: e...

#win-back campaign #email marketing #inactive subscribers

email Intermediate

Customer Win-Back Email Campaign: Re-Engage Inactive Subscribers

Help me write a customer win-back email campaign to re-engage subscribers who ha...

excel Advanced

Excel VBA Macro to Automate Repetitive Report Formatting

Write an Excel VBA macro that automates the formatting of a weekly report I rece...

#VBA #macro #automation

#color palette #typography #brand identity

design Intermediate

Color Palette and Typography System for Brand Identity

Design a color palette and typography system for [brand name] in the [industry]....

#photography #shot-list #campaign

creative Intermediate

Photography Shot List for Brand Campaign

Act as a photo director. Build a shot list for a brand campaign for [BRAND] supp...

#finance #cash-flow #forecasting

finance Advanced

Build a 13-Week Cash Flow Forecast With Scenario Toggles

Walk me through building a 13-week cash flow forecast for a small business. Outp...

#excel #pivot-table #calculated-field

excel Intermediate

Excel Pivot Table Calculated Field for Margin Percentage by Segment

I have a sales table with columns: order_id, date, customer_segment, product, re...

#excel #dynamic-arrays #textsplit

excel Advanced

Excel Dynamic Array Formula to Split Comma-Separated Tags into Columns

I have column A filled with comma-separated tags like 'urgent, vip, refund, bill...

data Advanced

Funnel Analysis Query Diagnosing the Worst Drop-Off Step

I have an events table (event_name, user_id, event_time, properties JSON). Write...

#data #funnel #sql

#dates #iso #data cleaning

excel Intermediate

Convert Messy Excel Date Formats to Standardized ISO

I have a column of dates in Excel with inconsistent formats: '03/15/2024', '15-M...

#design system #color #accessibility

design Advanced

Design System Color Palette with Accessibility Tokens

Design a complete color palette for a design system. Brand attributes: [ATTRIBUT...

#design #accessibility #a11y

design Intermediate

Audit a UI for Accessibility Wins You Can Ship This Week

Help me audit my product for accessibility wins I can ship within a week, not th...

#legal #terms-of-service #user-communication

legal Intermediate

Legal: Update Our Terms of Service So Users Will Actually Read One Sentence

We're updating our ToS: [CONTEXT — new product line, regulatory change, etc.]. N...

#excel #power-query #unpivot

excel Intermediate

Turn a wide budget sheet into a flexible pivot-ready long format

I have a budget spreadsheet in wide format: one row per account, then 12 columns...

#creative #video script #shot list

creative Beginner

ChatGPT Prompt for Short Video Hook and Shot List for Product Demo Reel

Create a short-form video concept for a product demo reel. Product: [describe]. ...

#newsletter writing #email marketing content #subscriber engagement

writing intermediate

Email Newsletter Issue Writing: Subscriber Engagement Template

Write a compelling email newsletter issue for my audience of [describe your subs...

#email marketing #A/B testing #subject lines

marketing Intermediate

Email Marketing A/B Testing: Subject Line Optimization Guide

Help me design and run effective A/B tests for my email marketing campaigns. I n...

#email-design #html-email #newsletter-design

design intermediate

Email Newsletter Design: Responsive HTML Template Best Practices

Help me design and code a high-quality responsive email newsletter template. Con...

#product launch #email newsletter #announcement

email Intermediate

Email Newsletter Template for Product Launch Announcement

Draft a product launch announcement email for [describe your product, e.g., a ne...