Search: "Excel analysis"

#excel #conditional formatting #dashboard

Excel Conditional Formatting Heatmap Project Status Dashboard

You are an Excel dashboard designer. Build a conditional-formatting heatmap for ...

👁 22 views

ChatGPT Prompt: Excel Macro VBA Generator for Repetitive Data Cleanup Tasks

You are a VBA developer. I want a macro that automates a repetitive cleanup task...

#excel #vba #macro

👁 22 views

#excel #dashboard #charts

Professional Dashboard with Charts

Create instructions for building a professional Excel dashboard with these chart...

Excel Macro to Split One Sheet into Multiple Files by Column Value

Write a VBA macro for Excel that takes a master spreadsheet and splits it into s...

#excel #VBA #macro

#excel cash flow forecast #13 week cash flow #excel formulas

ChatGPT prompt for Excel cash flow forecast from messy exports

You are an Excel analyst helping me build a 13-week cash flow forecast from mess...

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

#chatgpt prompt for survey analysis #theme clustering #qualitative research

data Intermediate

ChatGPT Prompt for Analyzing Form Survey Responses into Themes and Actions

You are a research analyst. Analyze open text survey responses and turn them int...

#education #curriculum #learning-objectives

education advanced

Curriculum Design with Learning Objectives

Design a curriculum for [course topic] targeted at [learner level: beginner / in...

#finance #financial-model #startup

finance advanced

Financial Model for Startup Revenue Projections

Build a 3-year financial model for a [business type — SaaS / e-commerce / market...

#lambda #custom-functions #excel

excel advanced

Excel LAMBDA Custom Functions for Business Calculations

Create Excel LAMBDA functions for: 1) CAGR given start value, end value, and yea...

#financial-model #seed-round #fundraising

finance advanced

Startup Fundraising Financial Model for Seed Round

Build a financial model for a seed-stage fundraise for [startup type]. Cover: 1)...

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

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

#XLOOKUP #VLOOKUP #Excel formulas

Excel VLOOKUP to XLOOKUP Migration: Formula Modernization Guide

I have existing Excel spreadsheets that use VLOOKUP formulas and I want to moder...

#audit-trail #change-tracking #version-history

excel intermediate

Excel Audit Trail & Change Tracking for Collaborative Workbooks

I need to set up audit trails and change tracking in Excel for a shared workbook...

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

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

#conditional formatting #KPI #dashboard

Conditional Formatting Rules for KPI Dashboards

I need to set up conditional formatting in Excel for a KPI dashboard. My spreads...

#market entry #expansion strategy #international business

business Advanced

Market Entry Strategy for New Geographic Region

Develop a market entry strategy for expanding into a new geographic region: - C...

#competitor pricing analysis #positioning strategy #pricing comparison

business Advanced

ChatGPT prompt for competitor pricing analysis and positioning summary

You are a product marketing strategist. I will paste competitor pricing pages, p...

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