Search: "excel-fix"

Text Manipulation Formulas

Show me essential Excel text formulas with examples: 1) Extract first name from ...

#excel #text #LEFT

#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 #inventory #tracker

ChatGPT prompt for creating an Excel inventory tracker with automatic reorder alerts

Act as an Excel inventory management specialist. I need to build an inventory t...

#excel #audit #inherited-work

Excel: Audit a Spreadsheet I Inherited Before I Trust Its Numbers

I just inherited this workbook from someone who left: [DESCRIBE TABS, KEY OUTPUT...

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

👁 28 views

#excel #conditional formatting #dashboard

Excel Conditional Formatting Heatmap Project Status Dashboard

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

👁 28 views

#excel #dashboard #charts

Professional Dashboard with Charts

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

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

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

#budget analysis #variance #financial template

Excel Budget vs Actual Variance Analysis Template

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

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

#financial-model #three-statement #excel

excel advanced

Excel Financial Model Three-Statement Integration

Build a three-statement financial model in Excel for [company type, e.g., a SaaS...

#excel #conditional-formatting #kpi

Excel Conditional Formatting Rules for KPI Dashboard Indicators

Create a complete system of Excel conditional formatting rules to build a profes...

#excel #pivot table #sales analysis

Sales Analysis Pivot Table

Guide me step by step to create a pivot table in Excel for sales analysis. My da...

#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 #analysis #reporting

Excel Intermediate

Data Analysis Report Template

Design a data analysis report template in Excel for [DATA TYPE]. Include: execut...

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

Auto-Send Email Report VBA

Write an Excel VBA macro that: 1) Takes data from the active sheet, 2) Creates a...

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

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