Search: "date"

#dates #iso #data cleaning

Convert Messy Excel Date Formats to Standardized ISO

I have a column of dates in Excel with inconsistent formats: '03/15/2024', '15-M...

👁 7 views

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 #reconciliation #fuzzy match

👁 7 views

writing Beginner

Convert Meeting Transcript into a Decision Log and Action Items

Below is a raw meeting transcript with timestamps and speaker labels. Produce th...

#writing #meeting-notes #decision-log

#finance #runway #burn rate

finance Intermediate

Build a Runway Calculator With Burn Sensitivity

Help me build a runway calculator with sensitivity analysis. Inputs: current cas...

#hr #termination #manager

hr Advanced

Coach a Manager Through a Difficult Termination Conversation

Coach a first-time manager through a termination conversation tomorrow morning. ...

#rolling #trend #dynamic-range

Excel: Build a Rolling 12-Month Revenue Trend Without Hardcoded Dates

I want a chart that always shows the last 12 months of revenue — so when I add M...

#creative #fiction #story premise

creative Beginner

Generate a Short Story Premise From Three Random Inputs

Generate a short story premise (200-400 words) by combining these three inputs: ...

Build a Sales Pipeline Velocity Tracker in Excel

Act as an Excel expert. I want a single-sheet pipeline velocity tracker. My deal...

#excel #sales #pipeline

#pre-mortem #risk-management #project-planning

business Intermediate

Run a Pre Mortem on a Project Before It Starts

Facilitate a pre-mortem on a project I'm about to start. Project: [NAME, ONE-LIN...

#privacy-policy #gdpr #user-notification

legal Intermediate

Draft a Plain English Privacy Policy Update Email

Draft a plain-English email notifying users of a privacy policy update. What cha...

#excel #gantt #project-management

Excel Project Gantt Chart from Task List

Generate an Excel Gantt chart from a task list with columns Task, Start Date, Du...

productivity Intermediate

Decision Journal Entry Template

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

#productivity #decision-journal #decision-making

#finance #cash-flow #forecasting

finance Intermediate

Finance: Build a 13-Week Cash Flow Forecast That Actually Catches Surprises

I need a 13-week rolling cash flow forecast for a small business. Help me build ...

#data #analytics #investigation

data Advanced

Data: Find the Real Cause When a Metric Drops 12% Overnight

[METRIC] dropped 12% on [DATE]. The execs want an answer by EOD. Help me investi...

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

#productivity #planning #weekly

productivity Beginner

Plan a week that survives contact with reality

Help me plan my week starting [DATE]. Here's what I have to deliver: [LIST]. Her...

#email #decline #speaking

email Beginner

Decline a Speaking Invitation Without Closing the Door

Write a short reply declining a speaking invitation for [EVENT NAME] on [DATE]. ...

#education #mentoring #student support

education Intermediate

Help a Student Recover From Failing a Major Assessment

Help me draft a conversation with a student who just failed [ASSESSMENT]. The st...

customer-service Intermediate

Write a Macro Library That Doesn't Sound Like a Macro

Help me build a macro library for [TOP 10 RECURRING TICKETS]. Constraints: each ...

#customer-service #macros #support

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

#excel #formulas #debugging

Excel: Fix the Formula That Works Until It Doesn't

Here's a formula that works on most rows but breaks on a few: [PASTE FORMULA AND...

#email #pricing #customer-retention

email Advanced

Email: Tell Customers About a Price Increase Without Losing Them

Write a price increase email for [PRODUCT/SERVICE] going from $[X] to $[Y] effec...

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