Search: "excel audit"

#excel #data-validation #dropdown

Build a Dynamic Dropdown Validation Plan

You are an Excel data-validation specialist. I will describe the lists and rules...

👁 4 views

#excel #headcount #hiring

Build a Headcount Plan Spreadsheet with Hiring Ramp

Help me build a 12-month headcount plan in Excel. Inputs I'll provide: [list cur...

#excel #inventory #reorder-point

Excel Inventory Reorder Point Calculator

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

data Intermediate

Data Quality Audit Checklist for New Dataset

Run a data quality audit on the dataset described below. Check for: missing valu...

#data #quality #audit

#design #design-system #audit

design Advanced

Design System Component Audit Checklist

Audit the design system component below. Check: naming consistency with the rest...

productivity Intermediate

Productivity: Cut Your Recurring Meetings in Half

Help me audit my recurring meetings and recommend which to kill, shorten, or con...

#meetings #calendar-audit #async

#excel #pivot-tables #analysis

Excel: Rebuild a Pivot That Lies to Stakeholders

Look at this pivot table setup: [PASTE COLUMNS, FILTERS, AND VALUES]. Tell me wh...

#legal #contracts #vendor-management

legal Advanced

Legal: Spot the Clause in This Vendor Contract That's Quietly Costly

Here's a vendor contract: [PASTE]. I'm not asking for a full legal review — I ha...

productivity Intermediate

Productivity: Protect Two Hours of Deep Work in a Calendar Owned by Other People

My calendar is functionally owned by other people: [DESCRIBE — back-to-backs, le...

#productivity #focus #deep-work

#design #accessibility #a11y

design Advanced

Design: Make Our Product Accessible Without Just Adding Alt Text and Calling It Done

We're improving accessibility on [PRODUCT]. The audit will catch missing alt tex...

#excel #data cleaning #dates

Clean up a sheet where dates are stored in five different formats

I inherited a spreadsheet where the 'Date' column has dates entered as '3/5/26',...

Write a VBA macro that does one boring task perfectly instead of ten things badly

I want to automate a small, repetitive Excel task with VBA. The task is: [DESCRI...

#excel #vba #macro

#dates #data cleaning #DATEVALUE

Detect mixed date formats in one column and pick the safest fix

Act as a spreadsheet auditor. I will paste 20 cells from a date column that came...

#cohort #retention #heatmap

Build a Cohort Retention Heatmap Workbook in Excel

Act as a senior analytics engineer. I will paste a list of user signup events wi...

#excel #runway #burn-rate

Build a cash runway calculator that updates from a bank statement paste

I am a founder. I want an Excel sheet where I paste my bank statement export int...

#excel #formulas #xlookup

Write a nested IF that a coworker can actually read

I need an Excel formula that assigns a grade band based on a score, with at leas...

#excel #dropdown #data validation

Build a dynamic dropdown that filters a second dropdown

I want two dependent dropdowns in Excel: pick a Region in cell A2, and the City ...

#excel #data cleaning #deduplicate

excel Beginner

Clean and Deduplicate a Messy Excel Contact List

Act as an Excel data-cleaning specialist. I have a contact list with inconsisten...

Write Nested IF and IFS Formulas for Tiered Commission

Act as an Excel formula expert. I need to calculate sales commission using tiere...

#excel #formulas #ifs

#excel #formulas #commission

Build a Nested IF Formula for Tiered Commission

You are an expert Excel formula engineer. Help me write and explain a single Exc...

#excel #lambda #automation

Write a Reusable LAMBDA Function

You are an expert Excel 365 power user. Help me turn a repetitive calculation in...

#excel #dashboard #pivottable

Build a Dynamic Excel Dashboard Summary

Act as an Excel analyst. I will paste a table of raw data with these columns: [L...

#excel #formulas #xlookup

excel Beginner

Convert a Business Question into an Excel Formula

You are an Excel formula expert. I want to answer this question from my spreadsh...