Leaderboard Ad728 × 90AdSense placeholder — will activate after approval

Search: "Excel analysis"

534 prompts matching "Excel analysis"

"Excel analysis" ✕ Clear all ✕
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
👁 5 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
👁 5 views
excel Advanced

Build a Cohort Retention Heatmap Workbook in Excel

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

#cohort #retention #heatmap
👁 5 views
productivity Intermediate

Plan a week when last week's plan completely fell apart

Act as a productivity coach. Last week was a mess — fires, an unexpected illness...

#productivity #weekly-planning #triage
👁 5 views
finance Advanced

Decide whether a customer is profitable at the unit level or just at the revenue level

Act as a finance partner. I have a customer who is large and high-revenue. The C...

#unit-economics #profitability #customer-pl
👁 5 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
👁 5 views
data Intermediate

Choose the right join before I merge two datasets

I have two tables I want to combine and I'll describe the key columns and what e...

#data #joins #sql
👁 5 views
writing Intermediate

Generate an SEO-Friendly Blog Outline from a Keyword

Act as an SEO content strategist. Given a target keyword that I provide, produce...

#writing #seo #blog
👁 5 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
👁 5 views
In-feed Ad336 × 280AdSense placeholder — will activate after approval
excel Intermediate

Design a Pivot Table for Monthly Sales Analysis

You are an expert Excel reporting analyst. Guide me through building a pivot tab...

#excel #pivot-table #sales
👁 5 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
👁 5 views
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
👁 5 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
👁 5 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
👁 5 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
👁 5 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
👁 5 views
finance Advanced

Explain a Financial Statement

You are a financial analyst. I will share figures from a financial statement and...

#finance #financial-statements #analysis
👁 5 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
👁 4 views
hr advanced

Decide which roles to backfill, restructure, or eliminate after an attrition spike

Act as a workforce planner. Three people left a team of twelve in one quarter, a...

#hr #workforce-planning #attrition
👁 4 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
👁 4 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
👁 4 views
excel Intermediate

Find which formula in a 12-tab workbook is wrong without checking every cell

You're an Excel auditor. A summary total on my Dashboard tab is off by $4,200 fr...

#debugging #audit #trace-precedents
👁 4 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
👁 4 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
👁 4 views
End-of-content Ad728 × 90AdSense placeholder — will activate after approval