Search: "MATCH"

#excel #dashboard #formulas

Build a self-updating sales dashboard using only formulas (no PivotTables)

I want to build a sales dashboard in Excel that updates automatically when I pas...

👁 4 views

#excel #power-query #unpivot

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

👁 4 views

#reconciliation #matching #accounting

Excel: Reconcile Two Lists That Should Match But Don't

I have two lists — one from our accounting system, one from the bank — that shou...

#landing-page #conversion #cro

marketing Intermediate

Marketing: Diagnose a Landing Page That Gets Traffic But No Signups

My landing page gets steady traffic but the signup rate is 0.4%. Help me diagnos...

#excel #data-cleaning #power-query

Excel: Untangle a Column Where Multiple Fields Got Stuffed Into One

I have one column containing several fields concatenated together (name, email, ...

#data #sql #query-optimization

data Intermediate

Data: Rewrite a Slow Query Without Changing What It Returns

I have a SQL query that's slow. Make it fast while keeping the result set identi...

#design #visual-design #spacing

design Beginner

Design: Audit a Layout for the Three Most Common Spacing Mistakes

I have a layout that feels off but I can't pinpoint why. Audit it for spacing. L...

#design #accessibility #wcag

design Intermediate

Design: Run an Accessibility Pass That Catches the Top 5 Real Issues

Audit this screen for accessibility, but focus on the 5 issues that real users a...

#excel #vlookup #reconciliation

Reconcile two lists that should match but somehow never do

You are an Excel power user. I have two lists in Excel that are *supposed* to be...

#finance #debt #investing

finance Intermediate

Decide between paying off debt and investing without overthinking it

I have [DEBTS — type, balance, interest rate] and [INVESTMENT/SAVINGS CAPACITY —...

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

#voice #style transfer #rewriting

writing Advanced

Match a target voice using only 3 examples of their writing

Below are three short samples (200-400 words each) by the same writer. Identify ...

#excel #fuzzy-match #deduplication

excel Advanced

Detect duplicate-but-different customer records in an Excel list

I have a 5,000-row customer table. Many are the same company entered slightly di...

#excel #reconciliation #xlookup

Reconcile two Excel sheets that almost match but disagree on a few rows

You are an Excel reconciliation specialist. I have two sheets — Sheet A (System ...

#hr #benefits #total-rewards

hr advanced

Design a benefits package that hits a budget without looking cheap

Act as a total-rewards consultant for a small company that cannot match big-tech...

#writing #dm #cold-outreach

writing Beginner

Write a Cold-Pitch DM That Doesn't Read Like a Template

I want to DM [person + platform — Twitter/X, LinkedIn, Instagram] about [specifi...

#hr #job description #hiring

hr Intermediate

Write a job description that filters in the right people, not out

Write a job description for [ROLE TITLE] on [TEAM]. The person needs to be able ...

customer-service Intermediate

Rewrite a support article that customers keep failing despite reading it

Act as a support knowledge designer. This help article [PASTE_ARTICLE] is the to...

#customer-service #knowledge-base #documentation

#excel #power-query #reconciliation

excel Advanced

Reconcile two messy spreadsheets when the join keys don't match

I have two Excel files I need to reconcile, but the join columns aren't clean ma...

#writing #article #content

writing beginner

Turn Bullet Points into a Polished Article

Act as a professional writer. Turn these bullet points into a well-structured ar...