Leaderboard Ad728 × 90AdSense placeholder — will activate after approval

📊 Excel & Spreadsheets Prompts

Formulas, reports, pivot tables, charts, VBA macros

75 prompts available
All Excel & Spreadsheets 75 Formulas & Functions 10 Reports & Templates 5 VBA & Macros 4 Formulas 3 Pivot Tables & Analysis 3 Dashboards & Visualization 2 Financial Modeling 2 inventory management 2 pivot-tables 2 Automation 2 dashboards 2 Power Query 2 Financial Modeling & Analysis 1 Power Query & Data Transformation 1 Dashboards & Reporting 1 Array Formulas 1 Lookup & Reference 1 What-If Analysis 1 Scenario Planning 1 Data Validation 1 Finance 1 Operations Scheduling 1 budget analysis 1 financial reporting 1 Templates 1 Scheduling & Planning 1 Revenue Analysis 1 Audit 1 Analysis 1 Financial Planning 1 Data Cleaning 1 Financial Tracking 1 Formatting 1 Charts & Visualization 1 Data Management 1 Operations Planning 1 financial forecasting 1 data reconciliation 1 hr tracking 1 Finance Tracking 1 Project Management 1 Analytics 1 sales operations 1 formula troubleshooting 1 VBA & Automation 1 Power Query & Automation 1
Showing 75 prompts
Reports & Templates Intermediate

Inventory Stock Report

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

#excel #inventory #stock
👁 11 views Open →
Formulas & Functions Beginner

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 Open →
Reports & Templates Beginner

Monthly Financial Report Template

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

#excel #financial report #monthly report
👁 10 views Open →
Reports & Templates Intermediate

Employee Attendance Tracker

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

#excel #attendance #tracker
👁 10 views Open →
Formulas & Functions Intermediate

INDEX MATCH as VLOOKUP Alternative

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

#excel #INDEX #MATCH
👁 10 views Open →
Formulas & Functions Intermediate

SUMIFS with Multiple Criteria

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

#excel #SUMIFS #multiple criteria
👁 10 views Open →
Formulas & Functions Beginner

Dynamic Date Formulas

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

#excel #date #DATEDIF
👁 10 views Open →
Reports & Templates Beginner

Weekly Sales Report with Charts

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

#excel #sales report #weekly
👁 9 views Open →
Formulas & Functions Intermediate

Text Manipulation Formulas

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

#excel #text #LEFT
👁 9 views Open →
In-feed Ad336 × 280AdSense placeholder — will activate after approval
Pivot Tables & Analysis Intermediate

Sales Analysis Pivot Table

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

#excel #pivot table #sales analysis
👁 9 views Open →
Audit Intermediate

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

#excel audit #formula debugging #reporting
👁 9 views Open →
inventory management Intermediate

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 #inventory #tracker
👁 9 views Open →
Reports & Templates Beginner

Project Budget Tracker

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

#excel #budget #project
👁 8 views Open →
Data Cleaning Intermediate

Clean Messy Data Checklist

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

#excel #data cleaning #TRIM
👁 8 views Open →
Financial Tracking Intermediate

Automated Invoice Tracker with XLOOKUP and Running Balance

Act as an Excel specialist. Build me an invoice tracking spreadsheet with these ...

#excel #invoice tracking #XLOOKUP
👁 8 views Open →
Formulas & Functions Beginner

VLOOKUP for Matching Data Between Sheets

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

#excel #VLOOKUP #formula
👁 7 views Open →
Pivot Tables & Analysis Advanced

Employee Performance Dashboard Pivot

Create a pivot table setup for employee performance analysis. Data columns: Empl...

#excel #pivot table #dashboard
👁 7 views Open →
VBA & Macros Advanced

Auto-Send Email Report VBA

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

#excel #VBA #macro
👁 7 views Open →
VBA & Macros 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 Open →
Templates Intermediate

Expense Report Template with Auto-Categorization

Create a comprehensive Excel expense report template with these features: 1. In...

#expense report #auto-categorization #budget tracking
👁 7 views Open →
formula troubleshooting 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 Open →
Automation Advanced

Invoice Generator with Auto-Numbering VBA

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

#invoice #VBA #automation
👁 6 views Open →
Formatting 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 Open →
financial reporting 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
👁 6 views Open →
End-of-content Ad728 × 90AdSense placeholder — will activate after approval