Search: "spill formulas"

#SaaS metrics #financial model #unit economics

finance Advanced

Financial Model Template for SaaS Business Unit Economics

Build a financial model framework for a SaaS business covering unit economics an...

#xlookup #excel formulas #index match

Excel XLOOKUP Multi-Criteria Lookup Replacing INDEX-MATCH

Act as an Excel formula expert. Help me replace nested INDEX-MATCH and VLOOKUP f...

#cash flow #forecasting #cfo

finance Advanced

Cash Flow Forecast 13-Week Rolling Model Small Business

You are a fractional CFO. Build a 13-week rolling cash flow forecast for [BUSINE...

excel Beginner

ChatGPT Prompt: Excel SUMIFS Formula Builder for Multi-Condition Aggregation

You are an Excel formula expert. I need to build a SUMIFS formula that totals va...

#excel #sumifs #formulas

#pivot tables #excel #data analysis

ChatGPT Prompt: Excel Pivot Table with Calculated Fields and Slicers Setup

Help me build a comprehensive pivot table report for [DATA TYPE]. Data context:...

Executive KPI Dashboard Template Build in Excel

Design a one-page executive KPI dashboard in Excel for a [INDUSTRY] company. The...

#excel #dashboard #kpi

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

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

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

#Power BI #DAX #dashboard

data advanced

Power BI Dashboard Design Executive Sales Report

Help me design a Power BI executive sales dashboard. Data sources: [CRM data / S...

#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 tracker #personal finance #Excel template

excel Beginner

Excel Personal Budget Tracker: Monthly and Annual Template

Help me build a comprehensive personal budget tracker in Excel from scratch. I n...

#excel #lambda #custom-functions

excel advanced

Excel LAMBDA Function Custom Formula Library Creation Guide

Design a library of reusable custom Excel functions using the LAMBDA function fo...

#writing #linkedin #thought-leadership

writing intermediate

LinkedIn Thought Leadership Post Writing Framework and Templates

Create a complete LinkedIn thought leadership content system for executives and ...

Excel VBA Macro to Automate Repetitive Report Formatting

Write an Excel VBA macro that automates the formatting of a weekly report I rece...

#VBA #macro #automation

#excel #conditional formatting #dashboard

Excel Conditional Formatting Heatmap Project Status Dashboard

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

#concept-map #study #visualization

education Beginner

Concept Map Builder for Difficult Topic

Act as a learning coach. Help me build a concept map for [TOPIC]. Produce: (1) t...

#sql #optimization #performance

data Advanced

SQL Query Optimizer with Explain-Plan Reading

Act as a database performance engineer. I will paste a slow SQL query and its EX...

#ab-test #power-analysis #experimentation

data Advanced

A/B Test Power Analysis Pre-Launch Check

Act as an experimentation statistician. Before launching an A/B test on [METRIC]...

#excel formulas #dynamic arrays #dashboard

ChatGPT Prompt: Excel Dynamic Array Formulas for Reporting Dashboards

Build a reporting dashboard using Excel 365 dynamic array formulas (FILTER, SORT...

#excel #index match #formula

INDEX/MATCH Formula Generator with Dynamic Multi-Criteria Lookup

You are an Excel formula expert. Help me write an INDEX/MATCH formula that retur...