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

Text Manipulation Formulas

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

#excel #text #LEFT

#excel #data cleaning #TRIM

Clean Messy Data Checklist

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

#data #sales analysis #insights

data Intermediate

Analyze Sales Data and Find Insights

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

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

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

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

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

#finance #cash flow #forecast

finance Intermediate

Cash Flow Forecast for Small Business (12-Month)

Create a 12-month cash flow forecast template for a [business type] with the fol...

VLOOKUP for Matching Data Between Sheets

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

#excel #VLOOKUP #formula

#invoice #VBA #automation

excel Advanced

Invoice Generator with Auto-Numbering VBA

Create an Excel invoice generator with automatic invoice numbering using VBA. B...

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 #cash flow #dashboard

ChatGPT prompt for building a monthly Excel cash flow dashboard from messy exports

I want you to act as an Excel financial analyst. My goal: turn messy bank and e...