Search: "excel audit"

#excel #goal-seek #solver

Excel Goal Seek Alternative for Multi-Variable What-Ifs

I have an Excel model where multiple inputs affect one output and Goal Seek only...

#design #form #conversion

design Intermediate

Audit a Form for the Friction Costing You Completions

Here's a form I want to audit for completion-killing friction: [describe field-b...

#excel #variance-analysis #budget

Excel Variance Analysis Budget vs Actual

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

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

#sensitivity #what-if #modeling

Excel: Two-Way Sensitivity Table Without the Data Table Feature

Excel's built-in Data Table feature recalculates the whole workbook and freezes ...

#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 #performance #formulas

Excel: Diagnose Why a Slow Workbook Takes 30 Seconds to Recalc

My Excel workbook recalculates painfully slowly and I don't know which sheet or ...

#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 #capacity-planning #modeling

Excel: Build a Capacity Model That Doesn't Pretend Everyone Works 40 Hours

I'm modeling team capacity in Excel for the next quarter: [TEAM, ROLES, HOLIDAYS...

marketing Advanced

Marketing: Audit Our Brand Voice for the Sentences That Don't Sound Like Us

We have a brand voice doc [or vibe] but recent content [BLOG, EMAIL, SOCIAL] has...

#marketing #brand #voice

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

#design #ux #user-research

design Advanced

Run Five User Interviews Without Leading the Witness Toward the Answer You Want

I'm running five user interviews to validate a product idea. I've noticed I have...

#design #accessibility #a11y

design Intermediate

Audit an Interface for Accessibility When You Can't Do a Full WCAG Pass

I have a small product and I want to make it meaningfully more accessible, but 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 #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....

productivity Intermediate

Build a Personal Knowledge Management System That Survives the Honeymoon

Act as a knowledge management practitioner who has seen every shiny tool come an...

#pkm #note-taking #productivity

#fp&a #financial-modeling #drivers

finance Advanced

Build a Driver-Based Financial Model from Scratch

Act as a senior FP&A modeler. Walk me through building a driver-based financial ...

#landing-page #cro #audit

design Intermediate

Audit a Landing Page for Conversion-Killing Friction

Act as a conversion designer. I will paste a landing page URL or describe it. Au...

#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 #power-query #unpivot

Turn a wide budget sheet into a flexible pivot-ready long format

I have a budget spreadsheet in wide format: one row per account, then 12 columns...

productivity Intermediate

Weekly Review Template Inspired by GTD

Create a comprehensive weekly review template based on David Allen's GTD methodo...

#gtd #weekly review #productivity

👁 5 views

design Advanced

Audit a Product's Spacing System for Inconsistency

I'm auditing the spacing in [PRODUCT'S] UI. Help me with a structured pass. Outp...

#design #spacing #design system

👁 5 views