Search: "excel planning"

#excel #power query #survey

Convert a Messy Survey Export Into Clean Long-Format Data

I exported a survey to Excel. Each respondent is one row, each question is its o...

#education #teaching #pedagogy

education Intermediate

Design a Lesson That Teaches Through a Single Concrete Example

Help me design a 50-minute lesson on [CONCEPT] for [LEVEL — e.g., high school, u...

#power-query #csv #data-cleaning

Convert a Messy CSV Export Into a Clean Excel Table

Help me clean a messy CSV export from [SYSTEM NAME] and turn it into an Excel Ta...

#coding #estimation #planning

coding Intermediate

Estimate How Long a Feature Will Take Without Lying to Yourself

I need to give an honest estimate for [feature name and 3-sentence description]....

#excel #commission #sales

Excel Sales Commission Tiered Calculator

Create an Excel formula that calculates sales commission using tiered rates: 5% ...

#excel #variance-analysis #budget

Excel Variance Analysis Budget vs Actual

Build an Excel variance analysis report comparing Budget vs Actual for revenue a...

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

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

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

#excel #pivot tables #reporting

Turn a messy operational export into a pivot table that someone will actually read

I have an operational export with [N] rows and columns like [DATE, REGION, PRODU...

productivity Intermediate

Write a weekly plan that survives the first interruption on Monday

I'm tired of weekly plans that get blown up by Monday afternoon. Help me write a...

#productivity #planning #weekly-review

#excel #cash flow #forecast

Build a Rolling 12-Month Cash Flow Forecast in Excel

You are an Excel financial modeling expert. Help me build a rolling 12-month cas...

#excel #dashboard #pivottable

excel Advanced

Create a Dynamic Dashboard with Slicers and PivotTables

You are an Excel dashboard designer. Guide me through building an interactive sa...

#marketing #social media #content calendar

marketing Intermediate

Create a Month of Social Media Content from One Theme

You are a social media strategist who helps brands stay consistent without burni...

#chatgpt prompt for excel tracker #invoice aging #accounts receivable

ChatGPT Prompt for Building an Excel Cash Collection Tracker from Invoices

Act as an expert Excel analyst for accounts receivable. Help me build a cash col...

#budget tracker #personal finance #Excel template

excel Beginner

Excel Personal Budget Tracker: Monthly and Annual Template

Help me build a comprehensive personal budget tracker in Excel from scratch. I n...

#business #exit-strategy #valuation

business advanced

Exit Strategy Planning Guide for Small Business Owners

Create a comprehensive exit strategy planning guide for a small business owner p...

#education #teaching #lesson-plan

education Intermediate

ChatGPT Prompt: Lesson Plan for Teaching a Hard Concept With a Concrete Analogy

You are an experienced teacher trained in cognitive science. Build a 45-minute l...

productivity Intermediate

Personal OKR Template Aligned to Annual Themes

You are a personal coach. Help me set quarterly personal OKRs aligned to my annu...

#productivity #okr #goals

#productivity #daily-plan #planning

productivity Beginner

Design a Single-Sheet Daily Plan That Survives Reality

Help me design a one-page daily plan that doesn't fall apart by 11am. Include: t...

productivity Intermediate

Plan Your Week So Energy Matches Task Type

Help me plan next week so my energy matches task type, not just my calendar. Inp...

#productivity #weekly planning #energy management

excel Advanced

Audit a Workbook for Broken Formulas and Hidden Dependencies

I inherited a 30-sheet Excel workbook and it gives slightly wrong totals. Walk m...

#excel #audit #formulas

#business #pre-mortem #risk

business Intermediate

Run a Pre-Mortem on a Project Before You Kick It Off

Facilitate a pre-mortem for [PROJECT]. Context: [GOAL, TIMELINE, TEAM SIZE, BUDG...