Search: "Excel analysis"

design Intermediate

Mobile UX Wireframe Brief with User Flow Notes

You are a senior mobile UX designer. I will describe a feature. Produce a wirefr...

#design #ux #wireframe

#business #swot #strategy

business Intermediate

SWOT Analysis With Quantified Likelihood and Impact Scoring

Run a SWOT analysis for [COMPANY/PRODUCT]. For every entry under each quadrant, ...

#business #pricing #competitive-analysis

business Advanced

Competitive Pricing Analysis With Value-Based Justification

Build a competitive pricing analysis for [PRODUCT] against [LIST 3-5 COMPETITORS...

#data #sql #cohort-analysis

data Advanced

Cohort Retention Analysis SQL Query With Visualization Stub

Write a SQL query that produces a monthly cohort retention table for [SaaS PRODU...

data Advanced

SQL Window Function to Find Customer Churn Cohort by First-Purchase Month

Write a Postgres query to produce a monthly cohort retention table. Source table...

#data #sql #postgres

#excel #text-functions #parsing

Convert Messy Text Column Into Clean Structured Fields

I have a single column in Excel containing messy entries like "{{example raw ent...

#business #strategy #swot

business Intermediate

SWOT Analysis with Quantified Evidence

Act as a strategy consultant. Create a SWOT analysis for [COMPANY_NAME] competin...

Auto-Format New Data VBA

Write a VBA macro that automatically formats any new data pasted into an Excel s...

#excel #VBA #macro

#power query #CSV import #data transformation

Power Query: Merge and Transform Multiple CSV Files

I have a folder containing monthly CSV files (January.csv, February.csv, etc.) w...

#excel #shift schedule #data validation

Dynamic Employee Shift Schedule with Drop-downs and Conflict Detection

Act as an Excel expert. Create a weekly employee shift schedule spreadsheet for ...

#education #rubric #grading

education Beginner

Rubric Generator for Any Assignment Type

Act as an experienced educator. Create a detailed grading rubric for a [assignme...

#customer interview guide #user research prompt #discovery interview

business Advanced

ChatGPT prompt for drafting customer research interview guide

You are a product researcher. Help me create a customer research interview guide...

#excel list reconciliation #duplicate matching #near match cleanup

ChatGPT prompt for reconciling two Excel lists with duplicates and near matches

I need to reconcile two Excel lists that should overlap, but the data is messy. ...

#excel #cash flow #forecast

ChatGPT Prompt for Excel Monthly Cash Flow Forecast with Collections Delay

I need a monthly cash flow forecast in Excel for a business with uneven customer...

#excel #scheduling #shift planning

excel Beginner

ChatGPT Prompt for Excel Shift Schedule Conflict Checker

Help me build an Excel shift scheduling sheet that automatically flags staffing ...

#tutoring #error analysis #guided questions

education Intermediate

ChatGPT Prompt for Explaining a Mistake Without Giving Away the Answer

Help me tutor a student by explaining their mistake clearly without immediately ...

#Excel #formulas #automation

Excel Intermediate

Excel Formula Generator

Create Excel formulas for: [DESCRIBE TASK]. Include: the formula, explanation of...

#data cleaning #csv #pandas

data Intermediate

ChatGPT prompt for creating a data cleaning pipeline for messy CSV files

Act as a senior data engineer who specializes in data quality and ETL pipelines....

ChatGPT prompt for creating Excel macros to automate repetitive report formatting

Act as an Excel VBA developer who writes clean, maintainable macros. Create VBA...

#excel #vba #macros

Excel XLOOKUP Formula for Multi-Criteria Search

Help me write an Excel XLOOKUP formula that searches across multiple criteria. M...

#excel #xlookup #formula

#budget analysis #variance #financial template

excel intermediate

Excel Budget vs Actual Variance Analysis Template

Create a complete Excel budget vs. actual variance analysis template for [depart...

#pandas #EDA #data analysis

data intermediate

Python Pandas Data Analysis Pipeline Exploratory Analysis

Write a Python data analysis script using Pandas for exploratory data analysis (...

excel advanced

Excel VBA Macro Automation for Repetitive Reports

Write a VBA macro for Excel that automates the following repetitive reporting ta...

#vba #macro #automation