Search: "let"

#excel #formula #duplicates

Excel Formula to Detect Duplicate Customer Records Across Multiple Columns

Act as an Excel expert. I need a formula that flags duplicate customer rows wher...

👁 32 views

productivity Advanced

Delegation Framework and Task Brief Template

Create a delegation system that helps me hand off work effectively. My role: [y...

#delegation #task management #leadership

👁 28 views

data Advanced

Explain a metric movement to a skeptical stakeholder without overclaiming

[Metric] moved [direction + magnitude] in [period]. The first plausible explanat...

#data #metrics #analysis

👁 23 views

creative Beginner

Children's Story with Moral Lesson and Illustrations Guide

Write an original children's story with the following specifications: - Target ...

#children story #picture book #storytelling

👁 21 views

business Intermediate

ChatGPT Prompt: Investor Update Email Template for Seed-Stage Founders

You are an experienced founder writing a monthly investor update. Help me draft ...

#business #startup #investor-update

👁 21 views

coding Advanced

Refactor Legacy JavaScript to Modern ES2024 Standards

Refactor the following legacy JavaScript code to modern ES2024 standards: [PAST...

#javascript #refactoring #es2024

👁 20 views

excel advanced

Build a working capital model from a P&L extract without manual joins

Act as a finance analyst. I will paste a monthly P&L extract plus a trial-balanc...

#excel #working-capital #finance-model

👁 20 views

email Beginner

Networking Follow-Up Email After a Conference or Event

Write 3 variations of a networking follow-up email to send within 48 hours after...

#email #networking #follow-up

👁 19 views

#excel formulas #dynamic arrays #dashboard

ChatGPT Prompt: Excel Dynamic Array Formulas for Reporting Dashboards

Build a reporting dashboard using Excel 365 dynamic array formulas (FILTER, SORT...

👁 18 views

email Intermediate

Email Sequence to Nurture an Inbound Lead Who Went Cold After a Demo

Build a 4-email nurture sequence for an inbound SaaS lead who attended a demo, s...

#email #nurture-sequence #sales

👁 18 views

coding Intermediate

Choose what to log and what to drop when adding observability to a service that has none

You're an SRE who has cleaned up a lot of logging messes. I'm adding observabili...

#observability #logging #metrics

👁 17 views

finance Intermediate

Build a Quarterly Cash-Forecast Model for a Small Business

I run a [type of business, revenue range, payment-terms structure]. Help me buil...

#finance #cash-flow #forecasting

👁 16 views

customer-service Intermediate

De-escalate an Angry Customer Call

Coach me through de-escalating an angry customer call. Cover: the first 30 secon...

#customer-service #escalation #calls

#excel #reconciliation #fuzzy match

excel Advanced

Reconcile Two Bank Statements with Fuzzy Matching in Excel

I have two sheets: 'Bank' with columns Date, Description, Amount and 'Books' wit...

#creative #character #fiction

creative Advanced

Write a Character Who Is Wrong But Not Stupid

Help me write a character who holds a position I personally disagree with, in a ...

#business #leadership #delegation

business Advanced

Business: Replace Myself in a Role I'm Both Good At and Bottlenecking

I'm still doing [ROLE/FUNCTION] in my company because I'm the best at it — and i...

#excel #let-function #formulas

Replace nested IFs with a clean LET formula that future-you can read

You are an Excel formula refactorer. Here is a nested IF formula that works but ...

customer-service Intermediate

Write a canned response that doesn't sound canned

We get [type of request] dozens of times a week. Currently each agent freestyles...

#customer-service #templates #canned-response

Excel: Replace a Wall of Nested IFs With One Clean SWITCH or IFS

I have a nested IF formula that's grown unmaintainable. Rewrite it using SWITCH,...

#excel #formulas #switch

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

#creative #brainstorming #ideation

creative Beginner

Brainstorm without converging on the first idea that sounds plausible

I need to brainstorm [TOPIC — campaign, name, feature, solution]. Give me ideas ...

#excel #formulas #debugging

excel Advanced

Reverse-engineer a broken Excel formula someone else wrote

I inherited a spreadsheet with a long, nested Excel formula I don't understand a...