Leaderboard Ad728 × 90AdSense placeholder — will activate after approval

Search: "pivot table"

299 prompts matching "pivot table"

"pivot table" ✕ Clear all ✕
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
coding Advanced

Optimize a SQL Query for Speed

You are a database performance engineer. I will paste a slow SQL query and the t...

#coding #sql #database
👁 4 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
coding Advanced

Coding: Write the SQL Index I Actually Need (Not the One I Think I Need)

I have a slow query and I'm about to add an index. Before I do, help me think it...

#coding #sql #performance
👁 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 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
data Advanced

Rewrite a slow correlated subquery as a window function

I have a query with a correlated subquery that runs once per row to find each cu...

#SQL #window functions #query optimization
👁 3 views
writing Advanced

Turn 90 minutes of background interview tape into a 600-word reported piece

You are a magazine editor. I just conducted a 90-minute interview with [SUBJECT]...

#writing #interview #reporting
👁 3 views
In-feed Ad336 × 280AdSense placeholder — will activate after approval
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
data Advanced

Write a SQL query that returns the right answer when the data has duplicates

I'm writing a SQL query against tables [paste schemas, especially the join keys]...

#sql #joins #duplicates
👁 3 views
legal advanced

Read a term sheet for the things they did not put in writing

Act as a startup lawyer who has read thousands of term sheets. Help me read mine...

#legal #term-sheet #startup
👁 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
marketing Intermediate

Find the one message that makes a feature actually matter to buyers

You're a positioning strategist. I will describe a feature or product and tend t...

#positioning #messaging #value-prop
👁 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 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
legal Intermediate

Summarize a Contract into Plain-English Key Terms

You are a contracts analyst who explains legal documents in plain English. I wil...

#legal #contract #summary
👁 3 views
excel Intermediate

Build a Nested IF Formula for Tiered Commission

You are an expert Excel formula engineer. Help me write and explain a single Exc...

#excel #formulas #commission
👁 3 views
business Intermediate

Build a Weighted Decision Matrix

You are an expert decision analyst. Help me choose between options objectively u...

#business #decision-making #matrix
👁 3 views
finance Intermediate

Explain Key Financial Ratios for a Business

You are an expert financial analyst. Help me understand and compute the financia...

#finance #ratios #analysis
👁 3 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
👁 3 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
👁 3 views
email Intermediate

Turn Meeting Notes into a Follow-Up Email

You are a meeting-summary assistant. I will paste rough meeting notes and you wi...

#email #meeting-notes #follow-up
👁 3 views
business Intermediate

Create a Stakeholder Communication Plan

You are a project management coach. Help me build a stakeholder communication pl...

#business #stakeholders #communication
👁 3 views
End-of-content Ad728 × 90AdSense placeholder — will activate after approval