Search: "spill formulas"

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

#data #looker-studio #dashboard

data intermediate

Google Looker Studio Dashboard Design for Business Intelligence

You are a BI analyst and data visualization expert. I need to build a profession...

Excel SUMIF & COUNTIF: Advanced Multi-Criteria Formula Guide

Act as an Excel formula expert. I want to master SUMIF, SUMIFS, COUNTIF, and COU...

#excel #sumif #countif

#dynamic arrays #FILTER #SORT

Excel Dynamic Arrays: FILTER, SORT, and UNIQUE Functions Mastery

Help me master Excel dynamic array functions to replace my manual filtering and ...

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

#Gantt chart #project management #Excel timeline

Excel Gantt Chart: Project Timeline and Milestone Tracker

I want to build a professional Gantt chart in Excel for project management witho...

#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

excel Advanced

ChatGPT Prompt for Creating an Excel Subscription Revenue Waterfall

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

#excel #vlookup #index-match

excel beginner

VLOOKUP vs INDEX-MATCH: Smart Data Lookup Formulas

I need to retrieve data from a lookup table in Excel. My main table has [column ...

#dynamic array #FILTER #SORT

Excel Dynamic Array FILTER SORT UNIQUE Formula Guide

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

#budget analysis #variance #financial template

Excel Budget vs Actual Variance Analysis Template

Create a complete Excel budget vs. actual variance analysis template for [depart...

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

#XLOOKUP #INDEX MATCH #multi-criteria lookup

excel advanced

Excel XLOOKUP Multi-Condition: Advanced Lookup Formulas Guide

I need to look up values in Excel using multiple conditions. My dataset has colu...

#scenario manager #goal seek #sensitivity analysis

excel advanced

Excel Financial Modeling: Scenario Manager and Goal Seek Analysis

I'm building a financial model in Excel for [project/business type]. Help me set...

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

#email marketing #A/B testing #subject lines

marketing Intermediate

Email Marketing A/B Testing: Subject Line Optimization Guide

Help me design and run effective A/B tests for my email marketing campaigns. I n...

#excel #dashboard #visualization

Excel Dashboard Builder from Raw Data

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

#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 #cohort analysis #retention

excel Advanced

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 Dashboard for KPI Tracking

Create an Excel dashboard template for tracking key performance indicators (KPIs...

#excel #kpi #dashboard

#conditional formatting #dashboard #icon sets

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

#kpi #scorecard #dashboard

Excel Dashboard KPI Scorecard with Traffic Lights

Design an Excel KPI scorecard dashboard for [department] with: 1) KPI table with...