Search: "text functions"

#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 #formulas #running-total

Build a Running Total in Excel That Resets Every Month Without a Pivot Table

I'm working in Excel with a table that has a Date column and an Amount column. I...

#excel #data-cleaning #names

Clean a Messy Excel Customer List Where Names Are in Six Different Formats

I have an Excel sheet with about 4,000 customer records. The Name column is a di...

writing Beginner

Rewrite Corporate Jargon Into Something a Human Would Actually Say

I have a piece of internal corporate writing that's full of phrases like 'levera...

#writing #tone #jargon

#excel #formulas #xlookup

Replace nested IFs with a lookup table you can actually maintain

I have a worksheet with nested IF formulas like: =IF(A1="Bronze",0.05,IF(A1="Sil...

#excel #pivot-table #data-cleanup

Find the rows that broke a pivot table without scrolling 40,000 rows

My pivot table is showing #N/A or a mysterious 'blank' row, and the source data ...

customer-service Advanced

Build a triage rule that doesn't make easy tickets wait behind hard ones

Our support queue gets jammed because complex tickets sit at the top and easy on...

#customer-service #triage #support-operations

excel Advanced

Turn a messy CRM CSV export into a clean Excel dashboard

I will paste a CRM export with inconsistent date formats, duplicate accounts und...

#excel #csv #lambda

#excel #audit #inherited-model

Audit a spreadsheet a predecessor built before you trust a single number

I inherited an Excel model from someone who left. I need to know if I can trust ...

#excel #template #validation

excel Advanced

Build a self-checking Excel template that catches user-entered errors before they propagate

I'm building a template that non-technical colleagues will fill in monthly. Past...

#marketing #social media #content calendar

marketing Intermediate

Create a Month of Social Media Content from One Theme

You are a social media strategist who helps brands stay consistent without burni...

#creative #video #storyboard

creative Intermediate

Storyboard a 30-Second Video Ad

Storyboard a 30-second video ad for [PRODUCT] targeting [AUDIENCE]. Provide 8 pa...

#coding #refactoring #clean code

coding Advanced

Refactor a 400-Line Function Into Cohesive Smaller Pieces

I'll paste a 400-line function that does too much. Help me refactor it. Walk thr...

data Advanced

Cohort Retention Analysis from Event Log

From the event log table with columns user_id, event_name, occurred_at, build a ...

#data #cohort #retention

#excel #power-query #data-cleaning

Excel: Convert a Messy Paste-from-PDF Table Into a Clean Dataset

I pasted a table from a PDF and Excel split it badly — values are stuck together...

customer-service Intermediate

Customer Service: Write a Help Article That Cuts the Ticket Instead of Creating It

We get a lot of tickets about [ISSUE]. Help me write a help article that actuall...

#customer-service #knowledge-base #documentation

#design #accessibility #a11y

design Advanced

Design: Make Our Product Accessible Without Just Adding Alt Text and Calling It Done

We're improving accessibility on [PRODUCT]. The audit will catch missing alt tex...

#data #cleaning #preprocessing

data Intermediate

Clean a messy dataset without losing the rows that actually mattered

I have a dataset with [N] rows and [LIST PROBLEMS: missing values, duplicates, m...

#design #accessibility #a11y

design Intermediate

Make a design accessible without making it ugly

Review the design below for accessibility issues and help me fix them without ma...

#dates #data cleaning #DATEVALUE

Detect mixed date formats in one column and pick the safest fix

Act as a spreadsheet auditor. I will paste 20 cells from a date column that came...

excel Advanced

Automate Variance-to-Budget Reporting in Excel with LET and LAMBDA

You are an FP&A automation specialist. I have a monthly actuals sheet and a budg...

#lambda #let #variance

#reengagement #saas #lifecycle

email Intermediate

Write a Layered Re-Engagement Email Sequence for Dormant SaaS Users

Act as a lifecycle marketing strategist. Write me a 4-email re-engagement sequen...

#design #typography #type-pairing

design Intermediate

Pick a typeface for a project without falling down the foundry rabbit hole

I'm picking type for [project type — brand, app, document, signage]. The brand q...