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

👁 22 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

👁 21 views

customer-service Beginner

Customer Service Email Templates for 10 Common Scenarios

Act as a customer service manager. Write professional, empathetic email response...

#customer service #email templates #support

👁 21 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

👁 16 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

👁 16 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

👁 15 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

👁 14 views

coding Advanced

Refactor Legacy JavaScript to Modern ES2024 Standards

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

#javascript #refactoring #es2024

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

👁 13 views

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

#business #leadership #delegation

👁 10 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

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

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

hr Intermediate

Write an interview question that reveals how someone actually thinks

I'm hiring for [role]. The standard interview questions for this role get rehear...

#hr #hiring #interview

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

#excel #working-capital #finance-model

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

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

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

#email #change-management #internal-communication

email Intermediate

Announce a process change people didn't ask for without sounding tone-deaf

We're rolling out a new expense reporting tool next month. The current process w...

#data #analysis #statistics

data Intermediate

Decide whether a metric change is real or just noise this week

A metric I track jumped by 15% this week compared to last week. Before I tell an...