Leaderboard Ad728 × 90AdSense placeholder — will activate after approval

Search: "Excel report"

385 prompts matching "Excel report"

"Excel report" ✕ Clear all ✕
excel Advanced

Detect duplicate-but-different customer records in an Excel list

I have a 5,000-row customer table. Many are the same company entered slightly di...

#excel #fuzzy-match #deduplication
👁 13 views
excel Advanced

Reverse-engineer a broken Excel formula someone else wrote

I inherited a spreadsheet with a long, nested Excel formula I don't understand a...

#excel #formulas #debugging
👁 13 views
excel Intermediate

Turn a flat sales export into a pivot-ready table

I have a raw sales export with merged headers, blank rows, and totals mixed into...

#excel #pivot table #data cleaning
👁 13 views
excel Beginner

Clean and Deduplicate a Messy Excel Contact List

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

#excel #data cleaning #deduplicate
👁 13 views
excel Intermediate

Build a Dynamic Excel Dashboard Summary

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

#excel #dashboard #pivottable
👁 13 views
hr Intermediate

Run a Skip-Level 1:1 That Surfaces Real Issues

I'm about to do a skip-level 1:1 with [REPORT'S REPORT]. Their direct manager is...

#hr #skip level #1:1
👁 12 views
customer-service Intermediate

Turn a Bug Report from a Frustrated Customer into a Useful Ticket

I'll paste a customer's frustrated bug report (probably long, emotional, missing...

#customer-service #bug report #triage
👁 12 views
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
👁 12 views
excel Intermediate

Excel: Rebuild a Pivot That Lies to Stakeholders

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

#excel #pivot-tables #analysis
👁 12 views
In-feed Ad336 × 280AdSense placeholder — will activate after approval
excel Intermediate

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 #formulas #debugging
👁 12 views
data Intermediate

Data: Build a Weekly Report That Survives Its Author Leaving

Help me design a weekly [TOPIC] report so that if I'm out — or quit — it still g...

#data #reporting #automation
👁 12 views
hr Advanced

Hr: Explain Why Two People With the Same Title Get Paid Differently

Help me write talking points for a manager whose direct report just found out a ...

#hr #compensation #management
👁 12 views
excel Intermediate

Excel: Turn a Pivot Table Into Something an Executive Will Actually Read

I built this pivot table: [PASTE STRUCTURE OR SCREENSHOT DESCRIPTION]. It's accu...

#excel #pivot-tables #executive-reporting
👁 12 views
excel Intermediate

Clean a Messy Excel Customer List Where Names Are in Six Different Formats

I have an Excel sheet with about 4,000 customer records. The Name column is a di...

#excel #data-cleaning #names
👁 12 views
data Intermediate

Clean a messy dataset without losing the rows that actually mattered

I have a dataset with [N] rows and [LIST PROBLEMS: missing values, duplicates, m...

#data #cleaning #preprocessing
👁 12 views
excel Advanced

Replace a fragile nested IF with a clean LET-based formula

Here is a nested IF that has grown to 7 branches and is breaking when someone ad...

#LET function #nested IF #refactor
👁 12 views
excel Advanced

Automate Variance-to-Budget Reporting in Excel with LET and LAMBDA

You are an FP&A automation specialist. I have a monthly actuals sheet and a budg...

#lambda #let #variance
👁 12 views
excel Advanced

Turn a messy CRM CSV export into a clean Excel dashboard

I will paste a CRM export with inconsistent date formats, duplicate accounts und...

#excel #csv #lambda
👁 12 views
hr Advanced

Draft an exit-interview process that yields useful patterns

Our exit interviews currently produce nothing useful — leaving employees stay po...

#hr #exit-interview #attrition
👁 12 views
hr Advanced

Coach a manager who avoids hard conversations until they explode

You are an executive coach. One of my managers consistently avoids giving direct...

#hr #management #feedback
👁 12 views
excel Intermediate

Audit a spreadsheet a predecessor built before you trust a single number

I inherited an Excel model from someone who left. I need to know if I can trust ...

#excel #audit #inherited-model
👁 12 views
excel intermediate

Trace a broken cell reference across a workbook before fixing it blindly

Act as an Excel auditor. A formula on the summary tab is returning #REF! after a...

#excel #auditing #debugging
👁 12 views
excel Beginner

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

#textjoin #reporting #plain-english
👁 12 views
excel Intermediate

Diagnose why my SUMIFS is returning zero

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

#excel #sumifs #debugging
👁 12 views
End-of-content Ad728 × 90AdSense placeholder — will activate after approval