Search: "excel-functions"

#excel #data validation #conditional formatting

Design a self-updating Excel tracker with data validation

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

👁 8 views

#excel #charts #data-visualization

Excel: Pick a Chart That Doesn't Need a Caption to Be Understood

I want to show [DESCRIBE COMPARISON OR TREND] to [AUDIENCE]. Tell me the right c...

#pivot tables #dashboard #monthly report

Turn a flat sales export into a one-screen monthly summary

I have a sales export with columns: order_id, date, region, sales_rep, product_c...

#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 #power-query #office-scripts

excel Advanced

Automate a weekly Excel report that pulls from three CSVs and emails itself

You are an automation engineer. I get three CSVs every Monday — [CSV_1], [CSV_2]...

#textjoin #reporting #plain-english

Make a one-cell formula that summarizes a whole row in plain words

You're an Excel helper for non-technical users. I want a single formula that rea...

#excel #dropdown #data validation

excel Advanced

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

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

#data #data-modeling #spreadsheets

data Intermediate

Design a Simple Data Model for My Spreadsheet

You are a spreadsheet/data modeling expert. Help me structure my data so it's cl...

#reconciliation #matching #accounting

Excel: Reconcile Two Lists That Should Match But Don't

I have two lists — one from our accounting system, one from the bank — that shou...

#excel #pivot-tables #reporting

Excel: Build a Pivot Table That Answers the Question Your Boss Actually Asked

I have a dataset and a vague question from leadership. Help me design a pivot ta...

#excel #charts #visualization

Pick the chart that tells the story instead of the chart that's easy to make

I have a dataset and I'm about to default to a bar chart because that's what Exc...

#gantt #project-tracker #dashboard

Create a Self-Updating Excel Project Tracker with Gantt View

Act as a project management consultant. Build me a self-updating Excel project t...

#formulas #validation #helper-column

Build a formula that flags rows where two columns disagree

Act as an Excel expert. I have a spreadsheet where two columns should always agr...

#excel #data cleaning #power query

excel intermediate

Clean Messy Excel Data Step by Step

Act as a data cleaning specialist. My Excel sheet has these issues: [list proble...

#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 #sumifs #debugging

Diagnose why my SUMIFS is returning zero

My SUMIFS formula returns 0 even though I can see matching rows. Ask me to paste...

#excel #debugging #errors

Audit and Fix Broken Excel Formulas

Act as a spreadsheet debugger. I'll paste a formula that returns an error or wro...

#excel #data-validation #dropdown

Build a Dynamic Dropdown Validation Plan

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

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

👁 5 views