Search: "spill formulas"

Inventory Stock Report

Create an Excel inventory management template with columns: Product ID, Product ...

#excel #inventory #stock

👁 11 views

Nested IF Statements for Grading

Write a nested IF formula in Excel that assigns letter grades based on numeric s...

#excel #IF #nested IF

👁 11 views

#excel #financial report #monthly report

Monthly Financial Report Template

Act as a financial analyst. Create a detailed monthly financial report template ...

#excel #attendance #tracker

Employee Attendance Tracker

Build an Excel attendance tracking spreadsheet for a team of 20 employees. Inclu...

INDEX MATCH as VLOOKUP Alternative

Show me how to use INDEX MATCH in Excel as a more powerful alternative to VLOOKU...

#excel #INDEX #MATCH

#excel #SUMIFS #multiple criteria

SUMIFS with Multiple Criteria

Explain SUMIFS in Excel with 3 practical examples: 1) Sum sales where region is ...

Dynamic Date Formulas

Give me the most useful Excel date formulas for business: 1) Calculate age from ...

#excel #date #DATEDIF

#excel audit #formula debugging #reporting

ChatGPT Prompt for Excel Formula Audit on a Broken Reporting Sheet

Act as an expert Excel analyst. I have a reporting workbook that suddenly shows ...

#data #sales analysis #insights

Text Manipulation Formulas

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

#excel #text #LEFT

👁 9 views

data Intermediate

Analyze Sales Data and Find Insights

Act as a data analyst. I have sales data with columns: Date, Product, Category, ...

👁 9 views

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

👁 9 views

#excel #data cleaning #TRIM

Clean Messy Data Checklist

Give me a complete Excel data cleaning checklist with formulas for each step: 1)...

#expense report #auto-categorization #budget tracking

Expense Report Template with Auto-Categorization

Create a comprehensive Excel expense report template with these features: 1. 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 ...

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

VLOOKUP for Matching Data Between Sheets

Explain how to use VLOOKUP in Excel to match data between two sheets. Scenario: ...

#excel #VLOOKUP #formula

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

productivity Intermediate

Notion Database System for Project and Task Management

Act as a Notion power user and productivity systems designer. Create a complete ...

#productivity #Notion #project management

#excel #xlookup #index match

ChatGPT prompt for fixing broken Excel lookup formulas across multiple sheets

Act as a senior Excel troubleshooting expert. I have a workbook where lookup fo...

#data #csv #data cleaning

data Beginner

ChatGPT prompt for cleaning messy CSV data before analysis

Act as a data analyst helping me prepare a messy CSV file for analysis. I will ...

#excel cash flow forecast #13 week cash flow #excel formulas

excel Advanced

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