Search: "date"

#pivot tables #dashboard #monthly report

excel Beginner

Turn a flat sales export into a one-screen monthly summary

I have a sales export with columns: order_id, date, region, sales_rep, product_c...

#analytics #debugging #metrics

data Intermediate

Diagnose Why a Dashboard Metric Suddenly Changed

You are a senior data analyst. Walk me through a structured investigation for: [...

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 #power-query #office-scripts

excel Advanced

Automate a weekly Excel report that pulls from three CSVs and emails itself

You are an automation engineer. I get three CSVs every Monday — [CSV_1], [CSV_2]...

#email #salary-negotiation #offer

email Advanced

Counter a salary offer that is 15% below your number without burning the relationship

You are a compensation negotiation coach. Draft an email reply to a recruiter wh...

#email #decision-memo #slack

Turn a long Slack/Teams thread into a single email decision memo

We just argued about [topic] in a 47-message Slack thread and need to capture th...

#productivity #slack #triage

productivity Beginner

Triage 200 unread Slack messages without missing the one that mattered

I just came back from PTO / out of meetings all day, and I have ~200 Slack messa...

#email #summary #decision making

Turn a tense email thread into one clear summary-and-decision message

I'm stuck in a long email thread that's gone in circles. I'll paste it. Read the...

#education #study #exam prep

education Intermediate

Make me a study plan that fits the time I actually have

I have an exam on a date I'll give you, a list of topics, and a realistic number...

#email #invoice #payment reminder

Draft a Firm but Friendly Payment Reminder Email

You are a small-business collections specialist who keeps client relationships i...

#data #schema #spreadsheet

data Beginner

Design a Clean Data Collection Spreadsheet or Schema

You are a data architect who helps people set up clean data from the start so it...

#scope-change #project-management #stakeholder

Write a Calm Reply to a Last-Minute Scope Change Request

Help me write a calm, professional email reply to a stakeholder who is requestin...

#email #price-increase #customer-retention

email Advanced

Email Announcing Price Increase to Existing Customers

Draft an email announcing a price increase to existing customers, effective in 6...

productivity Intermediate

Decision Journal Entry Template

Create a decision journal entry template for documenting a significant decision....

#productivity #decision-journal #decision-making

#reconciliation #matching #accounting

excel Intermediate

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

#hr #compensation #retention

hr Advanced

Hr: Tell a Top Performer There's No Raise This Cycle Without Losing Them

[NAME] is a top performer and there's no budget for a raise this cycle: [REASON ...

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

#gantt #project-tracker #dashboard

excel Intermediate

Create a Self-Updating Excel Project Tracker with Gantt View

Act as a project management consultant. Build me a self-updating Excel project t...

#email #internal-comms #leadership

email Advanced

Announce a leadership departure without rumor-mill spillover

You are an internal communications lead. Draft a company-wide email announcing t...

productivity intermediate

Plan a project kickoff that prevents the rework you usually see in week 3

Act as a project manager who has seen the same week-three problems for ten years...

#productivity #project-management #kickoff

#excel #sumifs #debugging

excel Intermediate

Diagnose why my SUMIFS is returning zero

My SUMIFS formula returns 0 even though I can see matching rows. Ask me to paste...

#email #status update #summary

email Beginner

Turn Messy Notes into a Clear Status Update Email

Act as an executive communication assistant. I will paste rough, unstructured no...

legal Intermediate

Draft a Simple NDA or Service Agreement Template

Act as a legal drafting assistant who produces clear starter templates for small...

#legal #nda #contract