Search: "Excel timeline"

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

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

#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

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

email Intermediate

Draft a Calm Outage Notification Email That Builds Trust

You are a customer communications lead at a B2B SaaS company. Draft an outage no...

#outage #incident #trust

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

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

#excel #comparison #vlookup

Compare Two Excel Sheets and Highlight Real Differences

I need to compare two Excel sheets that should match but probably don't. Sheet A...

#excel #inventory #reorder

Excel Inventory Reorder-Point Calculator with Safety Stock

I'm building a reorder-point sheet for [number] SKUs in Excel. For each SKU I ha...

#excel #inventory #reorder-point

Excel Inventory Reorder Point Calculator

Build an Excel template that calculates the reorder point for each SKU using lea...

customer-service Intermediate

De-escalation Response to an Angry Customer

Write a customer service response to an angry customer using the LEAP framework:...

#customer-service #de-escalation #leap

#excel #charts #visualization

excel Beginner

Excel: Pick the Right Chart for the Story You're Trying to Tell

I have data and a point I want to make, but I don't know which chart conveys it ...

#excel #financial-modeling #three-statement

Excel: Build a Three-Statement Model That Stays Internally Consistent

I need a three-statement financial model (income statement, balance sheet, cash ...