Search: "formulas"

#clean CRM export #sales data cleanup #pipeline analysis

data Intermediate

ChatGPT prompt for cleaning CRM export before sales analysis

Act as a sales operations analyst. I have a messy CRM export that I want to clea...

#budget variance report #excel finance analysis #accounting export cleanup

ChatGPT prompt for monthly budget variance report from exported accounting data

I need help turning exported accounting data into a monthly budget variance repo...

#excel #attendance #leave tracker

ChatGPT prompt for creating an Excel employee attendance and leave tracker

Act as an Excel automation specialist with HR operations experience. Build an e...

#conditional formatting #dashboard #icon sets

excel intermediate

Excel Conditional Formatting Advanced Rules Dashboard

Help me set up advanced conditional formatting rules in Excel for a [sales / HR ...

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

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

#excel #invoice tracking #XLOOKUP

Automated Invoice Tracker with XLOOKUP and Running Balance

Act as an Excel specialist. Build me an invoice tracking spreadsheet with these ...

customer-service Advanced

Customer Feedback Categorization System and Response Workflow

Act as a CX (Customer Experience) operations designer. Build a complete customer...

#customer service #feedback #categorization

#cohort retention analysis #subscription churn #sql retention

data Advanced

ChatGPT prompt for cohort retention analysis from subscription data

You are a product data analyst. I need help analyzing subscription retention by ...

#exam review sheet #study guide prompt #chapter summary

education Beginner

ChatGPT prompt for creating exam review sheet from textbook chapter

Act as a study coach. I will paste a textbook chapter excerpt, lecture notes, or...

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

#education #study guide #practice questions

education Beginner

ChatGPT prompt for creating a study guide with practice questions for any exam topic

Act as an expert tutor and exam preparation specialist. Create a comprehensive ...

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

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

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

#writing #copywriting #sales-page

writing advanced

Long-Form Sales Page Copywriting Framework High-Converting Template

Write a complete framework for creating a high-converting long-form sales page f...

#finance #cash flow #forecast

finance Advanced

Cash Flow Forecast Model Build with Scenario Analysis

Act as an FP&A lead. Walk me through building a 13-week cash flow forecast for a...

#excel inventory tracker #reorder point #stock management

ChatGPT prompt for Excel inventory reorder tracker with lead times

Act as an Excel operations specialist. I need an inventory reorder tracker for a...

#sales commission tracker #tiered commission excel #clawback formula

ChatGPT prompt for Excel sales commission tracker with tiered rates and clawbacks

Act as a sales operations analyst who is great at Excel. I need a commission tra...

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

Excel Beginner

Budget Tracker Spreadsheet

Create a budget tracker Excel structure with: income categories, expense categor...

#Excel #budget #finance

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

#dynamic array #FILTER #SORT

excel intermediate

Excel Dynamic Array FILTER SORT UNIQUE Formula Guide

Teach me how to use Excel dynamic array functions (FILTER, SORT, UNIQUE, SEQUENC...