Search: "excel planning"

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

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

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

#lesson-plan #retention #retrieval-practice

education Intermediate

Design a 20 Minute Lesson That Sticks Past the Test

Design a 20-minute lesson that students will still remember next month, not just...

#cash-flow #forecasting #runway

finance Advanced

Build a 13 Week Cash Flow Forecast That Catches Trouble Early

Build a 13-week rolling cash flow forecast template for [BUSINESS TYPE]. Inputs ...

data Intermediate

Decide If This Data Is Worth Analyzing Before You Spend a Week On It

Before I dig into [dataset and analysis question], help me decide if it's worth ...

#data #analysis #scoping

#productivity #planning #daily

productivity Beginner

Plan Tomorrow in Five Minutes Tonight So You Don't Drift in the Morning

Walk me through a 5-minute evening planning ritual for tomorrow. I'll give you: ...

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

#lesson-plan #flexibility #attendance

education Intermediate

Education: Plan a Lesson That Survives Half the Students Being Absent

Help me design a lesson on [topic] that works whether 30 students show up or 12....

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

#excel #power-query #data-cleanup

Excel: Clean a Messy Address Column Without Losing Edge Cases

I have a column of free-text addresses scraped from a form: [PASTE 20 SAMPLES]. ...

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

Build a Weekly KPI Dashboard in Excel That Doesn't Break When Someone Renames a Tab

I'm building a weekly KPI dashboard in Excel for a small operations team. The so...

#excel #dashboard #kpi

#education #lesson-planning #teaching

education Advanced

Design a Lesson for Students Who Already Think They Know the Material

I'm teaching a lesson on a topic where 60% of the class will say 'I already know...

#business #strategy #planning

business Advanced

Pressure-test a strategy before you commit a quarter to it

Act as a skeptical board member who's seen plenty of strategies fail. I'm about ...

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

#excel #pivot-table #data-cleanup

Find the rows that broke a pivot table without scrolling 40,000 rows

My pivot table is showing #N/A or a mysterious 'blank' row, and the source data ...

#excel #automation #power-query

Schedule an Excel file refresh without setting up a server

I have an Excel workbook that pulls data from a CSV in OneDrive via Power Query....

#excel #reconciliation #xlookup

Reconcile two Excel sheets that almost match but disagree on a few rows

You are an Excel reconciliation specialist. I have two sheets — Sheet A (System ...

#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 #template #validation

Build a self-checking Excel template that catches user-entered errors before they propagate

I'm building a template that non-technical colleagues will fill in monthly. Past...

#excel #data validation #conditional formatting

excel Beginner

Design a self-updating Excel tracker with data validation

Help me build an Excel tracker (for tasks, inventory, or expenses — I'll tell yo...