Search: "spill formulas"

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

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

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

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

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

#data #Google Sheets #dashboard

data Intermediate

Google Sheets Dashboard with Automated Data Import

Act as a Google Sheets expert. Create a complete marketing dashboard in Google S...

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

Build a Dynamic KPI Dashboard in Excel

Create a dynamic KPI dashboard in Excel for [business/department]. The dashboard...

#excel #dashboard #kpi

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

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

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

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

#scenario model #financial modeling #excel planning

ChatGPT Prompt for Excel Scenario Model Comparing Best Base and Worst Cases

Help me build an Excel scenario model that compares best case, base case, and wo...

#Excel #formulas #automation

Excel Intermediate

Excel Formula Generator

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

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

Excel XLOOKUP Formula for Multi-Criteria Search

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

#excel #xlookup #formula

#finance #cash-flow #forecast

finance advanced

13-Week Rolling Cash Flow Forecast Model Template

You are a CFO advisor and financial modeling expert. I need to build a 13-week r...

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

👁 4 views

#chatgpt prompt for excel tracker #invoice aging #accounts receivable

ChatGPT Prompt for Building an Excel Cash Collection Tracker from Invoices

Act as an expert Excel analyst for accounts receivable. Help me build a cash col...

👁 4 views