Search: "Excel analysis"

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 #pivot-table #sales

excel intermediate

Excel Pivot Table Sales Trend Analysis

I have a sales dataset with columns: [Date, Region, Sales Rep, Product, Units So...

customer-service intermediate

Customer Satisfaction Survey Design

Design a customer satisfaction survey for [company/product] measuring satisfacti...

#customer-service #survey #nps

#finance #expense #cost-reduction

finance intermediate

Expense Report Analysis for Cost Reduction

Analyze the following company expense data to identify cost reduction opportunit...

excel Intermediate

Excel XLOOKUP Formula for Multi-Criteria Search

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

#excel #xlookup #formula

coding Intermediate

Python Script to Parse and Analyze CSV Data

Write a Python script that reads a CSV file named "data.csv", performs analysis,...

#coding #python #csv

#pricing strategy #go-to-market #competitive analysis

business advanced

Pricing Strategy Framework New Product Market Entry

Help me develop a pricing strategy for a new [product / service] entering the [m...

#excel #scenario-manager #what-if

excel advanced

Excel Scenario Manager and What-If Analysis Business Planning

You are a financial modeling expert using Excel. I need to build a what-if analy...

#excel #array-formulas #sequence

excel advanced

Excel Dynamic Array Functions SEQUENCE SORT FILTER

You are an Excel expert specializing in modern dynamic array functions. I want t...

customer-service intermediate

Customer Satisfaction Survey Design and Analysis Guide

You are a customer experience researcher. I need to design a customer satisfacti...

#customer-service #survey #nps

#excel #data-validation #dropdown

excel beginner

Excel Data Validation: Drop-down Lists and Input Controls

Act as an Excel data integrity specialist. I need to set up data validation with...

#coding #sql #window-functions

coding advanced

SQL Window Functions: Advanced Analytics Query Guide

Act as a senior data engineer and SQL expert. Help me master SQL window function...

#finance #investment-thesis #venture-capital

finance advanced

Investment Thesis Template for Venture Capital and Angel Investors

Act as a venture capital analyst and investment thesis writer. Help me develop a...

#pivot table #grouping #calculated fields

excel intermediate

Excel Pivot Table: Advanced Grouping and Summarization Techniques

I have a dataset in Excel with the following columns: [list your columns, e.g., ...

#break-even analysis #financial modeling #startup finance

finance intermediate

Break-Even Analysis: Startup Product Calculation Template

Help me calculate and model the break-even analysis for [product/business type]....

#graphql #api #schema-design

coding advanced

GraphQL Schema Design API Query Optimization Best Practices

Build a production-ready GraphQL API with optimal schema design and performance....

#excel #dashboard #visualization

excel intermediate

Excel Dashboard Builder from Raw Data

I have raw data in Excel and want to create a professional dashboard. My data in...

#finance #investing #portfolio

finance intermediate

Investment Portfolio Review and Strategy Guide

Help me review my investment portfolio and develop a strategy. My situation: Ag...

#excel list reconciliation #duplicate matching #near match cleanup

excel Intermediate

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

#launch post mortem #premortem and review #failed launch analysis

business Advanced

ChatGPT prompt for launch post-mortem that turns failure into action items

I need a no-nonsense post-mortem after a launch or rollout that did not go as pl...

#chatgpt prompt for excel planner #capacity planning #workload tracker

ChatGPT Prompt for Creating an Excel Capacity Planner for a Small Team

You are an Excel operations consultant. Build a practical team capacity planner ...

#chatgpt prompt for MRR waterfall #subscription revenue #excel finance model

ChatGPT Prompt for Creating an Excel Subscription Revenue Waterfall

Act as a finance analyst who specializes in subscription businesses. Help me bui...

#excel #cohort analysis #retention

ChatGPT Prompt for Excel Cohort Retention Tracker from Raw Transactions

I have raw transaction data in Excel with columns for customer_id, first_purchas...