Search: "pivot"

#excel #pivot table #sales analysis

Pivot Table Mastery for Multi-Year Sales Data Analysis

Act as an Excel data analyst. I will paste a sales dataset with columns Date, Re...

👁 11 views

#excel #dashboard #slicers

Excel Dashboard with Dynamic Slicers

Help me design a single-page Excel dashboard for KPIs (revenue, orders, conversi...

👁 11 views

#excel #dashboard #index-match

Build a Dynamic Dashboard Using INDEX-MATCH and Slicers

Act as an Excel power user. I have a sales dataset with columns: Date, Region, P...

👁 10 views

#excel #pivot-table #calculated-field

ChatGPT Prompt: Excel Pivot Table Calculated Field for Custom Metrics

You are an Excel pivot table expert. Help me add a calculated field to my pivot ...

#pivot tables #excel #data analysis

ChatGPT Prompt: Excel Pivot Table with Calculated Fields and Slicers Setup

Help me build a comprehensive pivot table report for [DATA TYPE]. Data context:...

#excel #pivot-table #calculated-field

Excel Pivot Table Calculated Field for Margin Percentage by Segment

I have a sales table with columns: order_id, date, customer_segment, product, re...

#excel #pivot tables #data cleaning

Convert Messy Sales Data into a Pivot Table Report

You are an Excel expert. I will paste a messy sales dataset with columns for dat...

#excel #power-query #unpivot

Turn a wide budget sheet into a flexible pivot-ready long format

I have a budget spreadsheet in wide format: one row per account, then 12 columns...

#power-query #csv #data-cleaning

Convert a Messy CSV Export Into a Clean Excel Table

Help me clean a messy CSV export from [SYSTEM NAME] and turn it into an Excel Ta...

👁 6 views

#excel #formulas #running-total

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

👁 6 views

#excel #pivot-table #data-cleanup

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

👁 6 views

writing Intermediate

Find the One Sentence Doing All the Work in Your Draft

Here's a draft I'm editing: [paste draft, 500-1500 words]. Help me find the sent...

#writing #editing #revision

#excel #pivot-tables #executive-reporting

Excel: Turn a Pivot Table Into Something an Executive Will Actually Read

I built this pivot table: [PASTE STRUCTURE OR SCREENSHOT DESCRIPTION]. It's accu...

#writing #structure #essay

writing Advanced

Restructure an essay that has a great middle but a weak opening and ending

I have an essay where paragraphs 4-8 are doing real work but the opening (paragr...

#pivot tables #dashboard #monthly report

excel Beginner

Turn a flat sales export into a one-screen monthly summary

I have a sales export with columns: order_id, date, region, sales_rep, product_c...

excel Advanced

Turn a messy CRM CSV export into a clean Excel dashboard

I will paste a CRM export with inconsistent date formats, duplicate accounts und...

#excel #csv #lambda

#excel #power-query #office-scripts

excel Advanced

Automate a weekly Excel report that pulls from three CSVs and emails itself

You are an automation engineer. I get three CSVs every Monday — [CSV_1], [CSV_2]...

#marketing #content #pillar-content

marketing Advanced

Pick one piece of content to nurture into 50% of inbound for the quarter

You are a content strategist. Instead of publishing 12 mediocre posts this quart...

#excel #dashboard #slicers

excel intermediate

Build a Dynamic Excel Dashboard with Slicers

Act as an Excel expert. Guide me through building a dynamic dashboard for [datas...

#excel #pivot table #data cleaning

Turn a flat sales export into a pivot-ready table

I have a raw sales export with merged headers, blank rows, and totals mixed into...