Search: Excel report — AI Prompts

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

#excel #formulas #xlookup

👁 10 views

excel Advanced

Plan an Excel Macro or Office Script

You are an Excel automation expert. I will describe a repetitive task and you wi...

#excel #automation #vba

👁 10 views

excel Intermediate

Build a Dynamic Dropdown Validation Plan

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

#excel #data-validation #dropdown

👁 10 views

excel Intermediate

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 #headcount #hiring

👁 9 views

design Advanced

Design System Component Audit Checklist

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

#design #design-system #audit

👁 9 views

excel Intermediate

Excel: Detect Duplicate Rows Across Multiple Key Columns

I have an Excel sheet where 'duplicates' aren't exact matches — they share a cus...

#duplicates #dedupe #power-query

👁 9 views

excel Intermediate

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

#reconciliation #matching #accounting

👁 9 views

excel Beginner

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

#excel #charts #visualization

👁 9 views

excel Intermediate

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

#dates #data cleaning #DATEVALUE

👁 9 views

excel Intermediate

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

#formulas #validation #helper-column

👁 9 views

excel Intermediate

Turn a messy exported report into a clean pivot-ready table

You're an Excel power user. I pasted in an export from another system and it's a...

#power-query #data-cleaning #pivot

👁 9 views

excel Intermediate

Write a lookup that survives someone reordering the columns

Act as an Excel expert. My VLOOKUPs keep breaking because colleagues insert and ...

#xlookup #index-match #robust

👁 9 views

excel Intermediate

Clean Messy Spreadsheet Data Step by Step

You are a data-cleaning specialist. I have a messy Excel sheet with these proble...

#excel #power-query #data-cleaning

👁 9 views

excel Intermediate

Design a Pivot Table Reporting Plan

You are an Excel reporting consultant. Based on the dataset I describe, design t...

#excel #pivot-table #reporting

👁 9 views

excel Advanced

Diagnose a Slow Excel Workbook

You are an Excel performance consultant. I will describe my workbook's symptoms ...

#excel #performance #optimization

👁 9 views

customer-service Intermediate

Customer Service: Spot When a 'Bug Report' Is Actually a UX Problem

Read this customer support ticket and tell me whether the customer's described '...

#bug-triage #ux #support

👁 8 views

excel Intermediate

Reconcile two versions of a budget when the row labels don't match

You are an Excel modeler. I'll paste two budget extracts from different teams. T...

#reconciliation #budget #fuzzy-match

👁 8 views

excel Advanced

Build a flexible scenario model without nesting IF statements ten layers deep

Act as a financial modeler reviewing my workbook. I have a model that runs base/...

#scenarios #modeling #choose

👁 8 views

excel Intermediate

Build an Excel formula that flags duplicates across multiple columns

In Excel I need to find rows that are duplicates based on a *combination* of col...

#excel #duplicates #countifs

👁 8 views

excel Advanced

Write a Reusable LAMBDA Function

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

#excel #lambda #automation

👁 8 views

excel Beginner

Reconcile Two Excel Lists for Differences

You are an Excel reconciliation helper. I have two lists (for example, a system ...

#excel #reconciliation #vlookup

👁 8 views

excel Intermediate

Diagnose Why a Pivot Table Is Showing the Wrong Totals

Help me diagnose why my Excel pivot table is showing wrong totals. Source data r...

#pivot-table #debugging #totals

👁 7 views

excel Beginner

Clean Messy Imported Data with Formulas

You are an expert Excel data-cleaning specialist. Help me clean a messy column o...

#excel #data-cleaning #trim

👁 7 views

excel Intermediate

Build a Dynamic Array Dashboard Formula

You are an Excel power user. I will describe a dataset and a reporting goal, and...

#excel #formulas #dynamic-arrays

👁 7 views

Search: "Excel report"

Convert a Business Question into an Excel Formula

Plan an Excel Macro or Office Script

Build a Dynamic Dropdown Validation Plan

Build a Headcount Plan Spreadsheet with Hiring Ramp

Design System Component Audit Checklist

Excel: Detect Duplicate Rows Across Multiple Key Columns

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

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

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

Build a formula that flags rows where two columns disagree

Turn a messy exported report into a clean pivot-ready table

Write a lookup that survives someone reordering the columns

Clean Messy Spreadsheet Data Step by Step

Design a Pivot Table Reporting Plan

Diagnose a Slow Excel Workbook

Customer Service: Spot When a 'Bug Report' Is Actually a UX Problem

Reconcile two versions of a budget when the row labels don't match

Build a flexible scenario model without nesting IF statements ten layers deep

Build an Excel formula that flags duplicates across multiple columns

Write a Reusable LAMBDA Function

Reconcile Two Excel Lists for Differences

Diagnose Why a Pivot Table Is Showing the Wrong Totals

Clean Messy Imported Data with Formulas

Build a Dynamic Array Dashboard Formula