Leaderboard Ad728 × 90AdSense placeholder — will activate after approval

Search: "excel inventory tracker"

102 prompts matching "excel inventory tracker"

"excel inventory tracker" ✕ Clear all ✕
excel Advanced

Auto-Format New Data VBA

Write a VBA macro that automatically formats any new data pasted into an Excel s...

#excel #VBA #macro
👁 7 views
excel Advanced

Invoice Generator with Auto-Numbering VBA

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

#invoice #VBA #automation
👁 7 views
excel Advanced

Excel Macro to Split One Sheet into Multiple Files by Column Value

Write a VBA macro for Excel that takes a master spreadsheet and splits it into s...

#excel #VBA #macro
👁 7 views
excel Intermediate

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

#excel #cash flow #dashboard
👁 7 views
excel Beginner

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

#excel #xlookup #index match
👁 7 views
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...

#excel cash flow forecast #13 week cash flow #excel formulas
👁 7 views
excel Intermediate

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

#excel #cash flow #forecast
👁 7 views
Excel Intermediate

Project Timeline Gantt Chart

Design an Excel-based Gantt chart template for project tracking. Include: task l...

#Excel #Gantt #project management
👁 7 views
excel Advanced

ChatGPT prompt for creating an Excel employee attendance and leave tracker

Act as an Excel automation specialist with HR operations experience. Build an e...

#excel #attendance #leave tracker
👁 7 views
In-feed Ad336 × 280AdSense placeholder — will activate after approval
excel Advanced

ChatGPT prompt for creating Excel macros to automate repetitive report formatting

Act as an Excel VBA developer who writes clean, maintainable macros. Create VBA...

#excel #vba #macros
👁 7 views
excel advanced

Excel LAMBDA Custom Functions for Business Calculations

Create Excel LAMBDA functions for: 1) CAGR given start value, end value, and yea...

#lambda #custom-functions #excel
👁 7 views
excel Intermediate

Excel Data Validation and Dropdown Lists

Teach me how to create advanced data validation and dependent dropdown lists in ...

#data validation #dropdown lists #dependent dropdowns
👁 6 views
productivity Beginner

Meeting Agenda and Follow-Up System

Create a complete meeting management system — from agenda to follow-up. Meeting...

#meeting agenda #meeting notes #action items
👁 6 views
excel Intermediate

Conditional Formatting Rules for KPI Dashboards

I need to set up conditional formatting in Excel for a KPI dashboard. My spreads...

#conditional formatting #KPI #dashboard
👁 6 views
excel Advanced

Power Query: Merge and Transform Multiple CSV Files

I have a folder containing monthly CSV files (January.csv, February.csv, etc.) w...

#power query #CSV import #data transformation
👁 6 views
data Advanced

Automated Data Quality Report with Anomaly Detection

Create a data quality monitoring report for my dataset: - Data source: [e.g., '...

#data quality #anomaly detection #data monitoring
👁 6 views
education Beginner

Spaced Repetition Study Plan for Exam Preparation

Act as a cognitive science-informed study coach. Create a personalized spaced re...

#education #spaced repetition #study plan
👁 6 views
excel Advanced

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

#sales commission tracker #tiered commission excel #clawback formula
👁 6 views
excel Intermediate

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 list reconciliation #duplicate matching #near match cleanup
👁 6 views
excel intermediate

Build a Dynamic KPI Dashboard in Excel

Create a dynamic KPI dashboard in Excel for [business/department]. The dashboard...

#excel #dashboard #kpi
👁 6 views
excel intermediate

Excel Pivot Table Sales Trend Analysis

I have a sales dataset with columns: [Date, Region, Sales Rep, Product, Units So...

#excel #pivot-table #sales
👁 6 views
excel intermediate

Excel Pivot Table Design for Management Reporting

You are an Excel reporting expert. I need to build a professional pivot table re...

#excel #pivot-table #reporting
👁 6 views
excel Advanced

Dynamic Employee Shift Schedule with Drop-downs and Conflict Detection

Act as an Excel expert. Create a weekly employee shift schedule spreadsheet for ...

#excel #shift schedule #data validation
👁 5 views
productivity Intermediate

ChatGPT prompt for decision log from scattered Slack and email updates

Act as a project coordinator. I need to turn scattered Slack and email updates i...

#decision log prompt #slack recap to decisions #project coordination notes
👁 5 views
End-of-content Ad728 × 90AdSense placeholder — will activate after approval