Search: "excel 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 #sales report #weekly

Weekly Sales Report with Charts

Create an Excel weekly sales report template that includes: daily sales by produ...

#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

#RFM analysis #customer segmentation #data analysis

data Intermediate

Customer Segmentation Analysis with RFM Model

Help me perform customer segmentation using the RFM (Recency, Frequency, Monetar...

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

Project Budget Tracker

Design an Excel project budget tracker with: budget categories (Labor, Materials...

#excel #budget #project

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

#Excel #analysis #reporting

Excel Intermediate

Data Analysis Report Template

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

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