Leaderboard Ad728 × 90AdSense placeholder — will activate after approval

Search: "Excel report"

385 prompts matching "Excel report"

"Excel report" ✕ Clear all ✕
excel Intermediate

Replace nested IFs with a lookup table you can actually maintain

I have a worksheet with nested IF formulas like: =IF(A1="Bronze",0.05,IF(A1="Sil...

#excel #formulas #xlookup
👁 17 views
excel Intermediate

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 #pivot-table #data-cleanup
👁 17 views
hr Advanced

Have a 'you're underperforming' conversation without making it a surprise

I need to have a conversation with a direct report about underperformance. The p...

#hr #performance-management #difficult-conversations
👁 17 views
excel Advanced

Excel Power Query Recipe to Clean and Unify Multi-Sheet Sales Data

You are an Excel Power Query expert. I have a workbook with 12 monthly sales she...

#power-query #m-language #etl
👁 17 views
excel Advanced

Create a Dynamic Dashboard with Slicers and PivotTables

You are an Excel dashboard designer. Guide me through building an interactive sa...

#excel #dashboard #pivottable
👁 17 views
excel Intermediate

Expense Report Template with Auto-Categorization

Create a comprehensive Excel expense report template with these features: 1. In...

#expense report #auto-categorization #budget tracking
👁 16 views
data Advanced

Automated Data Quality Report with Anomaly Detection

Create a data quality monitoring report for my dataset: - Data source: [e.g., '...

#data quality #anomaly detection #data monitoring
👁 16 views
excel Intermediate

ChatGPT Prompt for Building an Excel Cash Collection Tracker from Invoices

Act as an expert Excel analyst for accounts receivable. Help me build a cash col...

#chatgpt prompt for excel tracker #invoice aging #accounts receivable
👁 16 views
customer-service intermediate

NPS Survey Follow-Up Email Sequence Detractor Promoter Templates

Write a complete NPS follow-up communication system that closes the loop with al...

#customer-service #nps #retention
👁 16 views
In-feed Ad336 × 280AdSense placeholder — will activate after approval
coding Intermediate

ChatGPT Prompt: Bug Reproduction and Minimal Repro Case Builder

You are a debugging coach. Help me build a minimal reproducible example for a bu...

#coding #debugging #bug-report
👁 16 views
excel Beginner

Excel Conditional Formatting Rule to Highlight Aging Invoices

Help me build a conditional formatting rule for an invoices sheet so each row hi...

#excel #conditional-formatting #accounts-receivable
👁 16 views
customer-service Advanced

Voice-of-Customer Synthesis From 50 Recent Support Tickets

Synthesize 50 recent support tickets I'll paste into a voice-of-customer report....

#customer-service #voc #product-feedback
👁 16 views
hr Intermediate

30-60-90 Day Onboarding Plan for a New Manager

Build a 30-60-90 day onboarding plan for a new people manager joining a 6-person...

#hr #onboarding #new-manager
👁 16 views
excel Beginner

Generate Realistic Test Data With Random Functions

I need to generate {{number, e.g., 500}} rows of realistic test data in Excel fo...

#excel #test-data #random
👁 16 views
excel Advanced

Forecast Monthly Revenue with Seasonality Using FORECAST.ETS

Act as a financial analyst. I have 36 months of revenue history. Show me how to ...

#excel #forecasting #ets
👁 16 views
excel Intermediate

Convert Messy Excel Date Formats to Standardized ISO

I have a column of dates in Excel with inconsistent formats: '03/15/2024', '15-M...

#dates #iso #data cleaning
👁 16 views
excel Intermediate

Reconcile Bank Statements with Ledger in Excel

I have two Excel sheets: my bank statement transactions and my internal accounti...

#excel #reconciliation #bank
👁 16 views
excel Intermediate

Convert a Messy Survey Export Into Clean Long-Format Data

I exported a survey to Excel. Each respondent is one row, each question is its o...

#excel #power query #survey
👁 16 views
excel Intermediate

Excel: Untangle a Column Where Multiple Fields Got Stuffed Into One

I have one column containing several fields concatenated together (name, email, ...

#excel #data-cleaning #power-query
👁 16 views
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 #charts #visualization
👁 16 views
excel Intermediate

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

#excel #formulas #running-total
👁 16 views
hr Advanced

Give a Performance Review to a Solid But Not Spectacular Employee

I have a direct report whose review I keep procrastinating. They're not bad — th...

#hr #performance-review #management
👁 16 views
excel Intermediate

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

#excel #data cleaning #dates
👁 16 views
excel Advanced

Reconcile two messy spreadsheets when the join keys don't match

I have two Excel files I need to reconcile, but the join columns aren't clean ma...

#excel #power-query #reconciliation
👁 16 views
End-of-content Ad728 × 90AdSense placeholder — will activate after approval