Leaderboard Ad728 × 90AdSense placeholder — will activate after approval

Search: "Excel analysis"

534 prompts matching "Excel analysis"

"Excel analysis" ✕ Clear all ✕
excel Intermediate

Audit and Fix Broken Excel Formulas

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

#excel #debugging #errors
👁 4 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
👁 4 views
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...

#data #data-modeling #spreadsheets
👁 4 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
👁 4 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
👁 3 views
excel Beginner

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 #pivot-tables #reporting
👁 3 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
👁 3 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
👁 3 views
excel Advanced

Write a VBA macro that does one boring task perfectly instead of ten things badly

I want to automate a small, repetitive Excel task with VBA. The task is: [DESCRI...

#excel #vba #macro
👁 3 views
In-feed Ad336 × 280AdSense placeholder — will activate after approval
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
👁 3 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
👁 3 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
👁 3 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
👁 3 views
data Intermediate

Sanity-check a dataset in 30 minutes before you build anything on top of it

I just got handed a dataset I'm going to use for [analysis / model / dashboard]....

#data #sanity-check #eda
👁 3 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
👁 3 views
coding Intermediate

Untangle a circular import that the codebase has been living with for years

Act as a refactoring lead. There's a circular import between two modules that th...

#refactoring #imports #modules
👁 3 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
👁 3 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
👁 3 views
business beginner

Conduct a SWOT Analysis

Act as a business strategist. Perform a detailed SWOT analysis for [company or p...

#business #swot #analysis
👁 3 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
👁 3 views
excel Intermediate

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 #formulas #xlookup
👁 3 views
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 ...

#excel #dropdown #data validation
👁 3 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
👁 3 views
excel Intermediate

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
👁 3 views
End-of-content Ad728 × 90AdSense placeholder — will activate after approval