Search: "Excel analysis"

Excel VBA Macro to Automate Repetitive Report Formatting

Write an Excel VBA macro that automates the formatting of a weekly report I rece...

#VBA #macro #automation

#net-worth #personal-finance #balance-sheet

finance Beginner

Personal Net Worth Statement Template

Act as a personal finance planner. Build me a structured net worth statement tem...

customer-service Intermediate

CSAT Survey Question Bank with Open-End Triggers

Act as a VoC research lead. Design a post-resolution CSAT survey for [CHANNEL] (...

#csat #survey #vox

#net worth #personal finance #financial tracking

finance Beginner

ChatGPT Prompt: Personal Net Worth Statement Builder with Trend Analysis

Help me build a personal net worth statement and track changes over time. Here's...

Excel Power Query to Consolidate Monthly Sales Files in a Folder

Generate Power Query M code that consolidates all .xlsx files in a folder into a...

#excel #power-query #etl

#cash flow #personal finance #budgeting

finance Intermediate

Personal Cash Flow Forecast for Next 12 Months

Build a 12-month personal cash flow forecast. Inputs: - Monthly net income: [AMO...

#excel #reconciliation #fuzzy match

Reconcile Two Bank Statements with Fuzzy Matching in Excel

I have two sheets: 'Bank' with columns Date, Description, Amount and 'Books' wit...

#excel #power query #survey

Convert a Messy Survey Export Into Clean Long-Format Data

I exported a survey to Excel. Each respondent is one row, each question is its o...

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

customer-service Intermediate

Triage a Pile of Support Tickets Into 'Fix Now', 'Pattern', and 'One Off'

Help me triage this pile of support tickets into 3 buckets: 'fix now', 'systemic...

#triage #ticket-analysis #support-operations

#data #communication #slack

data Beginner

Write a Slack Update About a Metric Movement Without Hand-Waving

I need to post a Slack update about [metric name] moving [direction and magnitud...

#excel #commission #sales

Excel Sales Commission Tiered Calculator

Create an Excel formula that calculates sales commission using tiered rates: 5% ...

#excel #variance-analysis #budget

Excel Variance Analysis Budget vs Actual

Build an Excel variance analysis report comparing Budget vs Actual for revenue a...

#excel #data-cleaning #power-query

Excel: Untangle a Column Where Multiple Fields Got Stuffed Into One

I have one column containing several fields concatenated together (name, email, ...

#data #statistics #ab-testing

data Intermediate

Data: Decide Whether a Difference in Two Numbers Is Real or Noise

I have two numbers (a metric this period vs last period) and a stakeholder askin...

#data #analysis #debugging

data Advanced

Data: Investigate a Metric That Suddenly Moved Without Obvious Cause

A metric jumped (or dropped) and nobody knows why. Give me a structured investig...

#data #analysis #statistics

data Advanced

Data: Stop a Stakeholder From Acting on a Spurious Correlation

A [ROLE] just sent me [CHART/CLAIM] showing [X correlates with Y] and they're ab...

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

#excel #dashboard #formulas

Build a self-updating sales dashboard using only formulas (no PivotTables)

I want to build a sales dashboard in Excel that updates automatically when I pas...

#excel #pivot tables #reporting

Turn a messy operational export into a pivot table that someone will actually read

I have an operational export with [N] rows and columns like [DATE, REGION, PRODU...

#excel #cash flow #forecast

Build a Rolling 12-Month Cash Flow Forecast in Excel

You are an Excel financial modeling expert. Help me build a rolling 12-month cas...

#excel #dashboard #pivottable

Create a Dynamic Dashboard with Slicers and PivotTables

You are an Excel dashboard designer. Guide me through building an interactive sa...

marketing Intermediate

Plan SEO Content Around a Keyword

You are an expert SEO content strategist. Help me plan content that can actually...

#marketing #seo #content